Skip to main content
The 2024 Developer Survey results are live! See the results

Questions tagged [tablespaces]

A database storage unit that groups related logical structures together.

Filter by
Sorted by
Tagged with
-1 votes
0 answers
12 views

why pgAdmin4 Tablespace Security privileges does not count for pg_default if no tablespace is selected when creating new database? how to solve this?

why pgAdmin4 Tablespace Security privileges does not count for pg_default if no tablespace is selected when creating new database? how to solve this issue? Hy all -I have a server dedicated to ...
Ervin's user avatar
  • 1
0 votes
2 answers
72 views

DB2 Tablespace has no space SQLcode -960 SQLState=57011

Our application is inserting and updating records into a DB2 database. It's been running for about 3 years, and we encountered an error SQLcode -960 SQLState=57011 SQLERRMC=IS_SMALL_TS The tablespace ...
Effendi Baba's user avatar
0 votes
1 answer
33 views

Oracle temporary tablespace performance

I'm looking for ways to improve my database performance for heavy analytical queries and found that my temp tablespace has 1M extents (default for uniform tablespace). With my usual temp tablespace ...
Andy DB Analyst's user avatar
0 votes
0 answers
33 views

How to Determine the Low High Water Mark (LHWM) in Oracle DB?

How could one determine the position of the Low High Water Mark (LHWM) for a non-partitioned heap table segment in Oracle? I am concerned, that if we only do direct path inserts and never update, ...
Alex Bartsmon's user avatar
0 votes
0 answers
35 views

Create an index at oracle sql server on tablespace

I want to create an index of type context on a tablespace different from the one the table is. Also I want to pass parameters. The data type of ATTACH_BIN is BLOB. CREATE INDEX ATT_INDEX ON ...
Nick's user avatar
  • 1
0 votes
1 answer
76 views

ORA-14405 when dropping a tablespace with no data

I was cleaning up tablespaces and wanted to delete one, and after moving all the segments from it, I got the following: SCOTT.OE> drop tablespace fact_index including contents and datafiles; drop ...
Mark Stewart's user avatar
  • 1,133
0 votes
0 answers
14 views

MySQL remove corrupted Tablespace

this is my problem: for unknown reasons, I have a tablespace that corresponds to a table that no longer exists. I think the machine was not restarted correctly and this caused the damage. I want to ...
user9846973's user avatar
1 vote
1 answer
99 views

pg_upgradecluster fails with 'tablespace directory "" does not exist' error

I'm trying to upgrade a Postgres cluster from PG 12 to PG 15 using this command : sudo pg_upgradecluster 12 main --method=link My cluster uses some tablespaces: postgres=# SELECT oid, spcname, ...
PEPin's user avatar
  • 21
0 votes
0 answers
58 views

Problem restoring partial mariabackup

I follow this method to perform a partial and incremental backup of my database on two servers, bskpserver and devserver. Everything works fine except for some tables. When I try to restore them on ...
elarichi.y's user avatar
0 votes
1 answer
60 views

is it safe to have an unlogged table on the ram disk?

I need to create a table for caching in the postgresql database. Transactions should be as fast as possible, so i thought of creating unlogged table and have a RAM disk as it's tablespace. There is a ...
Tamer Mukayev's user avatar
0 votes
1 answer
735 views

Postgres 15.3 fails to create new tablespace (could not set permissions)

I am unable to create new tablespaces on a fresh Postgres 15.3 installation on Ubuntu 22.04. I tried the following so far: re-install Postgres fully loosen file system permission disabled SELinux ...
Luís de Sousa's user avatar
0 votes
2 answers
1k views

ORA-01654: unable to extend index by 8192 with enough free space

I'm working in Oracle 19c DB. Block size is 8k. I'm trying to insert new data in my table. I have enough free space (according to dba_free_space more than 2 GB). But I've got ORA-01654: unable to ...
Andy DB Analyst's user avatar
-1 votes
1 answer
40 views

I'd like to know how to monitor tablespaces

I'd like to know how to monitor tablespaces. I don't have much knowledge of Postgres. When I create a tablespace, how can I measure the tablespace size? How can I monitor the size of the tablespace so ...
Fernanda Afonso's user avatar
2 votes
1 answer
1k views

What permissions are needed to prevent ERROR: permission denied for pg_tablespace_size('pg_global') in RDS?

I'm looking for some help identifying a permission I need to grant to prevent an error in a proprietary app. The App is loading data into an AWS RDS postgresql database. Loading data is working fine....
Philip Couling's user avatar
1 vote
0 answers
226 views

MySQL: Hierarchical Organization of Tables

There are several SE Q&As regarding how to hierarchically organize tables in MySQL: How to use a naming convention for large databases? Asked 12 years, 11 months ago How can I organize a glut of ...
Jeron Baffom's user avatar
1 vote
1 answer
227 views

Huge Increase in Storage Needed to Store Data in Oracle

I have a table stored in a tablespace where the size growth is usually not too big. However, on the last data loading, it suddenly needed so much more additional space, while inserting the same exact ...
calegr111's user avatar
0 votes
1 answer
3k views

