Question : Problem: On an Oracle 11.2g DB; We have a corrupted TS that does not allow starting the database […]
Tag: tablespaces
Warning message: invalid value for parameter “default_tablespace” in postgres
Question : I create a new tablespace using the following script: CREATE SCHEMA semiarido; CREATE ROLE semiarido PASSWORD ‘senha’; GRANT […]
PostgreSQL: Table and index on different tablespace
Question : In PostgreSQL i have the freedom of choosing to put index (of a table or materialized view) on […]
Alter Postgres Tablespace [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Recovering logical space from a tablespace
Question : I have a tablespace called DATA, and it is setup with auto-extend as false. This tablespace has two […]
Postgres tablespace on mounted usb
Question : I’ve got postgres 9.1 running on raspbian installed with apt-get. I’ve got NTFS usb HDD mounted in /mnt/usb. […]
Oracle IMPDP job ORA-30036 unable to extend segment by 8 in undo tablespace ‘UNDOTBS1’
Question : I’m using IMPDP with the “network_link” for perform export/import in a single-pass. It runs fine until I get […]
Why doesn’t a delete increase unused space in a table?
Question : If I populate the following table: IF OBJECT_ID (‘dbo.CleanTableTest’, ‘U’) IS NOT NULL DROP TABLE dbo.CleanTableTest; GO CREATE […]
Oracle database created whats next? Create Schema or Create Tablespace?
Question : I’m a programmer that’s being thrown to the DBA/Sysadmin island all by myself with a volleyball that I […]
Tablespace of an index organized table
Question : I want to find the tablespace of an index organized table with primary key. With dba_segments I can […]