System tablespace fragmentation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: System tablespace fragmentation

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    80
    Picking up on an earlier thread "Coalesce"
    My system tablespace has 50 M used in a single datafile, which occupies 200M. Tablespace manger shows that there are two objects, owned by sys, located at the end of the datafile, with about 150M of empty space between them and the rest of the objects. Except for these two objects, all objects in the tablespace are located at the front of the datafile. Therefore about 150M of the datafile is effectively unused and is causing excessive time for backing up this tablespace.
    Can I reorganize this tablespace to put everything into the front of the datafile and free up the unsed space?
    I tried exporting several ways including exporting the owners of the objects (sys, and someone else) and a full database export, but the export terminates unsuccessfully, claiming ORA-600 (which apparently means call Oracle support).
    Any ideas?
    John Doyle

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    I wonder what a "move" would do?

    alter table sys.obj$ move tablespace system;
    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."

  3. #3
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    You cannot unfragment SYSTEM tablespace. Only option is rebuild the database with right Storage parameters.
    Thanks
    Kishore Kumar

  4. #4
    Join Date
    Oct 2000
    Posts
    80
    Jeft: Object type is cluster, cannot ALTER CLUSTER MOVE
    John Doyle

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