|
-
One more question
I used ALTER TABLE xyz ADD PARTITION part_jan VALUES LESS THAN (to_date('02/01/2002','mm/dd/yyyy')) and it worked fine. But I want to assign this partition to a specific tablespace. I tried this but it didn't work.
alter table xyz modify partition part_jan
tablespace abc;
*
ERROR at line 3:
ORA-14049: invalid ALTER TABLE MODIFY PARTITION option
How would I assign it to a tablespace?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|