Import error

[former_member429372]

Hi,

I am trying to import database to a new server with identical configuration and settings. In the import phase I am getting the following error.

(DROP TABLE "AANK")

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: ORA-1658 occurred when executing SQL statement (parse error offset=0)

(DB) ERROR: DDL statement failed

(CREATE TABLE "AANK" ( "TABNAME" VARCHAR2(10) DEFAULT ' ' NOT NULL , "VARKEY" VARCHAR2(110) DEFAULT ' ' NOT NULL , "DATALN" NUMBER(5) DEFAULT 0 NOT NULL , "VARDATA" BLOB ) TABLESPACE PSAPDAT LOB ("VARDATA") STORE AS (CACHE) STORAGE (INITIAL 131072 NEXT 0000000640K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

DbSlExecute: rc = 99

(SQL error 1658)

error message returned by DbSl:

ORA-01658: unable to create INITIAL extent for segment in tablespace PSAPDAT

(DB) INFO: disconnected from DB

E:\usr\sap\GTP\SYS\exe\nuc\NTAMD64\R3load.exe: job finished with 1 error(s)

E:\usr\sap\GTP\SYS\exe\nuc\NTAMD64\R3load.exe: END OF LOG: 20090310022223

Pls go thru and give your valuable feed back at the earilest

Regards

Sk

[Former Member]

Hi Dinesh,

Did you see the first error?

(DB) ERROR: DDL statement failed

(CREATE TABLE "AANK" ( "TABNAME" VARCHAR2(10) DEFAULT ' ' NOT NULL , "VARKEY" VARCHAR2(110) DEFAULT ' ' NOT NULL , "DATALN" NUMBER(5) DEFAULT 0 NOT NULL , "VARDATA" BLOB ) TABLESPACE PSAPDAT LOB ("VARDATA") STORE AS (CACHE) STORAGE (INITIAL 131072 NEXT 0000000640K MINEXTENTS 0000000001 MAXEXTENTS 2147483645 PCTINCREASE 0 ) )

This is showing that table or view does not exixt, just create this table using above qeury and retry.

It will solve below error and send us the result.

ORA00942: Table or view does not exist

Regards

Nick Loy

[Former Member]

If the hint of Nick doesn't help, and because you have autoextend on, i suggest you check your filesystem / disk space.

Best regards, Michael

[former_member429372]

Hi,

I am doing a homogenous system copy and export went through correctly and while import this data i have given the default values except the location of control files and log files. In the advance import parameter setting the following settings are displayed by default.

Tablespace autoext autoext autoext autoext

nextsixe maxsize Units

PSAPDAT ON 20 10000 M

PSAPDAT700 ON 20 10000 M

PSAPDATUSR ON 20 10000 M

SYSAUX ON 20 10000 M

PSAPUNDO ON 20 10000 M

PSAPTEMP ON 20 10000 M

SYSTEM ON 20 10000 M

SYSAUX ON 20 10000 M

Can I change the next extent of PSAPDAT700 and proceed? Pls revert

Regards

SK

[Former Member]

Hi,

first,

when you export, make SURE you are not using compress=y (the default). It'll

ballon up your tablespaces. The initial in the export is equal to the sum of all

ALLOCATED extents for the existing table.

2nd

if ALL files are filled up to the maximum of 10000 Mbytes how could it extend further?

Recheck the tablespace settings and adjust to your needs (maybe AUTOEXTEND UNLIMITED

and resert later).

bye

yk

[Former Member]

ORA-01658: unable to create INITIAL extent for segment in tablespace PSAPDAT

PSAPDAT seems to be full, please try to extend it and restart the import.

Best regards, Michael

[former_member429372]

Hi,

But I have given auto extend as 'ON' in the import parameter.

Regards

SK