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!!!