Skip to Main Content

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!

Partitioned table question – why tablespace_name is null in user_tables

user12021554Apr 14 2010 — edited Apr 14 2010
I created a partitioned table:
CREATE TABLE test
(
SITEID VARCHAR2(8) NOT NULL ENABLE
)
tablespace MAXIMO
partition by LIST(siteid)
(
partition west_coast values ('CA1'),
partition ocd values ('OCDRA'),
partition jom values ('JOM'),
partition rar values ('PSGARA'),
partition site_null values (NULL),
partition site_unknown values (DEFAULT)
)
;
But when I go to user_tables,
Select table_name, tablespace_name from user_tables where table = ‘TEST’;
I get table_name but tablespace_name is NULL.
I know table is made of partitions and tablespace_name can be different for each partition,
But is there anyway to populate tablespace_name for table TEST.

I have a third party application, I want to do spartitiong on some large tables but somehow bendor’s code is looking at user_tables and stops working because tablespace_name is NULL.
I was under the impression that under the covers one can partition table (just like adding indexes) and
Third party application will remain working without problem.
Any ideas will be appreciated.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 12 2010
Added on Apr 14 2010
1 comment
1,390 views