Data Pump Import errors
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 =
Here's my parfile parameter:
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.
Click Here to Expand Forum to Full Width