-
HOw to reorganize a table to avoid problem in future based on storage .please help me.
-
Either move the table, to a new tablespace or the same one:
ALTER TABLE my_table MOVE my_tablespace STORAGE (...);
This will rebuild the table with new storage parameters, but it does take quite a while for large tables and does require double the disk space during the process.
Alternatively you can export the table, drop the table, create a new table withe the correct storage parameters then import the data back in.
Are you sure you need to reorganize. Having multiple extents for a table is not a problem, especially if the tablespace is locally managed.
Cheers
-
Rember to rebuild the indexes on the table after your move the tables
www.cnoug.org
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
|