standard tablespaces?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: standard tablespaces?

Hybrid View

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    standard tablespaces?

    select distinct tablespace_name from dba_tablespaces;

    TABLESPACE_NAME
    ------------------------------
    DRSYS
    INDX
    RBS
    SYSTEM
    TEMP
    TOOLS
    USERS


    are the above tablespaces the standard which means that any oracle installation will need the above tablespaces and the non-existence of anyone of them will cause hazards to the oracle db?

    thanks

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Only the SYSTEM is necessary. Try to create a database with SQL*PLUS using CREATE DATABASE without UNDO TABLESPACE and DEFAULT TEMPORARY TABLESPACE clauses.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

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