cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-959 occurred in system import ( R3load)

vishalranadive
Explorer
0 Kudos

Dear All,

We are doing system copy of our R/3 4.7 x200 system to upgrade the Windows os ( From win 2003 (32bit) to win 2008(64bit)).

Our oracle 9i database export got sucessful, but while importing on win 2k8 with ora 10.2.0.4 using R3load method we got following error at Database load stage :

__________________________

D:\usr\sap\SND\SYS\exe\run/R3load.exe: START OF LOG: 20111119111027

D:\usr\sap\SND\SYS\exe\run/R3load.exe: sccsid @(#) $Id: //bas/640_REL/src/R3ld/R3load/R3ldmain.c#27 $ SAP

D:\usr\sap\SND\SYS\exe\run/R3load.exe: version R6.40/V1.4

Compiled Jun 12 2010 02:23:15

D:\usr\sap\SND\SYS\exe\run/R3load.exe -dbcodepage 1100 -i C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\NUC\DB/SAP0000.cmd -l C:\Program Files\sapinst_instdir\R3E47X2\COPY\IMPORT\SYSTEM\ABAP\ORA\NUC\DB/SAP0000.log -stop_on_error

DbSl Trace: ORA-1403 when accessing table SAPUSER

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): WE8DEC

(DB) ERROR: DDL statement failed

(DROP TABLE "REPOLOAD")

DbSlExecute: rc = 103

(SQL error 942)

error message returned by DbSl:

ORA-00942: table or view does not exist

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace: Error 959 in exec_immediate() from oci_execute_stmt(), orpc=0

DbSl Trace: ORA-959 occurred when executing SQL statement (parse error offset=610)

(DB) ERROR: DDL statement failed

(CREATE TABLE "REPOLOAD" ( "PROGNAME" VARCHAR2(40) DEFAULT ' ' NOT NULL , "R3STATE" VARCHAR2(1) DEFAULT ' ' NOT NULL , "MACH" NUMBER(5) DEFAULT 0 NOT NULL , "UNAM" VARCHAR2(12) DEFAULT ' ' NOT NULL , "UDAT" VARCHAR2(8) DEFAULT '00000000' NOT NULL , "UTIME" VARCHAR2(6) DEFAULT '000000' NOT NULL , "L_DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "Q_DATALG" NUMBER(10) DEFAULT 0 NOT NULL , "SDAT" VARCHAR2(8) DEFAULT '00000000' NOT NULL , "STIME" VARCHAR2(6) DEFAULT '000000' NOT NULL , "MINOR_VERS" NUMBER(5) DEFAULT 0 NOT NULL , "MAJOR_VERS" NUMBER(10) DEFAULT 0 NOT NULL , "LDATA" BLOB , "QDATA" BLOB ) TABLESPACE PSAPSND620 LOB ("LDATA", "QDATA") STORE AS (CACHE) STORAGE (INITIAL 0000000016K NEXT 0000040960K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 959)

error message returned by DbSl:

ORA-00959: tablespace 'PSAPSND620' does not exist

(DB) INFO: disconnected from DB

D:\usr\sap\SND\SYS\exe\run/R3load.exe: job finished with 1 error(s)

D:\usr\sap\SND\SYS\exe\run/R3load.exe: END OF LOG: 20111119111027

__________________

Pls help.

Thanks & Regards,

Vishal

Accepted Solutions (1)

Accepted Solutions (1)

former_member188883
Active Contributor
0 Kudos

Hi,

ORA-00959: tablespace 'PSAPSND620' does not exist

Please check your DDLORA.TPL file. Does it have entry for this tablespace. Probably your source system has this tablespace.

If your source system has this tablespace and its blank you can simply remove this entry from relevant TPL file.

Hope this helps.

Regards,

Deepak Kori

former_member189725
Active Contributor
0 Kudos

Hi ,

Please check in the target system the tablespaces you have .

Change the release specific tablespaces (E.g PSAPES700D , PSAPSR3700 etc ) to the release specific ones you have in the target system in the DDLORA.TPL file located under /<EXP_DIR>/ABAP/DB. Restart the import after the change.

This has happened because the TAORA and IAORA tables have not been maintained correctly in the source system as the R3ldctl reads these tables to insert the TABART tablespace mapping in the DDL<DBS>.TPL file.

Edited by: Ratnajit Dey on Nov 19, 2011 1:54 PM

vishalranadive
Explorer
0 Kudos

Hello Deepak ,

Thanks for your prompt reply , but in our source system has this table space and it is not empty

TABLESPACE Total Allocated %-Alloc. Files Free areas Largest

-


PSAPPHE 104447856 92914200 89 51 10 2022336

PSAPPHE620 24575992 17116504 70 12 13 1920896

PSAPPHEUSR 819200 24888 3 1 3 506816

PSAPROLL 716800 74880 10 1 19 516880

PSAPTEMP 0 0 0 0 0 0

SYSTEM 767992 460560 60 2 4 246264

==============================================================================

Total 131327840 110591032 84 67 49

(Note : our source system is PHE and target is SND)

Regards,

Vishal

vishalranadive
Explorer
0 Kudos

Hi Ranjeet,

Thanks for your reply, but in target system we have got only following tablespaces

TABLESPACE_NAME

-


SYSTEM

PSAPUNDO

SYSAUX

PSAPTEMP

PSAPSND

PSAPSNDUSR

Regards,

Vishal

former_member189725
Active Contributor
0 Kudos

Vishal,

You target system is missing the tablespace PSAPSND620 which contain release specific tables . Please create the tablespace . The required syntax can be found in the tablespace creation logs in the SAP installation directory. The tablespace size should be approximately 20 GB.

The reason for this tablespace not being created may be because of the fact that the DBSIZE.XML file (/EXP_DIR/ABAP/DB/ORA/DBSIZE.XML) did not had entry and/or you did not select advance db configuration option in the sapinst dialogue during target installation which give you options to add tablespaces.

Edited by: Ratnajit Dey on Nov 19, 2011 9:15 PM

vishalranadive
Explorer
0 Kudos

Thanks a ton Ratnajeet !!! It really helped .....

Edited by: Vishal Ranadive on Nov 21, 2011 12:00 PM

Answers (0)