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

How to find the cause of sudden Undo TableSpace increase?

I use Oracle R12.1.3 on Oracle 10g DB 10.2.0.4 version hosted in IBM AIX 5.3 OS. Recently I found the data occupied in Undo TableSpace was suddenly increased. Please let me know what can be the cause of this sudden increase. If there is a query to…
ARGStackOvaFlo
  • 185
  • 1
  • 4
  • 16
0
votes
0 answers

Could not create tablespace in PostgreSQL 9.1

I can not create tablespace in PostgreSQL 9.1 Create tablespace rgu location '/postgresql'; ERROR: directory "/postgresql" does not exist. The rights to this folder are provided drwxrwxrwx postgres
0
votes
1 answer

using index tablespace?

I came across two code snippets : one... ALTER TABLE table_name DROP CONSTRAINT constraint_name; DROP INDEX index_name; alter TABLE table_name ADD CONSTRAINT constraint_name PRIMARY KEY (column, column) USING INDEX TABLESPACE…
Nisha Rajan
  • 9
  • 1
  • 1
  • 3
0
votes
1 answer

Best practices to be followed for Tablespace creation in oracle

In my current application all tables are mapped to USERS table-space. I don't have much idea on how to organize table-space efficiently. This is what I'm thinking: a. Based on row_counts, I'm planning to have three table-space. Small, Medium and…
Rakesh
  • 1,374
  • 1
  • 16
  • 24
0
votes
0 answers

Liquibase not picking up tablespace name in MySQL

I am trying to create a table in MySql using Liquibase. Below is the syntax I used, but Liquibase is not picking up the TABLESPACE at all.
sam
  • 17
  • 4
0
votes
0 answers

SQL to check the free space allocated for a user who doesn’t have DBA access in oracle 12c

SQL to check the free space allocated for a user who doesn’t have DBA access. preciously in oracle 11G it was possible to use the “user_free_space” View but from oracle 12 c this view access is restricted to DBA users. (source: Release changes) …
0
votes
0 answers

Can Oracle create the same tablespace from Instance A on Instance B?

Good day. I'm relative new to the Oracle world, we have a client that have 3 Services running and 1 Instance per Service, the problem that we have it's that the client wants to create a tablespace Alpha, which exists for Instance Alpha, in the…
lschaves
  • 23
  • 1
  • 4
0
votes
0 answers

Allow new user to access existing tables of a tablespace Oracle

I have created a new user in Oracle and want to give full privileges to this user for a particular tablespace i.e. see all tables/views, select, update, delete etc. that exist in the tablespace (whether those tables/views are created by any user, I…
WAQ
  • 2,556
  • 6
  • 45
  • 86
0
votes
0 answers

How can I backup an Oracle Tablespace and restore it as another tablespace in the same Schema

I am very new to oracle, I have an Oracle Schema (ORCL) that has two table spaces TBS_PROD TBS_TEST I want to backup TBS_PROD and then restore it into or as TBS_TEST. Is there a script or a tool that I can use? Regards Brian
0
votes
2 answers

How to create a tablespace only for schema's LOBs in Oracle database

I have a schema S linked to a default tablespace T1 in an Oracle database. I want to create another tablespace T2 only for LOBs linked to the same schema S. Is it possible? How can I do it?
Maghio
  • 355
  • 1
  • 6
  • 18
0
votes
2 answers

How to create a larger temporary tablespace?

I installed a DB2 Express C DB2 instance on my windows machine and use it in JUnit tests for testing some code. With one statement I get the following errorcode: DB2 SQL Error: SQLCODE=-1585, SQLSTATE=54048, SQLERRMC=null, DRIVER=4.15.134 I…
Jens Schauder
  • 77,657
  • 34
  • 181
  • 348
0
votes
1 answer

Optimize PostgreSQL table for seq scans

Suppose there is a table in PostgreSQL database: \d+ game_user Table "public.game_user" Column | Type | Modifiers | Storage…
0
votes
0 answers

Why InnoDB tablespace files gets corrupted?

MySql tables got corrupted with the following error, 016-05-17 09:57:07 30503 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/innodb_index_stats uses space ID: 2 at filepath:…
Bhupesh Pant
  • 4,053
  • 5
  • 45
  • 70
0
votes
0 answers

Oracle - Adding another bigfile datafile to a tablespace

The default bigfile datafile with the attribute of auto-extend has run out of disk space and I cannot extend the HDD space of that specific drive. Is there any way to add another bigfile to the same tablespace or another way around this issue?
0
votes
2 answers

Unable to assign user to tablespace in Oracle 12c

For some reason, I am not able to assign a user to a specific tablespace. I ran the following in Oracle SQL Developer against a local Oracle 12c. CREATE TABLESPACE tbs_sales DATAFILE 'C:\app\oracle\oradata\oradev\sales.dbf' SIZE 50M EXTENT…
sydney
  • 131
  • 8
  • 19