This forum is currently locked. You can't register or post questions at this time. (read more)

subpartitions

All posts relating to Oracle database administration.

Moderator: Tim...

royalyogi
Senior Member
Posts: 181
Joined: Tue Apr 23, 2013 3:59 pm

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?

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 2 guests

cron