OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Alter Tablespace (Oracle SQL PLUS, 10g, Windows XP)

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

Alter Tablespace [message #488108]

Tue, 04 January 2011 21:37

getritesh
Messages: 235
Registered: July 2006
Location: INDIA

Senior Member

Hi,
My tablespace contains two datafiles dfile1.dbf and dfile2.dbf
on D drive of my filesystem.
Now i copied these dbf files on pasted it on a location in E
drive.
Now i want my tablespace to use dbf files pasted in new
location.

Will i have to Alter Tablespace Add Datafile with Reuse clause

Please guide me

Regards,
Ritesh

Report message to a moderator

Re: Alter Tablespace [message #488109 is a reply to message #488108]

Tue, 04 January 2011 22:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Now i copied these dbf files on pasted it on a location in E drive.

was the DB open at the time you copied the file?
Have you opened the DB since the file was copied?

Report message to a moderator

Re: Alter Tablespace [message #488113 is a reply to message #488108]

Tue, 04 January 2011 23:17

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Generally speaking you have to use
ALTER DATABASE RENAME FILE '...' TO '...';

But before file move either file must be put offline or the database shut down. Is this your case?

Regards
Michel

Report message to a moderator

Previous Topic:	restarting the listener and database
Next Topic:	Difference in SQL results from Oracle 9i to Oracle 11gR2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 08:38:03 CST 2024