OraFAQ Forum: Server Administration » Getting wrong information through Views

Home » RDBMS Server » Server Administration » Getting wrong information through Views (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production & ON LINUX 32 bit server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Getting wrong information through Views [message #576660]

Thu, 07 February 2013 01:29

crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi

Member

Hi All,
I am getting unexpected issue while fatching records from dba_ts_quotas & DBA_USERS Views. please have a look & Guide to resolve such issue.

FYI..
select username,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE from dba_users
where username='DWHODS'

USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
DWHODS DWHODS_TBS_DATA DWHODS_TEMP_DATA

select tablespace_name, username, bytes / 1024 / 1024 "Used MB",
decode(max_bytes,-1,'UNLIMITED',max_bytes / 1024 / 1024) as "Max MB"
from dba_ts_quotas
where username='DWHODS';

TABLESPACE_NAME USERNAME Used MB Max MB
USERS DWHODS 0 UNLIMITED

View dba_ts_quotas is giving tablespace name "USERS" where DBA_USERS showing default tablespace name "DWHODS_TBS_DATA".

Please correct me if i am doing any mistake & help me to resolve the issue.

Regards
Vimlendu

Report message to a moderator

Re: Getting wrong information through Views [message #576663 is a reply to message #576660]

Thu, 07 February 2013 01:42

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

One is DEFAULT tablespace, the other is tablespace where user has quota.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.
Also always post your Oracle version, with 4 decimals.

When you post such question, use SQL*Plus and copy and paste your session.

Regards
Michel

Report message to a moderator

Previous Topic:	change port number
Next Topic:	Generate statspack report without perfstat account

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 23:43:53 CST 2025