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 |
what is the syntax of update command?
How to establish administrator authentication to the server?
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 ?
does the query needs a hint to access a materialized view?
how to retrieve 1st and last row of table without using group functions??
Is a rollback possible to any savepoint?
How to define default values for formal parameters?
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
What is E-R diagram ?
2 Answers CGI, Keane India Ltd,
How to check database size in Oracle?
Explain the use of indexes option in exp command.
Can a field be used in a report without it appearing in any data group ?