Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Strange "quota" issue

Strange "quota" issue

From: Nirmalya Das <nirmalya_at_hln.com>
Date: Mon, 31 Jul 2006 13:50:12 -0700
Message-ID: <20060731135012.ulyyq68kc8w0oos4@www.hln.com>


Here's the environment:

RDBMS: 10.1.0.4 (standard edition)
OS : RHEL AS 3 User "X" has "RESOURCE" priviledge and NOT given explicit "quota" to tablespaces "DATA" and "INDX".

The tablespaces has datafiles with 1024MB and has AUTOEXTEND upto 2048MB.

There are 5 datafiles for each tablespaces.

Problem: The datafiles got full upto 99% of 1024MB but never extended.

         Started getting ORA-01536 "quota exceeded for tablespace DATA & INDX"

Fix: Given explicit "quota unlimited" to the USER for the tablespaces

Puzzled:

  1. "Resource" priviledge automatically gives "unlimited quota" to tablespaces.
  2. Why did the datafiles never extended?
  3. How did this work all this time without the "quota" problem?

Any insights will be greatly appreciated.....

TIA

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 31 2006 - 15:50:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US