DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Defragment nested tables

  1. #1
    Join Date
    Jul 2000
    Posts
    23
    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

  2. #2
    Join Date
    Sep 2000
    Posts
    384
    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
  •  


Click Here to Expand Forum to Full Width