OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Dropping datafile

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

Dropping datafile [message #196913]

Mon, 09 October 2006 02:23

gajini
Messages: 262
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

Report message to a moderator

Re: Dropping datafile [message #196932 is a reply to message #196913]

Mon, 09 October 2006 04:01

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96521/dfiles.htm#16235

Report message to a moderator

Re: Dropping datafile [message #196990 is a reply to message #196932]

Mon, 09 October 2006 08:20

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

In 10g release 2, you are now able to drop single datafiles from tablespaces.

Report message to a moderator

Re: Dropping datafile [message #197027 is a reply to message #196913]

Mon, 09 October 2006 11:01

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

Report message to a moderator

Previous Topic:	database clonnig (urgent)
Next Topic:	How to see or what is query to see all parameter on Orcle DB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:55:02 CDT 2024