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

Can a formula column be obtained through a select statement ?

2105

How do I uninstall oracle client from windows?

753

How to specify default values in insert statement using oracle?

827

Oracle

2143

When do you get a .pll extension in oracle? Explain its importance

793

What is the max number of columns in an oracle table?

742

What is oracle latest version?

855

Can the query output be sorted by multiple columns in oracle?

768

What are the restrictions in a oracle read only transaction?

781

What is parameterized cursor in oracle?

822

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4218

How to test null values?

856

How to define an external table with a text file?

817

20. Using a set operator, display the client number of all clients who have never placed an order.

1989

How many types of segments in Oracle?

797