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
0
votes
1 answer

DB2 create table and insert in tablespace

my DBA created three different tablespaces in DB2 in order to store the same table (TABLE_IN_TBS), switching on a date field. CREATE LARGE TABLESPACE "TBS_x" IN DATABASE PARTITION GROUP NODO0 PAGESIZE 32768 MANAGED BY DATABASE USING (FILE…
Nko
  • 341
  • 1
  • 7
  • 18
0
votes
2 answers

Import dmp tablespace name must fit the old?

The Oracle new tablespace name must fit with the old tablespace name? For example: The dump file tablespace name is A,and i create a new tablespace B,and it could import table, but has many error? ORA-00959:tablespace 'ECASYS'(old) not…
Dolphin
  • 29,069
  • 61
  • 260
  • 539
0
votes
1 answer

Use PDO to open a PostgreSQL database in a defined tablespace

OK... looked through all of the Q&A's on PostgreSQL and PDO, but no luck answering my question... same problem finding the answer through Google. Thus I lay my query at the feet of the masters. I am just getting started with PostgreSQL, coming from…
Steve
  • 580
  • 7
  • 14
0
votes
1 answer

Oracle Tablespace Size Increment

How to increase the size of table space post its max limit. if the max limit is defined as 100M and still later I need to increase it. I have written a query consisting of max size of 100M and now i want to increase it..Please let me know method for…
0
votes
1 answer

DB2 - How to ensure the tablespace is clean to drop

For some reason, I have created a few tablespaces for testing in DB2, I realized that if I didn't specify which tablespace the table should be created in, DB2 will select it for me. The question is, I want to delete the unused tablespace, but I am…
coldholic
  • 161
  • 2
  • 3
  • 12
0
votes
0 answers

Is oracle tablespace locked during DDL operations?

Given that there is a single tablespace pointing to one file, and there are many schemas pointing to that tablespace and there are many simultaneous jobs doing heavy DDL operations (dropping database, dropping indexes, creating a large database…
Adam Soliński
  • 444
  • 1
  • 8
  • 19
0
votes
3 answers

Trigger to get the tablespace query before creation?

I would like to obtain the query before tablespace creation using trigger. Searching through web didn't provide enough info. So, it will be a great help if someone throw some light on this. I have a procedure xyz which i want to be invoked before…
bprasanna
  • 2,423
  • 3
  • 27
  • 39
0
votes
1 answer

DB2 - LUW 8.2 Can you restore one tablespace from a full DB backup to a different server

In DB2 8.2 for LUW can you restore one tablespace to a 2nd server from a full database backup without having to restore the entire database? The database backup was taken when the system was up so log files are involved. I can provide further…
David R.
  • 3
  • 2
0
votes
1 answer

How to cretae Buffer Pool in Database dedicated only for ONE BIG table?

I have table TICKET with 400K records in database (DB2). I wish to create one huge buffer pool which will be dedicated only to this one big table for faster response. What are the steps to do it? Also at the moment I have one Buffer Pool which…
Stefke
  • 141
  • 8
  • 19
0
votes
1 answer

Are tablespaces associated with user accounts?

I have very basic question related to tablespaces. When I was creating a user, I was asked to assign a default tablespace for this account. So, I assigned a previously created tablespace (TABLESPACE1). If I create another user and assign a…
KItis
  • 5,476
  • 19
  • 64
  • 112
0
votes
1 answer

How to set the table space of a sub select in PostgreSQL

I have a rather large Insert Query, and upon running this my slow disks fill up towards 100% upon where I revive: Transaction aborted because DBD::Pg::db do failed: ERROR: could not write to hash-join temporary file: No space left on device Sounds…
Arthur
  • 3,376
  • 11
  • 43
  • 70
0
votes
2 answers

Oracle: Insufficient privileges on inserting data into tablespace tables

I'm a little new to all this... I want to create a new tablespace that will contain all my tables and indexes. first the tablespace code.. create tablespace Sales_T datafile 'C:\oracle\product\10.2.0\oradata\project\dataexample.dbf' size…
omorfopanta
  • 3
  • 1
  • 3
-1
votes
1 answer

Postgres and Tablespace and indexes

I want to ask if its possible that a situation where the main table is in a different tablespace from the index if it affects performance. i have a senario where a large table 250GB is in a tablespace and the indexes (3) with an average size of 40GB…
-1
votes
1 answer

DB2 Z/OS - Rename Tablespace

I use DB2 Z/OS 11.01. It's possible to rename a tablespace already defined on DB2 z/OS? From the documentation I don't see any constraints but I can't. Below I show you my test case: I create a TS, a table and an index. -- CREATE TABLESPACE…
killer
  • 11
  • 6
-1
votes
1 answer

To find oracle db temp tablespace used size which table is correct? V$TEMP_EXTENT_POOL or V$SORT_SEGMENT

Can anyone help me in finding temp tablespace used size? Which query will return correct value from below? SELECT t.tablespace_name,df.allocated_bytes as ALLOCATED_BYTES,decode(sign(df.allocated_bytes-NVL(f.used_bytes,0)),1,df.allocated_bytes -…
Anna
  • 71
  • 1
  • 10
1 2 3
21
22