Home » RDBMS Server » Backup & Recovery » Restoring Schema's to another location
Restoring Schema's to another location [message #244656] Wed, 13 June 2007 11:35 Go to next message
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
Re: Restoring Schema's to another location [message #244657 is a reply to message #244656] Wed, 13 June 2007 11:37 Go to previous messageGo to next message
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.
Re: Restoring Schema's to another location [message #244665 is a reply to message #244657] Wed, 13 June 2007 12:36 Go to previous messageGo to next message
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:\\
Re: Restoring Schema's to another location [message #244673 is a reply to message #244665] Wed, 13 June 2007 13:35 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
move your datafiles from E:\ to F:\ and then import.
Previous Topic: SNAPSHOT CONTROL FILE & CONFIGURE CONTROLFILE BACKUP Differences:
Next Topic: RMAN recovery using a backup Control File and RESETLOGS concepts
Goto Forum:
  


Current Time: Thu Dec 08 10:28:56 CST 2016

Total time taken to generate the page: 0.08602 seconds