Database DataWarehousing (MOSC)

MOSC Banner

How to move partitioned table to new tablespace

edited Jan 14, 2010 1:26AM in Database DataWarehousing (MOSC) 5 commentsAnswered
I need to move partitioned table to a new tablespace without re-creating it. The table is range partitioned having 20 partitions. I can move all the partitions using 'alter table move partition..' command..but when I try to execute 'alter table <table_name> move tablespace <tablespace_name>' I am getting:
"ORA-14511: cannot perform operation on a partitioned object"

Is there any way to move the table to new tablespace.

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