Home » RDBMS Server » Server Utilities » Importing table in different database
Importing table in different database [message #269792] Mon, 24 September 2007 11:27 Go to next message
jsingh
Messages: 36
Registered: June 2007
Location: ny
Member
Hi all

I took export of one big partitioned table and tried to import in another database.
while importing it gave me following error

ORA-39083: Object type TABLE failed to create with error:
ORA-00959: tablespace 'SP_TBS1' does not exist

i have checked the tablespaces in source database from where i have taken the export.
This tablespace doesn't exist in source database also.

Can you please help me with this why it is looking for this tablspace in the target database if it is not there in source.

thanks in advance.

Mehtab
Re: Importing table in different database [message #269795 is a reply to message #269792] Mon, 24 September 2007 11:35 Go to previous message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
>This tablespace doesn't exist in source database also.
I'll believe Oracle before I'd believe a novice user.

post CUT & PASTE results from source database:
SQL> SELECT TABLESPACE_NAME FROM DBA_TABLESPACES WHERE TABLESPACE_NAME LIKE 'SP%';
Previous Topic: IMP-00010
Next Topic: How to dump table into XML format?
Goto Forum:
  


Current Time: Wed Dec 07 03:03:54 CST 2016

Total time taken to generate the page: 0.05208 seconds