Home » RDBMS Server » Server Utilities » Import Table with different tablespace (Help, Urgent)
Import Table with different tablespace (Help, Urgent) [message #72104] Sun, 09 March 2003 21:59 Go to next message
patrick
Messages: 83
Registered: December 2000
Member
I export one table with BLOB from one database (8.0.4) and then import to another database (8.1.7). The export process is success but the import process is failure due to the following errors:
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'USR' does not exist

I think it is because the tablespace is different in two database. I don't wanna to create another tablespace in the new database. Any method to solve it?
Re: Import Table with different tablespace (Help, Urgent) [message #72158 is a reply to message #72104] Fri, 28 March 2003 02:15 Go to previous messageGo to next message
wangsanjun
Messages: 13
Registered: June 2002
Junior Member
import fromuser=owner of table touser=target user
have a try.
export and import statement are welcome!
Import Tables from SYSTEM Tablespace to New tablespace [message #72536 is a reply to message #72104] Sat, 12 July 2003 02:15 Go to previous message
Deepak Bisht
Messages: 13
Registered: October 2001
Junior Member
I want to import data into tablespace NEW_TBS which was exported from tablespace SYSTEM.
Previous Topic: Error writing to badfile
Next Topic: Urgent Please Ignore Duplicate Appends..
Goto Forum:
  


Current Time: Tue Dec 24 20:56:59 CST 2024