Re: Question on dba_ts

From: Quamrul Polash <quapol_at_hotmail.com>
Date: Mon, 03 Dec 2001 16:53:14 -0800
Message-ID: <F001.003D4023.20011203163019@fatcity.com>

Hi,

If you alter the quota for a user to zero bytes on any tablespace, it will not show up in the dba_ts_quotas for that user. In your third query, in which schema the table was created?

HTH, Quamrul

>From: Prasada.Gunda1_at_hartfordlife.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Question on dba_ts_quotas
>Date: Mon, 03 Dec 2001 14:56:33 -0800
>
>
>Hi All,
>
>I have a question on dba_ts_quotas.
>
>User called QUOTE has objects in TS_QUOTE_DATA and TS_QUOTE_INDEX
>tablespaces. And, I expect that the relation/quota
>would show up in dba_ts_quotas. I don't see any records in dba_ts_quotas
>for this schema. I checked for other
>schemas and they showed up.
>Just for testing, I created a dummy table to test it and it got created
>without any problems.
>
>Why is it not showing up in dba_ts_quotas. Am I missing something here?
>BTW, I am using SYSTEM to query these views.
>
>Thanks in advance for your help.
>
>SELECT DISTINCT TABLESPACE_NAME FROM DBA_SEGMENTS WHERE OWNER LIKE 'QUOTE';
>
>TABLESPACE_NAME
>------------------------------
>TS_QUOTE_DATA
>TS_QUOTE_INDEX
>
>SELECT * FROM DBA_TS_QUOTAS WHERE USERNAME LIKE 'QUOTE';
>
>no rows selected
>
>CREATE TABLE TEST1 (DUMMY NUMBER) TABLESPACE TS_QUOTE_DATA;
>
>Table created.
>
>
>Best regards,
>Prasad
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: Prasada.Gunda1_at_hartfordlife.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Quamrul Polash
  INET: quapol_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Dec 03 2001 - 18:53:14 CST

Re: Question on dba_ts_quotas