OraFAQ Forum: Server Administration » Oracle DB and DATA file in different Drive (merged)

Home » RDBMS Server » Server Administration » Oracle DB and DATA file in different Drive (merged)

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

Oracle DB and DATA file in different Drive (merged) [message #247806]

Wed, 27 June 2007 05:04

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

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Please don't cross-post your questions.

Report message to a moderator

Re: Oracle DB and DATA file in different Drive (merged) [message #247857 is a reply to message #247806]

Wed, 27 June 2007 06:54

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Use dbca and follow the pages.

Regards
Michel

Report message to a moderator

Re: Oracle DB and DATA file in different Drive (merged) [message #248037 is a reply to message #247857]

Wed, 27 June 2007 17:45

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.

Report message to a moderator

Re: Oracle DB and DATA file in different Drive (merged) [message #248056 is a reply to message #247806]

Wed, 27 June 2007 22:28

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Rename 'old name' to 'new name';
Switch datafile all;

Report message to a moderator

Previous Topic:	STATPACK REPORT
Next Topic:	DBMS_REPAIR.SKIP_CORRUPT_BLOCKS with a IOT Table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 21:33:33 CDT 2024