Resize a tablespace to make it smaller
Hi,
I have a tablespace A which contains objects from different schemas. I want to move 1 table and it's indexes to another tablespace B.
After moving this table and indexes, i want to resize tablespace A - make it smaller since alot of data has been moved out.
How would I go about resizing the tablespace to make it smaller. What are the different steps necessary to achieve this?
Thank you!