-
Hi Pando,
I used "ALTER TABLESPACE XXX DEALLOCATE UNUSED KEEP XXK"
Ac
-
ops I really meant
Alter Table not tablespace... but nevertheless I can imagine how fragmentated is your tablespace, try resize the tablespace if you cant resize it to a small enough size then you would have to EXP/IMP I am afraid....
-
Pando,
Thanks again for the correction but I actually meant "ALTER TABLE..."
I don't thing that "ALTER TABLESPACE XXX RESIZE" is a valid command but please let me know if I'm wrong.
Ac
-
alter database datafile '/u01/xyzdata01.dbf' resize 1M;
Jeff Hunter
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
|