Questions tagged [tablespace]

A tablespace is a database concept and refers to a storage location where the actual data underlying database objects can be kept.

A tablespace is a storage location where the actual data underlying database objects can be kept. It provides a layer of abstraction between physical and logical data, and serves 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. Sometimes it can be used to specify schema as to form a bond between logical and physical data.

cf. wikipedia

319 questions
-1
votes
1 answer

Allow a role to create objects in tablespaces

I am trying to assign to the role "computer" the permission to create objects in any less tablespace in the SYSTEM tablespace. Thank you very much and I hope I have explained correctly. I have tried the following query: GRANT CREATE ON ANY…
-1
votes
1 answer

Issue with UPDATE QUERY using EXISTS clause causing slow Tablespace scans in DB2

Our workplace has a database with a client table that holds 5 million records. Each time a client is updated, another row is added to a client_history table that holds 100 million records. All columns in the Client table are indexed. Only the…
Spacehamster
  • 195
  • 3
  • 13
-2
votes
1 answer

Tablespace free on multiple Oracle 12c databases

I am on operations, and I am trying to implement a way of checking total/free tablespaces on production tablespaces (oracle 12c) Are there any ideas on how could I implement it? Thanks : )
tln_jupiter
  • 153
  • 2
  • 8
-3
votes
1 answer

create tablespace for other user oracle

I am using Oracle 11g and SQL Developer. In my database I have 2 schemas: schema A (pretty similar as system) and schema B. In schema A I create another user: schema C. Here I want to add a tablespace immediately after what I create it. What I want:…
1 2 3
21
22