Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ALTER TABLE . modify default attributes tablespace - where in DICT ?

698658May 12 2010 — edited May 12 2010
Hi,
when I'm doing ALTER TABLE tab1 modify default attributes tablespace tbs1 ,
where is info about new 'default attributes' in oracle dictionary views?

Is that necessary step to set 'default attributes tablespace' after I move table partition to other tablespace ?
What are consequences of not setting that ?
Does same go to local index 'default attributes' ?
DBs are 9.2.0.8 and 10.2.0.3 .
Regards.
Greg
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2010
Added on May 12 2010
#general-database-discussions
8 comments
15,965 views