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 |
Post New Answer View All Answers
State some uses of redo log files?
How to best split csv strings in oracle 9i?
What is Segment Advisor in Oracle?
How to retrieve data from an explicit cursor?
What is a synonym? What are its various types?
How to use like conditions in oracle?
What is the difference between a hot backup and a cold backup in oracle?
How to list all tables in your schema?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is bulk collect in oracle?
How to delete an existing row from a table in oracle?
Explain the use of indexes option in imp command.
Differentiate between pre-select and pre-query?
How to use fetch statement in a loop?
What happens in oracle commit?