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
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Where do you find the default index fill factor and how to change it? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how can you get actual data change values from previous transactions in oracle?
What are the commands used in dcl? : sql server DBA
what is the use of recording information about current session?
how does an oracle clusterware manage crs resources?
internal architecture
what is grd?
what is ora 24313?what is the procedure to exclude that error?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
what is logical system in sap basis