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

Thread: reorganize system tablespace

  1. #1
    Join Date
    May 2002
    Posts
    193

    reorganize tables in system tablespace

    Dear Sir,

    Can anybody list out the procedure involved in reorganizing the tables in system tablespace in oracle8.1.7.0.0 for windows advanced server 2000.

    Thanks,

    K.Diwakar

    [Edited by diwakar on 06-18-2002 at 01:19 AM]

  2. #2
    Join Date
    Jun 2002
    Posts
    64
    Hi,

    I think export/import is the way to do it. There are some articles on it in Metalink

    Cheers

  3. #3
    Join Date
    May 2002
    Posts
    193
    sir,
    Could you list out the procedure in detail for defragmentation by export/import..

    Also I do not have access to metalink and I shall be happy if you could copy a few of those stuffs and paste it here for reference...


    Thanks and Regards,

    K.Diwakar

    [Edited by diwakar on 06-18-2002 at 01:28 AM]

  4. #4
    Join Date
    May 2002
    Posts
    193

    Thumbs up

    when I import the dump file(compressed), I again get the same no. of extents. Hence could someone list out the changes that has to be made before importing the stuffs back.

  5. #5
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Cool

    1. export

    userid=
    file=
    log=
    compress=y
    tables=(.. , .. ,..)
    buffer=

    2. disable triggers on those tables

    3. disable fk constraints on those tables

    4. truncate those tables

    import
    --------

    userid=
    file=
    log=
    fromuser=
    touser=
    commit=
    feedback

    Follow if step by step, AND MAKE SURE YOUR EXPORT IS GOOD before truncating.
    Good ways of doing that are described Here

    Hope that helps,

    clio_usa
    OCP DBA 8/8i/9i
    visit our web site: Here




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