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)
Getting wrong information through Views [message #576660] Thu, 07 February 2013 01:29 Go to next message
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
Re: Getting wrong information through Views [message #576663 is a reply to message #576660] Thu, 07 February 2013 01:42 Go to previous message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: change port number
Next Topic: Generate statspack report without perfstat account
Goto Forum:
  


Current Time: Sun Apr 20 17:07:33 CDT 2014

Total time taken to generate the page: 0.04841 seconds