Results 1 to 2 of 2

Thread: Table space

  1. #1
    Join Date
    May 2003

    Question Unanswered: Table space

    I am basically a programmer and doing DBA role also.

    Does the system table space extend automatically ?? if not how to increase the system table space?? I am using oracle 8i as my database

    All my tables are in the system table space. Is it possible to move them to a user defined table space. This database is online and critical.

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL


    The system tablespace does not extend automatically unless it was created with the AUTOEXTEND option.

    User objects should NOT be in system tablespace, create user tablespace and move non-system objects to this tablespace.

    At minimum you should create a DATA tablespace and an INDEX tablespace (optional but not required).

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts