OraFAQ Forum: Server Administration » change tablespace of a table using dbms_redefinition

Home » RDBMS Server » Server Administration » change tablespace of a table using dbms_redefinition (11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

change tablespace of a table using dbms_redefinition [message #519291]

Wed, 10 August 2011 20:28

andy huang
Messages: 498
Registered: July 2011

Senior Member

Dear all,
Does dbms_redefinition can move the tablespace to another of a table,including indexes?

Report message to a moderator

Re: change tablespace of a table using dbms_redefinition [message #519292 is a reply to message #519291]

Wed, 10 August 2011 20:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

>Does dbms_redefinition can move the tablespace to another of a table,including indexes?
Does Andy know how to Read The Fine Manual?

Why do you prefer to read answers here instead of directly from the source?
http://tahiti.oracle.com

Report message to a moderator

Re: change tablespace of a table using dbms_redefinition [message #519297 is a reply to message #519292]

Wed, 10 August 2011 21:49

andy huang
Messages: 498
Registered: July 2011

Senior Member

Hi,
I can not open http://tahiti.oracle.com

Report message to a moderator

Re: change tablespace of a table using dbms_redefinition [message #519300 is a reply to message #519297]

Wed, 10 August 2011 22:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

andy huang wrote on Wed, 10 August 2011 19:49

Hi,
I can not open http://tahiti.oracle.com

What seems to be the problem why you "can not open" site?

from where did you get Oracle install media?

[Updated on: Wed, 10 August 2011 22:03]

Report message to a moderator

Re: change tablespace of a table using dbms_redefinition [message #519307 is a reply to message #519291]

Thu, 11 August 2011 00:24

dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA

Senior Member

Quote:

Does dbms_redefinition can move the tablespace to another of a table,including indexes?

I think this is what you want to know?

Quote:

if DBMS_REDEFINITION can move a table from one tablespace to another tablespace?

Regards
Deepak

Report message to a moderator

Previous Topic:	how to drop a column in a huge table
Next Topic:	Better Approach For Recmpile the Object

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 27 09:21:02 CST 2025