Resize System Tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Resize System Tablespace

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Posts
    142

    Unhappy

    Hi,

    how do I increase the size of the System Tablespace?

    Thanks

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    ADD datafile...

    But before that check if there are objects in SYSTEM tablespace owned by users other than SYS or SYSTEM

    And if there are then try to relocate them, which will give you some free space in SYSTEM tablespace instead of immediately adding new datafile...

    Sameer

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Two options:

    a) resize the current datafile(s) belonging to SYSTEM tablespace

    ALTER DATABASE DATAFILE 'fileXYZ' RESIZE nnnn;

    b) Add new datafile to SYSTEM tablespace

    ALTER TABLESPACE system ADD DATAFILE 'fileXYZ' SIZE ....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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