| Overwriting tables using impdp in Oracle 10g XE [message #168354] |
Thu, 20 April 2006 00:16  |
abmohan75
Messages: 7
Registered: October 2005
|
Junior Member |
|
|
Hello,
I am trying to import tables in the Table Space TREASURY. Already
it is having tables with data and I want to replace it. It is
having BLOB data also. I am giving the following command.
impdp treasury/treasury@treasury directory = dumpdir dumpfile = treasury.dmp logfile = import.log TABLE_EXISTS_ACTION=REPLACE
It gives the following error:
ORA-39083: Object type TABLE failed to create with error:
ORA-00959: tablespace 'TREASURY' does not exist
I will be very grateful, if someone suggest to rectify this
error.
Thanks,...
Regards,
Mohan
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
