Honey I couldn't shrink the SYSTEM tablespace!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Honey I couldn't shrink the SYSTEM tablespace!

  1. #1
    Join Date
    Sep 2001
    Location
    Raipur, CG, India
    Posts
    1
    I couldn't shrink my 500MB SYSTEM tablespace. Only 100MB is actually is in use.

    I don't have enough reference material for this. Could I shrink/resize my SYSTEM tablespace.

  2. #2
    Join Date
    Aug 2001
    Location
    Hyderabad, India
    Posts
    29

    Smile

    No

    You can't shrink.
    Venkateshwarlu.K

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    Did you try doing it through DBA studio or something ??

    regards
    Hrishy

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    You can shrink segments in the SYSTEM tablespace. You can even shrink the SYSTEM rollback segment (but only if the DB is started in exclusive mode).


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