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 a nvl function? How can it be used?

789

Explain the different normalization forms?

836

How to create lov dynamically at runtime & attach to text field?

924

What is set verify off in oracle?

856

Explain what are the characteristics of data files?

844

How to convert csv to table in oracle?

757

What is the purpose of tables, private synonyms and public synonyms in Oracle?

835

Explain parameter file in oracle.

811

How many types of table in Oracle?

872

Explain the use of analyse option in exp command.

821

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2025

What are joins, explain all types of joins?

1973

Explain the use of rows option in imp command.

816

6. Display the client name and order date for all orders using the traditional method.

2042

What is an external table?

806