Home » RDBMS Server » Server Administration » how can exceeded Tablespace quota in oracle10g
how can exceeded Tablespace quota in oracle10g [message #256354] Sat, 04 August 2007 00:32 Go to next message
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
Re: how can exceeded Tablespace quota in oracle10g [message #256356 is a reply to message #256354] Sat, 04 August 2007 00:42 Go to previous message
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