on 11-19-2011 7:00 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
User | Count |
---|---|
94 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.