alter table segment
A partitioned table was created such that the default tablespace is USERS, but the partitions are to go into tablespaces called DATA_1 for partition 1 etc. Now a generic program that tries to create new partitions tries to create new partitions as USERS_2 rather than DATA_2.
From the manual it appears that I can change the default tablespace with a segment attribute clause, but I find such a statement fails.
Would: alter table A move tablespace DATA solve the problem without impacting the partitions?
Any suggestions.
DB is 11gR2.
Thanks,
Janet