OraFAQ Forum: Backup & Recovery » Restoring Schema's to another location

Home » RDBMS Server » Backup & Recovery » Restoring Schema's to another location

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Restoring Schema's to another location [message #244656]

Wed, 13 June 2007 11:35

Rakesh.Bhambure
Messages: 2
Registered: June 2007

Junior Member

Hi ,

I want to restore Oracle schema in to another location
Current installation is on E:\\ and i want to restore new schema it on F:\\

Please let me know what are the new steps that needs to be executed for the restoring new schema in to new location as I m new to Oracle.

Thanks,
Rakesh

Report message to a moderator

Re: Restoring Schema's to another location [message #244657 is a reply to message #244656]

Wed, 13 June 2007 11:37

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

I want to restore Oracle schema in to another location

what do you mean by SCHEMA?

Are you want to say oracle directory/installation.

Report message to a moderator

Re: Restoring Schema's to another location [message #244665 is a reply to message #244657]

Wed, 13 June 2007 12:36

Rakesh.Bhambure
Messages: 2
Registered: June 2007

Junior Member

I want to restore XYZ.dmp file to f: \ and orcale is installed on E:\\ as it is showing some disk space proble. Please let me what is command for restroing it in F:\\

Report message to a moderator

Re: Restoring Schema's to another location [message #244673 is a reply to message #244665]

Wed, 13 June 2007 13:35

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

move your datafiles from E:\ to F:\ and then import.

Report message to a moderator

Previous Topic:	SNAPSHOT CONTROL FILE & CONFIGURE CONTROLFILE BACKUP Differences:
Next Topic:	RMAN recovery using a backup Control File and RESETLOGS concepts

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 15:57:31 CST 2024