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


Please Help Members By Posting Answers For Below Questions

What authentication modes does sql server support? : sql server DBA

698


who owns the operating system files created by the utl_file package?

564


which background process invoke at the time of upgradation tell me???

2229


what is the diffrence between core dba and apps dba?

2091


what is ora 24313?what is the procedure to exclude that error?

2103






How would you extract DDL of a table without using a GUI tool?

2049


In what script is "snap$" created? In what script is the "scott/tiger" schema created?

1949


what is the last version,the release date of that version and fix pack of ibm db2 udb?

1521


What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

615


How can you control the amount of free space in your index pages? : sql server DBA

738


how does an oracle clusterware manage crs resources?

573


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

1647


What is a system database and what is a user database? : sql server DBA

600


when does an alert gets signaled?

582


How do you troubleshoot errors in a sql server agent job? : sql server DBA

568