|
-
alter table move
I will give to you another sugestion : if the oracle database in runing in 8i,
you can perform the command alter table move tablespace.
I did this test:
create table test (a varchar2(30))
tablespace td_users
pctfree 10
pctused 40
storage (initial 10k next 10k pctincrease 0);
ALTER TABLE TEST MOVE TABLESPACE TD_TOOLS
PCTFREE 5
pctused 50
storage (initial 20k next 50k pctincrease 10);
The results were okay!
After that, you can move the table back to td_users.
Good luck!
Valentin
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
|