Home » RDBMS Server » Backup & Recovery » how to import backup in case if i delete my system tablespace
how to import backup in case if i delete my system tablespace [message #63091] Thu, 09 September 2004 00:45 Go to next message
Unkn
Messages: 1
Registered: September 2004
Junior Member
hi Guys,

hope ur doing fine.

i m using oracle 9i. i have exported my full backup using exp utility. Now if i delete my system tablespace how to perform import for recovery.

Reply soon
Re: how to import backup in case if i delete my system tablespace [message #63096 is a reply to message #63091] Thu, 09 September 2004 05:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Objects created by sys are not exported.
Anyother foreign objects that are placed in system tablespace can be exported/imported using the regular methods.
Re: how to import backup in case if i delete my system tablespace [message #63105 is a reply to message #63091] Thu, 09 September 2004 11:42 Go to previous message
croK
Messages: 170
Registered: April 2002
Senior Member
When system tables is dropped, your entire db must be recreated, and you can do full import after that.

Best luck.
Previous Topic: RMAN BACKUP
Next Topic: where can i find rman material?
Goto Forum:
  


Current Time: Thu Mar 28 20:35:35 CDT 2024