Database Administration (MOSC)

MOSC Banner

Want to be sure that "drop tablespace <ts_name> including contents and datafiles;" only removes the

edited Nov 24, 2014 10:49AM in Database Administration (MOSC) 4 commentsAnswered ✓

Oracle 11g, with partitioned tables.  Looking to drop tablepaces and datafiles, but not the entire (partitioned) table.  For example:  Tablespace "JUN2003", for a table "SOMETABLE" with partitions in the JUN2003 tablespace, among others.  Only want to drop the partitions in that tablespace, datafiles, and the tablespace itself, without affecting other partitions in "SOMETABLE".

Seems logical that  "drop tablespace <ts_name> including contents and datafiles;" would only affect partitions in "<ts_name>", but thought I'd ask.  Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center