Home » RDBMS Server » Server Administration » Dropping datafile
Dropping datafile [message #196913] Mon, 09 October 2006 02:23 Go to next message
gajini
Messages: 259
Registered: January 2006
Senior Member
Hi,

How to drop a datafile(data02.dbf) from a tablespace which is having two datafiles(data01.dbf,data02.dbf)?Is there any SQL command to do this?

Thanks,
Gajini
Re: Dropping datafile [message #196932 is a reply to message #196913] Mon, 09 October 2006 04:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96521/dfiles.htm#16235
Re: Dropping datafile [message #196990 is a reply to message #196932] Mon, 09 October 2006 08:20 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
In 10g release 2, you are now able to drop single datafiles from tablespaces.
Re: Dropping datafile [message #197027 is a reply to message #196913] Mon, 09 October 2006 11:01 Go to previous message
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
Member

u can't drop a single datafile from tablespace in 9i but in 10g it is possible

do one thing

1.take export of old tablespace
2.create a new tablespace wiht required datafile
3.import the dump to new tablespace
4.drop the old tablespace
Previous Topic: database clonnig (urgent)
Next Topic: How to see or what is query to see all parameter on Orcle DB
Goto Forum:
  


Current Time: Thu Dec 08 16:32:25 CST 2016

Total time taken to generate the page: 0.06726 seconds