|
-
Hi,
How many tablespaces/tables are currently stored in the datafile?
If you want to reduce the size of the datafile One option would be to
export all tables that are stored in the datafile.
drop the associate tablespaces/tables
delete the datafile
create the tablespaces again with the correct datafile size and autoextend off
import the tables.
Rgds
Moff
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
|