-
Hi ,
How do we defragment the tables with the nested columns,
can we do it seperatly and do the main table, will that improve the export/import performance ??? if so how do we do it ?
Arun
-
Try alter table move command.This is done deframent a table without export and import.
But i do not know whether it will work for nested tables.
Hope it works.If it works you will save lots of time and energy.
But if it works pls rebuild the indexes and triggers of the tables that are moved.
psl post the results whether you are able to do or not.
Radhakrishnan.M
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
|