Yesterday I upgrade the Production DB from 10gr1 (10.1.0.3.0) to 10gr2 (10.2.0.1.0) on Linux 4.
Upgrading process going fine and well. but after upgrading when I trying to export DB schema then I was getting below error
ORA-00959 tablespace '_$deleted$0$0' Does Not Exist
Then after I visit to metalink and found below metalink note: 604648.1
It is unpublish BUG.
Short Hint: Above Error occur after when we done below procedure after upgrade.
1. create new temp tablespace
2. make default temp tablespace to new one
3. drop old temp tablespace
4. rename new tablespace name to old tablespace name
After that we will get above error. for solution kindly visit mentioned metalink note.
"Teach Oracle Learn Oracle" -- Taj Contact me for support at askdbataj@gmail.com This blog is dedicated to all ORACLE Professionals and Learning Students.
Search This Blog
Saturday, August 9, 2008
ORA-00959 tablespace "_$deleted$0$0' Does Not Exist
Subscribe to:
Post Comments (Atom)
4 comments:
Hi Mohammed Taj,
Please check the temporary tablespace for the exported schema.
SQL > select username, temporary_tablespace from dba_users;
Thanks,
Sanjai
sanjay_g2005@yahoo.com
Thanks for sharing..
Babu
Hello Mr.Taj,
Thank you very much for informing...
thank for sharing
Post a Comment