Home » RDBMS Server » Server Administration » Oracle DB and DATA file in different Drive (merged)
Oracle DB and DATA file in different Drive (merged) [message #247806] Wed, 27 June 2007 05:04 Go to next message
karthi
Messages: 42
Registered: December 2000
Location: B'lore
Member

Hi,

I've installed oracle 10g db in D drive and i want the datafiles to be in E drive. How to do that one ?
How to tell to oracle db(which is installed in C drive), that datafiles are located in E drive. share your ideas and experience. Thank you.


-Karthik

[Updated on: Thu, 28 June 2007 08:21] by Moderator

Report message to a moderator

Re: Oracle DB and DATA file in different Drive (merged) [message #247810 is a reply to message #247806] Wed, 27 June 2007 05:08 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Please don't cross-post your questions.
Re: Oracle DB and DATA file in different Drive (merged) [message #247857 is a reply to message #247806] Wed, 27 June 2007 06:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use dbca and follow the pages.

Regards
Michel
Re: Oracle DB and DATA file in different Drive (merged) [message #248037 is a reply to message #247857] Wed, 27 June 2007 17:45 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
I've installed oracle 10g db in D drive and i want the datafiles to be in E drive. How to do that one ?


use RENAME COMMAND.
Re: Oracle DB and DATA file in different Drive (merged) [message #248056 is a reply to message #247806] Wed, 27 June 2007 22:28 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Rename 'old name' to 'new name';
Switch datafile all;
Previous Topic: STATPACK REPORT
Next Topic: DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table
Goto Forum:
  


Current Time: Thu Dec 08 16:31:05 CST 2016

Total time taken to generate the page: 0.14437 seconds