how to drop a datafile
628668Sep 1 2008 — edited Sep 1 2008in a article i saw this....
*"The datafile cannot be dropped by using the ALTER TABLESPACE...DROP DATAFILE statement. The DROP DATAFILE clause is not valid for the ALTER TABLESPACE statement."*
but when i drop a datafile from the EM console and look the sql query....is was like this...
ALTER TABLESPACE "TABLESPSP" DROP DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DB8888\QWERTY'
ALTER TABLESPACE "TABLESPSP" OFFLINE NORMAL
there it uses ALTER TABLESPACE with DROP DATAFILE.... statement
what this mean.....
This is the Explanation i got from the article...
To drop a datafile from the database, you should take the datafile offline by using the ALTER
DATABASE...DATAFILE...OFFLINE statement and then drop the datafile by using the ALTER DATABASE...DROP
DATAFILE statement.
The datafile cannot be dropped by using the ALTER TABLESPACE...DROP DATAFILE statement. The DROP DATAFILE clause is not valid with the ALTER TABLESPACE statement.