Tablespace
A tablespace is a storage location where the actual data underlying database objects can be kept. It is the physical portion of the database used to allocate storage for all DBMS managed segments. A database segment is a database object which occupies physical space such as table data and indexes. Once created, a tablespace can be referred to by name when creating database segments.
Tablespaces specify only the database storage locations, not the logical database structure, or database schema. For instance, different objects in the same schema may have different underlying tablespaces. Similarly, a tablespace may service segments for more than one schema.
By using tablespaces, an administrator can control the disk layout of an installation. A common use of tablespaces is to optimize performance. For example, a heavily used index can be placed on a fast SCSI disk. On the other hand, a database table which contains archived data that is rarely accessed could be stored on a less expensive but slower IDE disk.
While it is common for tablespaces to store their data in a filesystem file, some DBMS allow tablespaces to be configured directly over operating system device entries, called raw devices, providing better performance by avoiding the OS filesystem overheads.
Oracle example
In the Oracle RDBMS, tablespaces are created by the CREATE TABLESPACE command; for example:
- CREATE TABLESPACE index1 DATAFILE ‘/mnt/sda1/index1.dbf’ SIZE 100M ;
In Oracle, there are three types of tablespaces:
- Permanent tablespaces are the primary tablespace used to store the user’s database objects.
- Undo tablespaces are used by the DBMS to store data that can be used to undo uncommitted transactions, after a transaction is rolled back (either due to failure or explicitly requested rollback).
- Temporary tablespaces are used to store data with a short lifespan. They are used by the DBMS to manage space for database sort operations, and can also be utilized by users for storing global tables temporarily.
- Safe Skies Heavy Duty Luggage Lock by TravelPro at HSN.com Shop at home for Safe Skies Heavy Duty Luggage Lock by TravelPro or more Luggage from the Home Shopping Network.
- SearchAlert Classic Luggage Lock - (eBay item 330145611944 end eBay: Find SearchAlert Classic Luggage Lock in the Everything Else , Personal Security , Locks category on eBay.
- TSA Airline Approved Luggage Lock TSA, Airline Approved Luggage Lock, Style # 21090, Safety & Security, goinginstyle.com - 1000s of Travel Accessories, Bags, and Luggage.
- Luggage Tags, Luggage ID Tags, Luggage Locks & Luggage Straps Adventure travel store with a full line of travel accessories,luggage, clothing,maps,guidebooks,Eagle Creek,travel information,Lonely Planet,baggage.
- Luggage Locks / Travel Items / Promotional Products and Logo Items Promotional Luggage Locks 1 day or sooner with rush 1 day or sooner with rush (8) Promotional Luggage Locks 5 days or sooner 5 days or sooner (8)
- Travel Locks - Shop for travel luggage lock Traveling through busy airports today means you need the right luggage, luggage tags, and luggage locks and travel locks. Our selection of luggage locks
- TSA Luggage Lock, TSA Locks, TSA, tsa approved lock, tsa padlocks TSA Luggage Lock, TSA Locks, TSA, tsa approved lock, tsa padlocks, searchalert, search alert, tsa approved luggage lock, tsa approved padlocks, tsa approved
- TSA Accepted & Recognized Combination Luggage Locks from Travel Now TSA airport personnel can quickly unlock and inspect your checked luggage while eliminating the need of cutting off locks and without risking damage to
- TSA / Luggage Locks - LuggageOnline Luggage Online offers Luggage Locks & Security by Lewis N. Clark, Victorinox Swiss Army, Travelon, Eagle Creek, Briggs & Riley.
- TSA Approved Search Alert Luggage Lock TSA, TSA Approved Search Alert Luggage Lock, Style # 210100, Safety & Security, goinginstyle.com - 1000s of Travel Accessories, Bags, and Luggage.
- What are TSA Approved Luggage Locks? Brief and Straightforward Guide: What are TSA Approved Luggage Locks?

Discussion Area - Leave a Comment
You must be logged in to post a comment.