Oracle does not have one tablespace Minimum tablespaces in Oracle are SYS

does Oracle has only one table space?

Question Posted / oracledba

Answer Posted / oracledba

Oracle does not have one tablespace
Minimum tablespaces in Oracle are
SYSTEM,TEMP and UNDO - oracle 9i
SYSTEM,SYSAUX,TEMP and UNDO - oracle10g

Is This Answer Correct ?

6 Yes

4 No

Please Help Members By Posting Answers For Below Questions

what is difference between sql plus and sql*plus? (not sql and sql plus).

3812

What is tns entry?

1058

How to install oracle database 10g xe?

964

How to initialize variables with default values?

1158

How to start a new transaction in oracle?

1015

How do I reset a sequence in oracle?

1050

In what script is snap$ created? In what script is the scott/tiger schema created?

2654

Please explain joins in oracle?

1008

Is a rollback possible to any savepoint?

998

Point out the difference between user tables and data dictionary?

930

How to download oracle database 10g xe?

958

How to define an explicit cursor in oracle?

985

How to define a procedure inside another procedure?

960

What are the uses of synonyms?

1083

What privilege is needed for a user to create indexes in oracle?

963