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 authentication modes does sql server support? : sql server DBA
who owns the operating system files created by the utl_file package?
which background process invoke at the time of upgradation tell me???
what is the diffrence between core dba and apps dba?
what is ora 24313?what is the procedure to exclude that error?
How would you extract DDL of a table without using a GUI tool?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
how does an oracle clusterware manage crs resources?
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
What is a system database and what is a user database? : sql server DBA
when does an alert gets signaled?
How do you troubleshoot errors in a sql server agent job? : sql server DBA