Saturday, November 06, 2010

DROP a Datafile from a Tablespace

Starting with version 10.2 and higher You can now alter tablespace drop datafile (except first datafile of a tablespace).

Eg:
Alter tablespace TBS01 drop datafile '/dev01/oradata/dev01/data_04.dbf';




Regards,
Sukhwinder Singh


.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.