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
|
|
|
|
|
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
|
|
|