What is a tablespace?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What is a tablespace?

Rating:

A tablespace is a logical database structure for storing database segments. By default, each Oracle database has a single tablespace, known as SYSTEM, which stores data dictionary tables and indexes. Other tablespaces may also be configured for a database for performing some specific tasks such as:

  • Partial backup and recovery operation
  • Allocation of quotas for users
Additional tablespaces can also be created as per the requirements of the applications installed on the system. Such tablespaces can be used for storing application specific segments.


Rating:



Other articles

Click here to Article home

MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD Cisco Certification: CCNA, CCENT, A+, Network+, Security+

Oracle Certification: OCP 9i, OCP 10g, OCA 9i, OCA 10g, 1Z0-040: Upgrade to OCA 10g Fundamentals I, Oracle Fundamentals II, Admin I, Oracle Admin II, PL/SQL CIW foundation    EC-212-32    CISSP    Photoshop ACE    Adobe Flash ACE
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.
 
HACKER SAFE certified sites prevent over 99.9% of hacker crime.