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

Is postgres faster than oracle?

980

How do I uninstall oracle client from windows?

968

How to define an oracle sub procedure?

1070

What to do if the startbd.bat failed to start the xe instance?

1026

How to open a cursor variable?

985

What is index in Oracle?

1022

Explain oracle data types with examples?

974

Explain the characteristics of oracle dba?

1071

Is truncate autocommit in oracle?

1037

How to enter a new row into a table interactively?

971

How to bring a tablespace offline?

1008

What is the difference between count (*), count (expression), count (distinct expression)?

968

How to define a data field as not null?

1072

How to set up autotrace for a user account?

988

What are the extensions used by oracle reports?

1002