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 |
Can objects of the same schema reside in different tablespace?
what are the different types of cursors? explain?
what are the disadvantages of hierarchial database over RDBMS?
What is Partitions in Table ?
What privilege is needed for a user to delete rows from tables in another schema?
How to revoke create session privilege from a user in oracle?
How to create a stored program unit?
how to get the index id?
What is pragma autonomous transaction in oracle?
What is a subquery in oracle?
Describe an oracle table?
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?