OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » impdp error (linux oralce 7 oralce 11.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

impdp error [message #652869]

Tue, 21 June 2016 05:11

gbrunel
Messages: 3
Registered: June 2016

Junior Member

hello,
i'm newbie in oralce , and i have a full export ( expdp ) of my base and i want to put it on the clean server installed.
When i run my command

impdp system/pass@instance dumpfile=expdp.dmp logfile=imp.log JOB_NAME=impdp FULL=y

i'v got this error

Traitement du type d'objet DATABASE_EXPORT/TABLESPACE
ORA-39083: Echec de la creation du type d'objet TABLESPACE avec erreur :
ORA-02236: nom de fichier non valide
SQL en echec :
CREATE UNDO TABLESPACE "UNDOTBS1" DATAFILE SIZE 26214400 AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE
ORA-39083: Echec de la creation du type d'objet TABLESPACE avec erreur :
ORA-02236: nom de fichier non valide
SQL en echec :
CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE SIZE 648019968 AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576
ORA-39083: Echec de la creation du type d'objet TABLESPACE avec erreur :
ORA-02236: nom de fichier non valide
SQL en echec :

Could you help me please ..

Report message to a moderator

Re: impdp error [message #652871 is a reply to message #652869]

Tue, 21 June 2016 05:46

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Does the import complete and actually import your data? Those errors are merely informational. TEMP and UNDOTBS1 are typically created with the database. What does the following query yield?

SQL> SELECT tablespace_name, status, contents
     FROM dba_tablespaces;

Report message to a moderator

Re: impdp error [message #652872 is a reply to message #652871]

Tue, 21 June 2016 05:56

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

execute:

impdp system/pass@instance dumpfile=expdp.dmp JOB_NAME=impdp FULL=y include=tablespace sqlfile=t.sql

and post the content of t.sql.

Report message to a moderator

Re: impdp error [message #652874 is a reply to message #652872]

Tue, 21 June 2016 06:32

gbrunel
Messages: 3
Registered: June 2016

Junior Member

For gazzag

SYSTEM ONLINE PERMANENT
SYSAUX ONLINE PERMANENT
UNDOTBS1 ONLINE UNDO
TEMP ONLINE TEMPORARY
USERS ONLINE PERMANENT

Report message to a moderator

Re: impdp error [message #652875 is a reply to message #652874]

Tue, 21 June 2016 06:35

gbrunel
Messages: 3
Registered: June 2016

Junior Member

for michel

ALTER SESSION SET EVENTS '10150 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10904 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '25475 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10407 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10851 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '22830 TRACE NAME CONTEXT FOREVER, LEVEL 192 ';
-- new object type path: DATABASE_EXPORT/TABLESPACE
CREATE UNDO TABLESPACE "UNDOTBS1" DATAFILE
SIZE 26214400
AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M
BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

ALTER DATABASE DATAFILE
'/app/oracle/oradata/AXIBASE/datafile/o1_mf_undotbs1_coplj7fr_.dbf' RESIZE 230686720;
CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE
SIZE 648019968
AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576;
CREATE TABLESPACE "USERS" DATAFILE
SIZE 5242880
AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "AXIBASE" DATAFILE
SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "AXIINDEX" DATAFILE
SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;

ALTER DATABASE DATAFILE
'/app/oracle/oradata/AXIBASE/datafile/o1_mf_axiindex_cos48t7k_.dbf' RESIZE 629145600;
CREATE TABLESPACE "AXICCAMV20" DATAFILE
SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "CIR_DATA" DATAFILE
SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;

ALTER DATABASE DATAFILE
'/app/oracle/oradata/AXIBASE/datafile/o1_mf_cir_data_cos48wbf_.dbf' RESIZE 1048576000;
CREATE TABLESPACE "CIR_INDEXE" DATAFILE
SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "THE_DATA" DATAFILE
SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;

ALTER DATABASE DATAFILE
'/app/oracle/oradata/AXIBASE/datafile/o1_mf_the_data_cos48yjd_.dbf' RESIZE 1363148800;
CREATE TABLESPACE "AXIPMSI" DATAFILE
SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "AXIDATA" DATAFILE
SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;

ALTER DATABASE DATAFILE
'/app/oracle/oradata/AXIBASE/datafile/o1_mf_axidata_cos49074_.dbf' RESIZE 14260633600;
CREATE TABLESPACE "AXICIM" DATAFILE
SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "CONNECTDATA" DATAFILE
SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE "CONNECTINDEX" DATAFILE
SIZE 104857600
AUTOEXTEND ON NEXT 104857600 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO;

Report message to a moderator

Re: impdp error [message #652877 is a reply to message #652875]

Tue, 21 June 2016 07:42

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Quote:

Does the import complete and actually import your data?

Report message to a moderator

Re: impdp error [message #652878 is a reply to message #652875]

Tue, 21 June 2016 07:46

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

So the tablespaces already exist so the error is expected but its number is weird.

Does '/app/oracle/oradata/AXIBASE/datafile' directory exist?

Report message to a moderator

Previous Topic:	SFTP using PL/SQL
Next Topic:	To perform restore of two oracle database from a single backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 17:07:51 CST 2025