Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Tag: tablespaces
Creating a table space sql developer
Question : I asked this question over at https://stackoverflow.com/questions/52068320/creating-a-table-space-sql-developer, but there was no traction on the question, i thought i […]
ORA-00959: Tablespace ‘$name’ does not exist when using impdp
Question : I’m new at Oracle databases. I’m executing an impdp command and encountered this error: ORA-00959: tablespace ‘$name’ does […]
How do you list all items from all databases located in a specific tablespace in postgresql?
Question : I’m trying to clean out some old tablespaces in my postgres instance, and I can’t seem to figure […]
Balancing the size of oracle datafiles for a tablespace
Question : I have a tablespace where I had to add datafiles, because a partion run full. The new datafiles […]
What are the benefits of using a different tablespace for a new user schema?
Question : The tables in the schema are intended to be used read only and is only updated once each […]
What units used in DBA_TABLESPACE_USAGE_METRICS?
Question : What units are used in the usage metrics (USED_SPACE and TABLESPACE_SIZE columns) described in Oracle’s DBA_TABLESPACE_USAGE_METRICS static data […]
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 […]
Rebalance/move or strink oracle undotablespace
Question : I’m running out of space in oradata01 and oradata02. Is there a ways to move or rebalance with […]
MySQL – Changing from system tablespace to file per table
Question : The MySQL database I am working on has the InnoDB tables and indexes stored in the system tablespace […]