exp/imp to defrag tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: exp/imp to defrag tablespace

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Posts
    151
    Hi All,

    I need some detail advise before I do defragmentation using exp/imp

    1. coldbackup first
    2. export all object in tablespace
    3. drop tablespace
    4. import data back with compress = Y

    Could anyone give some details about step3 ->recreate tablespace-> step4

    Did I miss any steps?

    I don't have any free space for my TABLE tablespace now. Before defragmentation, do I need add 1 more datafile?

    Please advise. This is kind of urgent.
    Elin@trend

  2. #2
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    while exporting you are to use compress = y.
    drop the tablespace and precreate with modified the default storage parameters for the datafile.
    do not forget to name the tablespace just like the old.

    sonofsita
    http://www.ordba.net

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    What version? There's easier ways to do this...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Apr 2001
    Posts
    151
    What version? There's easier ways to do this...
    oracle 7.3.4 on NT 4.0 sp-6
    Elin@trend

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