does Oracle has only one table space?



does Oracle has only one table space?..

Answer / 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

Post New Answer

More Oracle General Interview Questions

What is a private synonym?

0 Answers  


Will you be able to store pictures in the database?

0 Answers  


Which Department has MOST NUMBER of employees?

8 Answers   IBM, LeadSquared, Mastek,


What is dynamic proxy?

0 Answers  


How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

0 Answers  






Difference between oracle's plus (+) notation and ansi join notation?

0 Answers  


According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?

2 Answers  


Why does oracle 9i treat an empty string as null?

0 Answers  


how to store only time in a data base table

2 Answers  


Can group functions be used in the order by clause in oracle?

0 Answers  


How to create a stored program unit?

0 Answers  


How to export your connection information to a file?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)