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

Report message to a moderator

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: 10708
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.

Report message to a moderator

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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 20:53:46 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.