All posts relating to Oracle database administration.

Moderator: Tim...


Postby royalyogi » Tue Sep 24, 2013 4:02 am

Need ur assistance on this.
I have a table with partitions and partitions have subpartitions.........i want to move this table to another tablespace.Does moving tables will move the partitions/subpartitions automatically OR i have to move them indivisually.
If i have to move them indivisually,wat would be the correct order?
Senior Member
Posts: 167
Joined: Tue Apr 23, 2013 3:59 pm

Re: subpartitions

Postby Tim... » Tue Sep 24, 2013 3:53 pm


You should probably move them a partition at a time. Order is not relevant.

Alternatively, move the whole table using a Online Table Redefinition.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:
Site Admin
Posts: 17953
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 3 guests