Skip to Content

ORA-959 occurred in system import ( R3load)

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Nov 19, 2011 at 07:19 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.