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?

Report message to a moderator

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!

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Error writing to badfile
Next Topic: Urgent Please Ignore Duplicate Appends..
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 10:05:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.