What are the ways tablespaces can be managed and how do they
differ?
- 2 Answers
- 5827 Views
- IBM, I also Faced
- E-Mail Answers
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 the difference between clustered and non-clustered index? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What is fill factor? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what is the role of dip user in our database?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
How would you go about verifying the network name that the local_listener is currently using?
What is a correlated sub-query? : sql server DBA
what is the diffrence between core dba and apps dba?
how to restore files with rman?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