What causes temp tablespace to be full and generates ORA-01652 error

I would like to understand in what sort of situations or what issues could cause TEMP tablespace to run out of space. Is it too much sorting occur on TEMP? How do I identify such issue from AWR? And ...
Jason Oon's user avatar
-4 votes
1 answer
55 views

create a oracle database user with no object in tablespace [closed]

Create user Sara with a password of sara. Make sure that any objects not created in the system tablespace and Sara can log in and create objects up to 10M in size in the MYUSERS. how to create a ...
005 maira sultana's user avatar
0 votes
1 answer
213 views

Oracle 10g Database - SYSTEM tablespace space

I am concerned about the SYSTEM tablespace. It's space is 99% full. The whole tablespace has 1510 MB and there is 1507 MB already used. Max size of datafile is 32 GB and the autoincrement is on with ...
Julia Kwasniuk's user avatar
0 votes
1 answer
512 views

Mysql, failing xtrabackup and weird undo tablespaces metrics

I'm trying to set up a MySQL replica server, but, since the database size is quite large, I'm using xtrabackup. The latter one constantly fails on start (though I used to use it earlier): xtrabackup: ...
drookie's user avatar
  • 238
1 vote
1 answer
2k views

pg_basebackup and multiple tablespaces

I have the following case: the master database has an additional tablespace I'm trying to replicate the master with the pg_basebackup tool the directory / partition layout on the slave is the same as ...
don999's user avatar
  • 11
1 vote
2 answers
2k views

Different execution time for same query on different Postgres databases

I have two identical databases, development and live. I run this query on both of them.... select count(*) FROM DeviceB where deviceID not in (SELECT distinct deviceId FROM Device) On the dev box the ...
ConanTheGerbil's user avatar
0 votes
1 answer
353 views

Create Tablespace is not working on Postgres - Ubuntu - NTFS

I cant create a new tablespace in mounted directory psql -U sysuser -d postgres -c "CREATE TABLESPACE dadospostgres LOCATION '/media/tiago/Dados/Postgres/Bancos';" ERROR: could not set ...
Tiago Oliveira de Freitas's user avatar
0 votes
1 answer
64 views

Production filesystem is at 100%. Move the datafiles to a new filesystem?

As the title states our file system reached 100% capacity and I want to try moving the tablespaces datafiles to a new filesystem. I'm attempting to follow the steps from this link: http://www.dba-...
Phillip's user avatar
  • 11
0 votes
0 answers
203 views

mySQL InnoDB tablespace move to network drive

In Windows 10 with mySQL 8.0.26, I am seeking to move a set of rarely used but occasionally necessary tables from my working SSD to another physical device with more space. I have attempted to move ...
wistlo's user avatar
  • 119
0 votes
2 answers
2k views

ORA-01652 - unable to extend TEMP segment?

Having an issue that I can't seem to find any solutions to online. [72000][1652] ORA-01652: unable to extend temp segment by 256 in tablespace TEMP Position: 581 One of our users runs a query ...
Phillip's user avatar
  • 11
1 vote
1 answer
8k views

How do I correct InnoDB Multiple files found for the same tablespace ID?

Some time ago after an update of Ubuntu 20.10, I discovered that MySQL was not running. When I tried to restart it, the error message suggested that it had started, failed and stopped. A check of the ...
Mark Lee's user avatar
  • 141
0 votes
1 answer
1k views

MySQL 8.0.23: Removeing huge '#sql-ib****.idb files?

I had a massive mysql database crash this morning and realized it was due to the server running out of disk space. I recently upgraded mysql to version 8.0.23 last week from 5.7. As I was looking for ...
peppy's user avatar
  • 33
0 votes
1 answer
185 views

Estimate Oracle tablespace required before loading data

I have files ranging from 450 to 750 million rows, which I need to load into our Oracle environment. The DBA asked me to give an estimate on how much tablespace I would need. How to estimate the ...
Abhinav Dhiman's user avatar
0 votes
1 answer
1k views

ORACLE execute error: ORA-01950: no privileges on tablespace 'PDATA'

I'm new in Oracle, so maybe my question could be stupid. I use Oracle only for data storage. I have made some research but I'm blocked. I use Oracle 12c. I created a PDB with admin user PEEI_SYS like ...
Ibrahima Wane's user avatar
1 vote
0 answers
104 views

Naming a datafile with spaces in the name

I would like to know if there could be a problem when naming a datafile with spaces in the name, I have an Oracle 11gR2 database, using ASM as storage, a datafile was created, belonging to an ...
miguel ramires's user avatar
2 votes
3 answers
2k views

Ramifications of Full SYSAUX - Oracle

What are the ramifications of having a full or almost nearly full SYSAUX tablespace (Oracle 19c)? There are plenty of sites discussing how to view the SYSAUX occupants, to reduce the size of SYSAUX ...
Alex Bartsmon's user avatar
3 votes
1 answer
17k views

mysqldump with --no-tablespaces on InnoDB with index?

