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

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

1921

Explain what are synonyms used for?

606

what is reindexing?

1177

Explain what are the type of synonyms?

580

what is insert all statement in sql

5509

Can we protect our pl/sql source code?

572

How to apply filtering criteria at group level in oracle?

584

How to list all indexes in your schema?

578

Explain the difference between a procedure and a function? What do you understand by those terms?

620

How does oracle handle read consistency?

676

How do we get field detail of a table?

623

How to connect the oracle server as sysdba?

631

What is hot backup and logical backup?

607

How to do a full database export?

633

What is procedure overloading in oracle?

546