Home » RDBMS Server » Server Utilities » impdp error (linux oralce 7 oralce 11.2.0.4)
impdp error [message #652869] Tue, 21 June 2016 05:11 Go to next message
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 ..
Re: impdp error [message #652871 is a reply to message #652869] Tue, 21 June 2016 05:46 Go to previous messageGo to next message
gazzag
Messages: 906
Registered: November 2010
Location: Bristol, 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;
Re: impdp error [message #652872 is a reply to message #652871] Tue, 21 June 2016 05:56 Go to previous messageGo to next message
Michel Cadot
Messages: 65208
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: impdp error [message #652874 is a reply to message #652872] Tue, 21 June 2016 06:32 Go to previous messageGo to next message
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
Re: impdp error [message #652875 is a reply to message #652874] Tue, 21 June 2016 06:35 Go to previous messageGo to next message
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;
Re: impdp error [message #652877 is a reply to message #652875] Tue, 21 June 2016 07:42 Go to previous messageGo to next message
gazzag
Messages: 906
Registered: November 2010
Location: Bristol, UK
Senior Member
Quote:

Does the import complete and actually import your data?
Re: impdp error [message #652878 is a reply to message #652875] Tue, 21 June 2016 07:46 Go to previous message
Michel Cadot
Messages: 65208
Registered: March 2007
Location: Nanterre, France, http://...
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?

Previous Topic: SQL*Loader-485 (split from http://www.orafaq.com/forum/t/130372/0/unread/#msg_651651 by bb)
Next Topic: To perform restore of two oracle database from a single backup
Goto Forum:
  


Current Time: Fri Nov 24 23:26:30 CST 2017

Total time taken to generate the page: 0.03280 seconds