Home » SQL & PL/SQL » SQL & PL/SQL » wrm$ views
wrm$ views [message #302407] Mon, 25 February 2008 09:11 Go to next message
prince973
Messages: 37
Registered: November 2006
Member
hi all,
i used to search dictionary when i forget the table name,
regarding WRM$_ views i cant find them in dictionary ,
i used
desc WRM$_BASELINE
Name Null? Type
----------------------------------------- -------- ----------------------------
DBID NOT NULL NUMBER
BASELINE_ID NOT NULL NUMBER
BASELINE_NAME VARCHAR2(64)
START_SNAP_ID NUMBER
END_SNAP_ID NUMBER
BASELINE_TYPE VARCHAR2(13)
MOVING_WINDOW_SIZE NUMBER
CREATION_TIME DATE
EXPIRATION NUMBER
TEMPLATE_NAME VARCHAR2(64)
LAST_TIME_COMPUTED DATE

SELECT TABLE_NAME FROM DICT WHERE TABLE_NAME LIKE 'WRM$%' ;
and i get
no rows selected

can anyone tell me how can i search for WRM$ views?
thx for reading
Re: wrm$ views [message #302409 is a reply to message #302407] Mon, 25 February 2008 09:13 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
SELECT VIEW_NAME FROM DBA_VIEWS WHERE VIEW_NAME LIKE 'WRM$%' ;
Re: wrm$ views [message #302410 is a reply to message #302407] Mon, 25 February 2008 09:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBA_TABLES.
DICT only gives you limited access to dictionary objects (unless you have SELECT ANY TABLE privilege).

Regards
Michel

[Updated on: Mon, 25 February 2008 09:17]

Report message to a moderator

Re: wrm$ views [message #302413 is a reply to message #302407] Mon, 25 February 2008 09:34 Go to previous messageGo to next message
prince973
Messages: 37
Registered: November 2006
Member
thank you all, i found the answer,
because wrm$ views are stored in the sysaux tablespace they are not included in dictionary,
select table_name from dba_tables where tablespace_name='SYSAUX' and table_name like'WRM%';

this is the good query,
thx all,
Re: wrm$ views [message #302414 is a reply to message #302407] Mon, 25 February 2008 09:40 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member

SQL> select table_name from dba_tables where tablespace_name='SYSAUX' and table_name like'WRM%';

TABLE_NAME
------------------------------
WRM$_BASELINE
WRM$_BASELINE_DETAILS
WRM$_BASELINE_TEMPLATE
WRM$_COLORED_SQL
WRM$_DATABASE_INSTANCE
WRM$_SNAPSHOT
WRM$_SNAP_ERROR
WRM$_WR_CONTROL

8 rows selected.
Re: wrm$ views [message #302424 is a reply to message #302413] Mon, 25 February 2008 10:33 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
because wrm$ views are stored in the sysaux tablespace they are not included in dictionary,

This is wrong they are part of the dictionary but not the one you can see via DICT.
In addition, there is no restriction on tablespace for objects you can see via DICT.

Regards
Michel

[Updated on: Mon, 25 February 2008 10:40]

Report message to a moderator

Previous Topic: Merged: help in joining two tables
Next Topic: how can I make Mobile column ?
Goto Forum:
  


Current Time: Fri Dec 09 19:46:53 CST 2016

Total time taken to generate the page: 0.11180 seconds