imp error temp tablespace

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

imp error temp tablespace

Roshan
Hi Erman,

I am importing some tables from Oracle 9i environment to 12c environment. Please find attached the logfile.

I see an error

IMP-00003: ORACLE error 25153 encountered
ORA-25153: Temporary Tablespace is Empty

I have created temporary tablespace temp, but I still get the error

There is also
ORA-20000: INDEX "OTC"."I_DOSLIGN_1" does not exist or insufficient privileges

Was the index skipped during export?

Regards,

Roshan
Reply | Threaded
Open this post in threaded view
|

Re: imp error temp tablespace

ErmanArslansOracleBlog
Administrator
Reply | Threaded
Open this post in threaded view
|

Re: imp error temp tablespace

Roshan
Thanks Erman