OraFAQ Forum: Server Administration » how can exceeded Tablespace quota in oracle10g

Home » RDBMS Server » Server Administration » how can exceeded Tablespace quota in oracle10g

Sat, 04 August 2007 00:32

jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI

Member

Hi

how can exceeded Tablespace quota in oracle10g and
How Can Get Which Tablespace Related to Which datafile;

Jai

Sat, 04 August 2007 00:42

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

how can exceeded Tablespace quota in oracle10g and
For user :

alter user "username" quota XX k/m

on "tablespace_name".

For Tablespace : 1. Add new datafile
2. use RESIZE clause

How Can Get Which Tablespace Related to Which datafile

select file_name, tablespace_name from dba_data_files

Previous Topic:	TEMP tablespace full in AIX oracle9i
Next Topic:	analyze vs dbms_stats

Goto Forum:

]

Current Time: Thu Dec 05 08:08:30 CST 2024