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!

moving partioned tables to different tablespaces in oracle 11g.

817257Feb 20 2012 — edited Feb 20 2012

Dear All,
I need to move the partitioned table to different tablespace. I moved all the partitions individually and also the index.
however i have a issue now, when i check the view user_tables or dba_tables, i see null tablespaces correspomding to the table in the tablespace_name column.

how can i see the tablespace name in these views.

This post has been answered by Girish Sharma on Feb 20 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 19 2012

Added on Feb 20 2012

#general-database-discussions

2 comments

1,592 views