Does mysqldump --no-tablespaces dumps index files of InnoDB? I know that MyIsam uses separate index files *.MYI for index. So if one uses mysqldump with --no-tablespaces, does that mean index is not ...
Aldee's user avatar
  • 41
0 votes
1 answer
692 views

How to quota a CDB only tablespace to a CDB user?

I can create a CDB tablespace like this: (all using: sqlplus / as sysdba) -- create unique table space for admin CREATE TABLESPACE admints DATAFILE '/path/to/admints.dbf' SIZE 20M AUTOEXTEND ON; I ...
SHR's user avatar
  • 874
1 vote
1 answer
111 views

Creating table space steps [closed]

In order for me to create space in the database is this all I need to do? alter tablespace USER_DATA_TBS add datafile '/oradata/bosv/user_data04.dbf' size 10m; Or are there other steps I need to ...
xzgtrtprmwteaghbai's user avatar
0 votes
2 answers
489 views

MySQL one file per table not working

I've followed all of the instructions for enabling the one file per table in MySQL (v8, on Ubuntu 20): Added innodb_file_per_table=ON Restarted MySQL Dumped all databases, one by one. However, when ...
FlyingZebra1's user avatar
2 votes
1 answer
2k views

Missing mysql, sys, performance_schema

I have Percona Mysql 8.0.19-10 on debian 10. A year ago I had some issues restoring a backup that required me to mess with tablespaces. I forget what all I had done but eventually I got the database ...
ParoX's user avatar
  • 163
0 votes
1 answer
1k views

Get tablespace name from dump file

I have an Oracle dump file which I need to import but do not know what is its tablespace name. How can I get it from the dump file? I know that it is possible to get many information using impdp ...
user1337's user avatar
  • 103
0 votes
1 answer
902 views

could not read symbolic link error while executing pg_start_backup function in Postgresql DB

In order to take data folder backup in postgres 9.6 database executed the order of functions for backup, while executing pg_start_backup function produced warning : could not read symbolic link for ...
rajv's user avatar
  • 1
1 vote
2 answers
2k views

How do I move tables and indexes owned by user to new tablespaces in Oracle 19C?

I have a user named SDE and the tablespace for this users tables are in SDE_TBS, I would like to move all of these tables to tablespace SDEBUS_DT. For indexes I would like to move to SDEBUS_IX. How ...
Geoffrey West's user avatar
-1 votes
1 answer
236 views

How to locate the tablespace objects that have grown suddenly?

In my Oracle 11g database, I have one of my tablespace that has grown suddenly during the night. I would like to find the tablespace objects (e.g. tables or index) that have grown suddenly as occupied ...
Sara_Marp's user avatar
0 votes
1 answer
1k views

Warning message: invalid value for parameter "default_tablespace" in postgres

I create a new tablespace using the following script: CREATE SCHEMA semiarido; CREATE ROLE semiarido PASSWORD 'senha'; GRANT CREATE ON SCHEMA semiarido TO semiarido; GRANT USAGE ON SCHEMA semiarido ...
Mauro Assis's user avatar
0 votes
1 answer
2k views

Adding multiple files to a tablespace

In Oracle, we have huge amount of data imported daily, which requires us to create data files off and on in a tablespace. Wonder if we create two data files simultaneously, will it use both when one ...
user avatar
1 vote
1 answer
878 views

Changing default permanent USERS tablespace to bigfile

I'm trying to build an oracle database server but it's setting up the users tablespace as a smallfile. How can I either install brand new database with users being bigfile or changing the existing ...
Alkey29's user avatar
  • 11
1 vote
1 answer
2k views

Postgres use multiple tablespaces in a single database

Is it possible to allocate tables directly to tablespaces within a single database/schema in postgres? Based on the docs, tablespace is a create database argument, but are there any workarounds?
zeller's user avatar
  • 113
1 vote
1 answer
6k views

Get tablespace of a given table in DB2

What is the command to get the name of tablespace of a given table in DB2 database ?
user236778's user avatar
0 votes
2 answers
4k views

ORACLE TABLESPACE USERS GETS 100% USED

I am facing a problem with oracles users tablespace. It automatically grows really fast. What kind of data is stored there? And what happens when it hits 100% of space used? Is there a solution to ...
Dominykas Česonis's user avatar
1 vote
2 answers
4k views

Postgres tablespace size management

I have a Postgres 10 database which is the model for an MVC app. On it many (200,000) LOBS get saved, eventually processed, and stored or deleted depending on some conditions. I have two problems. ...
Sandman42's user avatar
5 votes
1 answer
685 views

Continuously Adding SSDs to an existing PostgreSQL Server

An Ubuntu 18.04 server dedicated to running a PostgreSQL 11.2 server (with TimescaleDB extension) will be running out of disk space soon so new SSD disks will need to be added to the machine to ...
Nyxynyx's user avatar
  • 1,141
3 votes
1 answer
4k views

Can shrinking temporary TEMP tablespace in Oracle cause any harm?

I have a massive TEMP tablespace that is 1TB large. It consists of 30datafiles, each one is like 31GB in size. Entire TEMP tablespace has a size of 1TB, while used size is only ~600MB. I want to ...
korodani's user avatar
  • 123