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.

How to find the total tablespace usage in SQL Server 2008?

In SQL-server 2008, How would I find (through an SQL query), the percentage of tablespace usage for a particular instance(or …

sql sql-server-2008 sql-server-2008-r2 instances tablespace
Oracle: how to check space used by a tablespace when no dba privs

I need to check space used by a tablespace but I have no dba privs. Is there a way to …

oracle space tablespace
could not write to hash-join temporary file: No space left on device

I am executing PostgreSQL functions to update a table which has a huge amount of data and the update happens …

performance postgresql space tablespace
Should an Oracle database have more than one tablespace for data storage?

My team maintains an Oracle database that is approx. 200GB in size. All of the data (tables, indexes, etc) lives …

oracle oracle10g tablespace
How to know the usage of temporary tablespace in Oracle

I am trying to compare two tables which are very large in my system(Oracle 10g). The way I used …

oracle temporary tablespace
Can oracle tablespaces automatically add smallfile datafiles?

Using Oracle managed files I can create my tablespace like this: CREATE TABLESPACE users; It will autoextend but as I …

oracle tablespace
CREATE and DROP TABLESPACE Oracle

I have created this tablespace CREATE TABLESPACE IA643_TBS DATAFILE 'IA643_dat' SIZE 500K AUTOEXTEND ON NEXT 300K MAXSIZE 100M; …

oracle tablespace
unable to extend temp segment by 128 in tablespace TEMP

I am trying to execute below query in Oracle: SELECT DISTINCT t4.s_studentreference "Student ID", t3.p_surname "Surname", …

oracle oracle-sqldeveloper temp segment tablespace
List only Oracle Temp Table Space

Is there way to list only temp tablespaces in Oracle? I found following query which is listing all the tablespaces, …

database oracle oracle11g oracle10g tablespace
Changing tablespace increment size

One of our datafiles hit the max of 32G. So, we created a 2nd datafile in that tablespace. However, we …

oracle tablespace