What are the ways tablespaces can be managed and how do they
differ?
Answer Posted / kittu
tablespaces can be managed in 2 ways 1) Dictionary Managed
2) Locally managed
In dictionary managed tablespace oracle will take care of tablespace
In locally managed tablespace we need to take care of tablespace
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
what is a user-defined lock?
How to start SQL Server in minimal configuration mode?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
How do you trace the traffic hitting a sql server? : sql server DBA
how can you initialize log miner?
What is the importance of a recovery model? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
what are the performance views in an oracle rac environment?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What happens on checkpoint? : sql server DBA
how can you communicate with operating system files from oracle?
What are the different ways you can create databases in sql server? : sql server DBA
What are the recovery models for a database? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
How do you open a cluster administrator? : sql server DBA