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

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

Sukhwinder Singh


No comments:

Post a Comment

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