| Importing table in different database [message #269792] |
Mon, 24 September 2007 11:27  |
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  |
 |
BlackSwan
Messages: 26766
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%';
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
