Default tablespace different than partitions
The default tablespace of the owner is users. A partitioned table was created, but only the tablespace for the partitions was specified, so the base table has a different tablespace than the partitions. This causes errors when splitting the the overflow partition. Can the default tablespace be changed without dropping and re-creating the table? Below are the basics of the table create. The DB is 11gR2.
create table owner.tableA
(field1 number
,field2 number
,field3 date);
partition by range (field3)
(PARTITION "PRT_20130521" VALUES LESS THAN (TO_DATE(' 2013-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE
create table owner.tableA
(field1 number
,field2 number
,field3 date);
partition by range (field3)
(PARTITION "PRT_20130521" VALUES LESS THAN (TO_DATE(' 2013-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION IMMEDIATE
0