Help - Search - Members - Calendar
Full Version: IMPDP Error
Oracle DBA Forums > Oracle > Oracle Forum
Manny
I am importing data from test to production with remap_tablespace... but keep getting error..ORA-00959: tablespace 'OS_DATA' does not exist.

Here is the parfile:

USERID=rad/moon@prod
full=y
TABLE_EXISTS_ACTION=REPLACE
directory=datapump
DUMPFILE=radnhd_%U.dmp
LOGFILE=radnhdimp.log
job_name=rad_imp1
REMAP_TABLESPACE=OS_DATA:ATTR_OS_DATA, ATTR_DATA:ATTR_OS_DATA

Note: the exported data were on os_data and attr_data tablespce and destination is attr_os_data.

Any suggestion what I am doing missing.

Thanks Guys
Steve
It looks like something 'slipped through the cracks' with impdp. Perhaps a partition, or some sort of object that Data Pump just missed.

Can you use the SQLFILE option to generate a file, we can look through and see where it is trying to use OS_DATA?
Littlewheat
Hi Manny,
in documentacion is note:

Oracle recommends that you enclose datafile names in quotation marks to eliminate ambiguity on platforms for which a colon is a valid file specification character.
Manny
QUOTE (Littlewheat @ Jul 9 2008, 08:12 AM) *
Hi Manny,
in documentacion is note:

Oracle recommends that you enclose datafile names in quotation marks to eliminate ambiguity on platforms for which a colon is a valid file specification character.


I exported the data from a window server and import to a window server (2003).
Manny
QUOTE (Steve @ Jul 9 2008, 07:47 AM) *
It looks like something 'slipped through the cracks' with impdp. Perhaps a partition, or some sort of object that Data Pump just missed.

Can you use the SQLFILE option to generate a file, we can look through and see where it is trying to use OS_DATA?



Here is the sqlfile. But the os_data is listed but remap_tablespace to the new tablespace does not work.Click to view attachment
SteveC
Have to ask the obvious: you are certain tablespace OS_DATA exists in the source database?
Steve
Neither of your remaps are working. I would try either wrapping all TBS names in double quotes, or post the command you're using to run the impdp so we can see it in full.
SteveC
Let's see the top part of the log file. The tablespace does not exist is my bet.

I exported scott and dropped the schema. I used a remap of users to users5 (a tablespace I know does not exist). The sqlfile will appear to be correct - it is only the SQL, no checks for actual existence take place when this is generated.

You are connecting to the wrong database, using the wrong schema, using the wrong file, or a combination thereof. It is cut and dry: the source tablespace does not exist for what you are trying to do.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": parfile=c:\admin\scott_impdp.par
Processing object type SCHEMA_EXPORT/USER
ORA-39083: Object type USER failed to create with error:
ORA-00959: tablespace 'USERS5' does not exist
Asma
QUOTE (Manny @ Jul 9 2008, 12:33 PM) *
I am importing data from test to production with remap_tablespace... but keep getting error..ORA-00959: tablespace 'OS_DATA' does not exist.

Here is the parfile:

USERID=rad/moon@prod
full=y
TABLE_EXISTS_ACTION=REPLACE
directory=datapump
DUMPFILE=radnhd_%U.dmp
LOGFILE=radnhdimp.log
job_name=rad_imp1
REMAP_TABLESPACE=OS_DATA:ATTR_OS_DATA, ATTR_DATA:ATTR_OS_DATA

Note: the exported data were on os_data and attr_data tablespce and destination is attr_os_data.

Any suggestion what I am doing missing.

Thanks Guys


can you add remap_schema too, in this parameter file like

REMAP_SCHEMA=RAD_NHD:RAD

let us know if it works ( or not)...
Manny
QUOTE (Asma @ Jul 9 2008, 12:17 PM) *
can you add remap_schema too, in this parameter file like

REMAP_SCHEMA=RAD_NHD:RAD

let us know if it works ( or not)...


Ok, this time I got this error....
With the Partitioning, OLAP and Data Mining options
Master table "RAD_NHD"."RAD_IMP1" successfully loaded/unloaded
Starting "RAD_NHD"."RAD_IMP1": parfile=c:\datapump\import\impdp1.par
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"RAD_NHD" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

and has been here to almost 10 min. Should I drop the master table and try again?
Asma
QUOTE (Manny @ Jul 9 2008, 06:44 PM) *
Ok, this time I got this error....
With the Partitioning, OLAP and Data Mining options
Master table "RAD_NHD"."RAD_IMP1" successfully loaded/unloaded
Starting "RAD_NHD"."RAD_IMP1": parfile=c:\datapump\import\impdp1.par
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"RAD_NHD" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

and has been here to almost 10 min. Should I drop the master table and try again?


try:
exclude=USER:"='RAD_NHD'"

in your command.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.