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 get available space in tablespace for a user (Oracle)

I'm working on a web application where I need to warn the user that they're running out of space in …

oracle10g tablespace
no privileges on tablespace 'USERS'

i have many tables that i can insert rows, but i get this error only for one table; Error starting …

database oracle privileges tablespace
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS'

I am running cron job which have following PL/SQL block: declare begin --insert into DB_LOGS_TEMP table from …

oracle cron segment tablespace
How can I tell what is in a Postgresql tablespace?

I've created a new tablespace called indexes, and I'm trying to remove the old tablespace indexes_old, which used to …

postgresql tablespace
Index on which tablespace

How to find out which 'tablespace' a particular 'index' belongs to. (oracle) (need to use it via jdbc)

database oracle jdbc indexing tablespace
ORA 01114 - IO Error writing block to file

I am working on some compelex sql queries in Oracle 11g, which have aggregation functions like SUM and joins multiple …

sql database oracle11g views tablespace
Creating a tablespace in postgresql

I'm trying to create a tablespace in postgres, but I'm getting ownership problems. The command I'm using is: CREATE TABLESPACE …

postgresql tablespace chown
LOBSEGMENT objects filling up my tablespace in Oracle

I'm using a Oracle 10gR2 DB, and was taking a look in one of my tablespaces when I noticed something …

oracle view blob tablespace
How to increase the TEMP TABLE Space value in Oracle?

Currently my Oracle 11g temp TABLESPACE value is 34GB. I need to increase the table space value to a large …

oracle oracle11g redhat tablespace
PL/SQL developer import dump

I have a dump file which includes two tables. Now I need to import this dump file. I was instructed …

oracle dump plsqldeveloper tablespace