-
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
-
Only the SYSTEM is necessary. Try to create a database with SQL*PLUS using CREATE DATABASE without UNDO TABLESPACE and DEFAULT TEMPORARY TABLESPACE clauses.