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
Printable View
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.