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

Thread: export/import or create as select

  1. #1
    Join Date
    Jun 2000
    Posts
    55
    We have a table of 1GB large and we want to defragment it. I always used create as select for all our previous tablespace reorg efforts. But this time I want to try something different. We only need to reorg this one table. What are the things I have to think of if we go for the export/import approach? Which approach would you recommend in this case?

    Thanks a lot

    Qingbo

  2. #2
    Join Date
    Sep 2000
    Posts
    305
    better to go for import export utility that it will ask for compress y/n so just give yes

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