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
2
votes
2 answers

New oracle user can't access tables

I've just imported an ORACLE database into an instance of Oracle 10 XE running on a Linux system. The database has tables split across a number of tablespaces, and the sys user is able to access all the tables without problem. I've created a new…
Bryan
  • 3,224
  • 9
  • 41
  • 58
2
votes
2 answers

Free Up Space Oracle Tablespace (Users)

I'm newbie in Oracle Database. I want to ask related to Oracle Tablespace, especially for Users Tablespace. Every week, I always view and control the capacity of tablespace. However, tablespace user growth is very fast, so the size of the tablespace…
Ripki
  • 21
  • 1
2
votes
1 answer

Docker / Oracle Database / Volume Persistence / Create Table space

I am building a Dev Docker environment and I have to set up an Oracle 19c database. I have been successful... but not at 100%. Everything is running correctly, I can create a tablespace, a user/schema, create a table, insert data, access via NodeJs…
Jean-Philippe M
  • 731
  • 1
  • 7
  • 19
2
votes
1 answer

Best way to get the table space occupied by snowflake table

My current query to get the table space occupied by the tables in SAMPLE_DB is as below: use role accountadmin; use schema snowflake.INFORMATION_SCHEMA; SELECT table_name, sum(active_bytes) FROM "INFORMATION_SCHEMA".table_storage_metrics…
2
votes
2 answers

Errors creating Oracle DDL objects from script: "invalid common user or role name", "file already part of database" etc

I have a purpose: create some small model in Oracle consisting of two schemas. Every schema will contain 2-3 tables and 2-3 packages for functions. And I tried to write a script of creation required DDL objects, using DBForge. And here I have some…
Maxi-Hard
  • 89
  • 4
2
votes
2 answers

How to specify tablespaces and prefix for table names in apache activiti

I'm using activiti in my Spring Boot application: 'org.activiti:activiti-spring-boot-starter:7.1.0.M3.1'. By default, all activiti tables are contained in Spring Boot App database schema - Oracle 12.2 in my case. All activiti table names start with…
antropoff
  • 111
  • 2
  • 3
  • 14
2
votes
0 answers

Apache Camel JdbcAggregationRepository demands unproportionate TABLESPACE in Oracle 12C

I have a simple camel route. It polls a directory, reads a text file and splits the content of file line by line. Then it transforms each line (now having lesser no. of characters than original line) and aggregates the transformed lines (messages)…
Sanjeev Saha
  • 2,632
  • 1
  • 12
  • 19
2
votes
1 answer

DB2 - Move table from one to other tablespace

How could a table can be moved from one tablespace (16K page size) to another tablespace(32K page size) in DB2 version 10 onwards? I want to avoid the options like rename, create another table, copy data, drop renamed tables etc. In Oracle world the…
Koushik Chandra
  • 1,565
  • 12
  • 37
  • 73
2
votes
1 answer

How to grant user access to additional tablespaces in Oracle?

I want to know How to grant user access to additional tablespaces in Oracle? , because I have created two additional tablespaces, one for data and the other for indexes, like this discussion said: Tablespaces in Oracle I’m doing it for performance.
andrestoga
  • 619
  • 3
  • 9
  • 19
2
votes
1 answer

Move database location by symlink or new tablespace in postgres?

I'm building a small-medium database on a system that has 2 80 gb drives in raid 1 for the OS and 2 3 tb drives in raid 1 for the data. Is it better/safer to move the data over to the 3 tb drives using a symlink from postgres's data folder or…
McLuvin
  • 125
  • 2
  • 10
2
votes
1 answer

ORA-01652 error when fetching from cursor

I have a stored procedure where I use a cursor to loop through items in a temporary table: OPEN CURSOR_SCORE_ITEMS FOR SELECT ID_X, ID_Y FROM SCORE_ITEMS GROUP BY ID_X, ID_Y HAVING SUM(SCORE) > 10; …
Dirk. K.
  • 21
  • 2
2
votes
3 answers

Can oracle tablespaces automatically add smallfile datafiles?

Using Oracle managed files I can create my tablespace like this: CREATE TABLESPACE users; It will autoextend but as I understand it smallfile datafiles have a maximum size. So I then need to do: ALTER TABLESPACE users ADD DATAFILE; ALTER TABLESPACE…
Adam Butler
  • 3,023
  • 5
  • 35
  • 40
2
votes
1 answer

ORA-60019 : Creating initial extent of size 14 in tablespace of extent size 8

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production Seeking help from experts to resolve the following error: CREATE TABLE "BUILD_FILT" ( "BUILD_ID" NUMBER(38,0), "BUILD_NAME" VARCHAR2(200 CHAR), "BUILD_IMPL" CLOB )…
2
votes
0 answers

Move LOB tablespace on partitioned tables

Consider following tables: CREATE TABLE TAB_ONE ( MESSAGE CLOB, REC_DATE DATE, ) TABLESPACE DATA_TS; and CREATE TABLE TAB_TWO ( RESPONSE CLOB, PART_ID NUMBER, …
erewien
  • 349
  • 4
  • 15
2
votes
1 answer

How to find users in a particular tablespace in oracle 11g?

I have created a new tablespace and also some users. I have assigned those users to the tablespace. What is the query for finding out the users for the tablespace?
Somadder Abhijit
  • 85
  • 1
  • 3
  • 9