-
Data Pump Import errors
Hi,
I was unable to import tables using Data Pump.
It seems to be importing the tables in tablespace AAA (which does not exist) when i specify a remap_tablespace clause to import the tables to tablespace BBB. I've ensure that the default tablespace for my user is tablespace BBB.
SQL> select default_tablespace from dba_users where username =
'DATA_USER;
DEFAULT_TABLESPACE
------------------------------
BBB
Here's my parfile parameter:
DIRECTORY=dtpump
DUMPFILE=expdp_tables.dmp
LOGFILE=impdp_tables.log
remap_schema=main_user:data_user
remap_tablespace=main_user:bbb
EXCLUDE=STATISTICS
Here's the error message in the logfile:
ORA-39083: Object type TABLE failed to create with error:
ORA-00959: tablespace 'AAA' does not exist
Any help will be greatly appreciated. Thanks!!!
-
create empty table in desired tablespace, them import it.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|