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:: Impact on code due to increase in database tablespace

We have a large table with 260 million records. The current size of the tables is 50 GB and that of tablespace in which table recides is 65GB. Once the size exceeds the limit, We will not be able to do any transaction on this table. Problem…
Vinayak Dornala
  • 1,609
  • 1
  • 21
  • 27
0
votes
2 answers

Optimizing large tablespace

We have a very large table LARGEHISTORY table which is having millions of records. Currently the table is using 50GB of table space and maximum allowed table space is 65GB in DB2 (DB2 v9.5.301.436). The table is growing very fast and we need to do…
Vinayak Dornala
  • 1,609
  • 1
  • 21
  • 27
0
votes
1 answer

Exporting PL/SQL Packages Through TTS

I am very new to dba tasks. I can export PL/SQL packages, functions, procedures from one database to another with expdp and impdp. But I need to export these objects(functions, procedures) by Transporting the tablespace(TTS) . I searched in…
Ayam
  • 43
  • 7
0
votes
1 answer

Create DB from scratch using dump without system tablespace

i have this scenario: Oracle 11g with ASM. Some days ago the disk where there were system's tablespace datafiles got broken and there is no way to recover them. I had a dump, made with "exp", of all data from all owner, except system user. Could i…
Daniele
  • 125
  • 1
  • 8
0
votes
1 answer

Compare 2 columns in 2 files and print the soustraction result

I'm trying to compare tablespaces sizes between 2 databases. I already extracted the needed field to compare as above: STAT-TBS-DB-SOURCE.lst: (column 1 : TBS Name, column 2 : real size) TBS001 12 TBS002 50 TBS003 20 TBS004 45 STAT-TBS-DBTARGET.lst…
hirondelle
  • 31
  • 5
0
votes
1 answer

IBM DB2 9.7 determining default tablespace

I have a DB2 9.7 database. I have defined any specific tablespace, so all tables go to USERSPACE1. Now I have created two new tablespaces and assign two tables to each of the two new tablespaces with the IN clause. However, now all the other tables…
user1340582
  • 19,151
  • 35
  • 115
  • 171
0
votes
0 answers

Moving Oracle objects between schemas (unicity constraints restrictions)

Actually on Oracle 10g. We could migrate to 12c if this can help us out. We 2 schemas : A_ADMIN and A2. Main schema is A2 which contains some synonyms pointing to A_ADMIN tables. We'd like to move referenced A_ADMIN objects to A2 schema so only one…
MensSana
  • 521
  • 1
  • 5
  • 16
0
votes
1 answer

Oracle backup and recovery tablespace

In Oracle 11.2 DB I have: - transaction table in tablespace users and - transaction_bkp table in trans_bkp tablespace Transaction table holds data for 1 month and transaction_bkp should hold data as long as possible. Problem is that trans_bkp…
sovadn
  • 15
  • 3
0
votes
1 answer

trigger to update object in different tablespace

I have a table X in tablespace T1 and a table Y in tabelspace T2.(Oracle DB) I have to create a trigger in tablespace T1 that will, on the event of updating a column C in table X, update column D in table Y (tablespace T2). Because they are in…
trivunm
  • 1,643
  • 4
  • 19
  • 21
0
votes
1 answer

Oracle IOT to mimic SQL Server composite clustered index

I would like my Oracle rows to be sorted in the exact ascending order of my composite primary key (WORK_DATE, EMP_ID). In SQL Server, creating a clustered index easily and magically solves the problem. At first glance, Oracle's ORGANIZATION INDEX…
0
votes
1 answer

use variable in psql while create tablespace

Here is the python create tablespace script, I need to use variable following LOCATION, PGSQL_HOME = raw_input('Type the tablespace location path :>') ctbsql = "CREATE TABLESPACE test OWNER tester LOCATION…
ourfirst
  • 1
  • 2
0
votes
1 answer

Oracle SQL DROP CREATE TABLESPACE error

so im trying to drop a tablespace temp with the command DROP TABLESPACE temp INCLUDING CONTENTS; but i get this error: tablespace 'temp' does not exist. however when i try and create the tablespace with this command CREATE TEMPORARY TABLESPACE…
user1459976
  • 207
  • 6
  • 14
0
votes
0 answers

How to permanently delete segments in oracle

In the segment advisor recommendations in oracle's enterprise manager (where you click on recommendation details per tablepsace), I seem to be seeing indexes/partitions/tables and schema names of objects which I already deleted/dropped prior to…
Avias
  • 354
  • 1
  • 4
  • 14
0
votes
2 answers

Is an Oracle tablespace the same as disk space, conceptually?

Oracle has the concept of a tablespace. Does a tablespace resemble actual physical storage space on the disk? If this is true, and I delete a million records from the database, will the space on the disk be freed up immediately?
Victor
  • 16,609
  • 71
  • 229
  • 409
0
votes
1 answer

How to rollback a CREATE TABLESPACE in Oracle 11g?

I executed: CREATE BIGFILE TABLESPACE tspvr010 datafile 'tspvr010.dbf' size 120g; but while that was working, my PC crashed (unexpected shutdown). When PC start again, the tablespace tspvr010 was not created, and tablespace USERS grow up by 30…
Netheril
  • 1
  • 1