Hi Pando,
I used "ALTER TABLESPACE XXX DEALLOCATE UNUSED KEEP XXK"
Ac
Printable View
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;