Printable View
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
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.
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.