330 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
-2
votes
1
answer
206
views
Why is my Oracle tablespace growing so unreasonably fast? [closed]
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 ...
0
votes
0
answers
47
views
Create postgresql tablespace on Synology from pgadmin running in Windows 10
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 ...
0
votes
0
answers
107
views
Alter tablespace of existing database in Postgresql
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 ? ...
0
votes
2
answers
3k
views
Oracle Tablespace multiple datafile with autoextend and maxsize
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 ...
1
vote
2
answers
995
views
PostgreSQL Partitioning Error: ERROR: cannot specify default tablespace for partitioned relations
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 ...
0
votes
0
answers
82
views
Permission denied for tablespace while creating a VIEW in Postgres
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 ...
0
votes
1
answer
78
views
Is my TEMP tablespaces monitoring correct? [closed]
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 ...
0
votes
1
answer
245
views
Error ERROR 3019 (HY000) when cleaning MySQL database (No more space left)
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 ...
0
votes
1
answer
731
views
How to export (expdp) a tablespace Oracle express 21c?
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 ...
0
votes
1
answer
465
views
Missing user db on Postgresql AWS?
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 ...
0
votes
0
answers
125
views
Mysql create a general tablespace in a specific directory
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/...
0
votes
1
answer
585
views
What to do if there are two tablespace directories after pg_upgrade using hard-links option
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 ...
0
votes
1
answer
560
views
How to move schema to other tablespace
Postgres 13.2 database contains schema named company2 which contains tables and indexes and is located in g:\Program Files\Postgresql13円\data directory.
Server has also drive I:
How to move tables and ...
-1
votes
2
answers
92
views
Copy Oracle database to my local database oracle xe problem with tablespace
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 ...
1
vote
1
answer
74
views
Find the sum of tablespaces in PostgreSQL
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 ...