subpartitions

All posts relating to Oracle database administration.

Moderator: Tim...

subpartitions

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?
royalyogi
Senior Member
 
Posts: 167
Joined: Tue Apr 23, 2013 3:59 pm

Re: subpartitions

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

Hi.

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

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

Cheers

Tim...
Tim...
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: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
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

cron