I have problem in understanding why my table entries occupy so much space. My DB is growing unexpectedly fast. In detail: There is the following table DATA_SENSOR: create tablespace DATA_SENSOR ...

I have postgresql 17 installed on Windows 10 working well. I want to create a tablespace on a USB external drive plugged into a Synology NAS with DSM 7. The USB drive is mapped as a network drive in ...

I have a database located in default tablespace named "pg_default". Due to space limit in directory, I need to alter tablespace of my database to new custom tablespace. How I can do that ? ...

I'm completely new to Oracle Database and I'm trying to learn it. My goal today is to create a simple tablespace with one datafile and then add a new datafile to that tablespace. With this I ...

I am trying to add partitioning to a table in my database. Here is an example: CREATE TABLE IF NOT EXISTS myBd.test_table ( id SERIAL PRIMARY KEY, name VARCHAR(50) NOT NULL, age INT NOT ...

During a run of my synchronising script for a postrgresdb, I run into an error, and I have no idea how to solve this: Caused by: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad ...

I've developed this TEMP tablespaces Monitor via DBLINKS in ORACLE it sends an email if any temp tablespace reaches any percentage called by v_used: CREATE OR REPLACE PROCEDURE SP_TEMP_MON( v_used ...

I have a MySQL database and a big table on it called "tc_positions". Recently I ran out of space on my pc and I'm trying to clean up the database using the command: delete from tc_positions ...

I'm currently studying this topic in a databases class, and I was asked to export a tablespace using the expdp command. This is happening only with tablespaces, I tried executing a data pump of a ...

Why is my test user DB missing so often? I'll leave my AWS instance stopped overnight and then restart it in the morning. But then I'm not able to login w/ my jdtest user account! I keep getting the ...

I am trying to create a tablespace in a specific directory /home/tareq178/data/ in my Linux Ubuntu 22.04.3 VM. I am using the following command CREATE TABLESPACE newspace2 ADD DATAFILE "/home/...

A while back, I ran a PostgreSQL pg_upgrade on a PG11 database, to PG12, which has a tablespace located at /ssd in it. I used the --link option in my command to create hard links, as to not double up ...

Postgres 13.2 database contains schema named company2 which contains tables and indexes and is located in g:\Program Files\Postgresql\13\data directory. Server has also drive I: How to move tables and ...

I am trying to copy my Oracle database to my local Oracle XE database. I am using Oracle SQL Developer. I connected to my database, then exported a .sql file from my database. I then created a new ...

What I am trying to do is to calculate the sum of the 2 tableSpaces I have in my PostgreSQL DB. SELECT pg_size_pretty (pg_tablespace_size ('pg_default') ); with this query I am able to find the used ...