-
I am trying to Import Oracle 7.3.3 tables into Oracle 8.1.6
using IMP. However I keep gettin this error:
Cannot import permanant tables into temporary tablespace.
Why am I getting this error and does anybody know how to by-pass this so I can get these tables into my database?
thanks,
scotta
J.Scott Adams
-
The main reason is that, your import data (of course the table) is trying to get imported into Temp. tablespace.
Which is not possible.
Just ensure the error messge in detail , if possible please cut and paste the screen error message, so that we can probe further.
Thanx
Ramesh.
______________________________
There is nothing Impossible.
Even Impossible says
I M POSSIBLE
-
Is the default tablespace for objects that the target user creates defined as temporary?
-
1) Determine which objects that IMP is trying to build in a temporary tablespace
2) Pre-build them in a permanent tablespace
3) run your import with ignore=Y
-John
-
Check the old database tablespaces are exist in new database! If then post the import file, We can see further. Don't forget to post error message.
sree
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|