Database DataWarehousing (MOSC)

MOSC Banner

Avoidance of ORA-14511 in partitioned tables

edited May 18, 2012 1:49AM in Database DataWarehousing (MOSC) 5 commentsAnswered
We wish to elimnate tablespace TS_EXF

We have a partitioned table EXF.PART_TABLE

We can move the partiones by

ALTER TABLE EXF.PART_TABLE MOVE PARTITION PART01 TABLESPACE TS_EXF_PART;

This leaves part_table itself still in TS_EXF

When we try this

    ALTER TABLE EXF.PART_TABLE MOVE TABLESPACE TS_EXF_PART;

we get

ORA-14511: cannot perform operation on a partitioned object

which I would assume means we better not eliminate TS_EXF

My question is, ¿how do we disassociate the table exf.part_table from the tablespace TS_EXF in order that we can delete the Tablespace in question?

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