Top "Tablespace" questions

A tablespace is a database concept and refers to a storage location where the actual data underlying database objects can be kept.

True tablespace size in oracle

I need to know true tablespace size in Oracle. I have some tablespace and I need to know how many …

sql oracle space tablespace
Alter Table Move command - ORACLE

Consider i have TABLE1 in Tablespace TS1. I have another Tablespace TS2. What is the difference between the below three …

oracle11g alter-table tablespace
What is a tablespace and why is it used?

While investigating an issue, I came across this error: 30503 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace …

mysql database database-design tablespace
How to find table and column in DB2 with tbspaceid tableid specified in error message

I get following error message when trying to insert an object in the database: com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: …

database db2 tablespace
Where in the DB is the Location of a postgres tablespace stored

I am using postgres 9.2 on redhat 6 this should be simple but I can't find it anywhere. I am looking for …

postgresql postgresql-9.2 tablespace
Create Tablespace Script in Oracle 10g

I am using the below script for generating a DDL to create tablespaces in the database. select 'create tablespace ' || …

oracle scripting tablespace
Oracle Tablespaces maxsize "unlimited" not really unlimited

I recently needed to import a .dmp into a new user I created. I also created a new tablespace for …

oracle oracle11g tablespace
Location of the table space files?

How can I find the directory in which oracle stores it's table space files? When I do: select * from dba_…

oracle tablespace
How to grant user space resource on the tablespace in oracle 12c

I had created a user in oracle 12c standard edition. Now I tried to create a table using the username …

oracle oracle-sqldeveloper oracle12c tablespace
How to find users in a particular tablespace in oracle 11g?

I have created a new tablespace and also some users. I have assigned those users to the tablespace. What is …

oracle database-administration tablespace