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

Using tablespaces in HSQLDB

Is there a way in which we can use the tablespace concept of Oracle in HSQLDB? I have some Oracle scripts which uses tablespace concepts. I want to convert them such that they can be used with HSQLDB too.
Rohit Jain
  • 159
  • 1
  • 4
  • 12
4
votes
4 answers

Why does DB2 suggest one table per tablespace?

The DB2 docs for DB2/z v10 have the following snippet in the tablespaces section: As a general rule, you should have only one table in each table space. But it doesn't actually provide any rationale for this. We have some tables storing historical…
paxdiablo
  • 854,327
  • 234
  • 1,573
  • 1,953
4
votes
1 answer

Oracle Segment Does Not Equal Extents?

For a given tablespace, why doesn't the sum of bytes in dba_extents equal the sum of bytes in dba_segments? (additional questions after sample script.) SQL> with "SEG" as ( select 'segment_bytes' what , to_char(sum(bytes),…
Alex Bartsmon
  • 471
  • 4
  • 9
4
votes
2 answers

Location of the table space files?

How can I find the directory in which oracle stores it's table space files? When I do: select * from dba_data_files; or select * from v$datafile; then I get some paths like that: +DATA01/fu/datafile/bar_ts01_data.260.264360912 But what means…
eztam
  • 3,443
  • 7
  • 36
  • 54
4
votes
2 answers

ORA 01114 - IO Error writing block to file

I am working on some compelex sql queries in Oracle 11g, which have aggregation functions like SUM and joins multiple tables and views. I am getting the IO Error and Tablespace insufficient space error when I try to query large span of data. Error…
StarJedi
  • 1,410
  • 3
  • 21
  • 34
3
votes
2 answers

Lucene Indexing from Oracle:ORA-01652: unable to extend temp segment

I met a problem when using Lucene to build full-text index of the data from the Oracle 11g database, with the following information: "ora-01652 unable to extend temp segment by 128 in tablespace temp, on MDSYS.SDO_RDF_TRIPLE_S", line 608" The total…
Chen Xie
  • 3,849
  • 8
  • 27
  • 46
3
votes
2 answers

How to find the total tablespace usage in SQL Server 2008?

In SQL-server 2008, How would I find (through an SQL query), the percentage of tablespace usage for a particular instance(or all instances) of a SQL Server(2008 R2)? Also, what is the best way (query) to get the list of all the Named Instances of a…
LittleLebowski
  • 7,691
  • 13
  • 47
  • 72
3
votes
1 answer

LOBSEGMENT objects filling up my tablespace in Oracle

I'm using a Oracle 10gR2 DB, and was taking a look in one of my tablespaces when I noticed something odd. Apart from my table objects, I found a bunch of "LOBSEGMENT" types if quite big sizes - one of then with 17gb. I'm no expert in Oracle, and…
filippo
  • 5,583
  • 13
  • 50
  • 72
3
votes
4 answers

Postgres database size much bigger than tablespaces on filesystem

I have a Postgres 8.3 instance with tablespaces totalling on about 74G. This is fine. But if I ask postgres how big my database is, I get a (unexpected) large answer: 595 GB. This seems very strange. Disk I/O tests on the system are in the…
Rob Audenaerde
  • 19,195
  • 10
  • 76
  • 121
3
votes
1 answer

Tablespaces used to create a materialized view?

I'm trying to create a view as such: CREATE MATERIALIZED ReasonableSizedView TABLESPACE MyMediumTS AS select COUNT(something) AS allsomethings, thetype AS thing, status from SomeMassiveTable where thetype = 'x' AND status IN…
filippo
  • 5,583
  • 13
  • 50
  • 72
3
votes
1 answer

Postgresql: create view and use of default tablespace?

When I try to create a view in PostgreSQL 13 I get an error saying: "permission denied for tablespace tbs_dft". As you can see I've changed the system default tablespace. The problem is easy to fix by granting create on tablespace 'tbs_dft'. But…
user108168
  • 165
  • 5
3
votes
0 answers

MySQL table(space) exists but can't discard

Since I had some problems with my database, I tried to drop the database. When that didn't work, I removed my database folder in C:/xampp/mysql/data. I used SHOW TABLES and it said no tables in my database. Now the problem is, first time importing…
Joshua Bakker
  • 2,288
  • 3
  • 30
  • 63
3
votes
2 answers

Postgresql: cannot create tablespace due to permissions

I know there has been a dozen times a similar question, but I could not find an answer that worked for me. I have a Debian 9 machine, fresh from install on which I have installed a Postgresql 9.6 server. I am trying to create a new tablespace but it…
Darth Kangooroo
  • 372
  • 1
  • 3
  • 18
3
votes
1 answer

How to grant user space resource on the tablespace in oracle 12c

I had created a user in oracle 12c standard edition. Now I tried to create a table using the username and password in sql developer, but I am getting the following error. SQL Error: ORA-01950: no privileges on tablespace 'USERS'01950. 00000 - "no…
Prasanth G
  • 63
  • 1
  • 2
  • 8
3
votes
0 answers

InnoDB: Failed to find tablespace for table

Does anyone have a fix to the problem mentioned in the subject. I recently switched from MySQL to MariaDB and all was fine till suddenly I could no longer connect to the database. There was absolutely no changes made in any settings but MariaDB just…
R.W
  • 530
  • 1
  • 12
  • 34
1 2
3
21 22