RE: How to hook up x$dual

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Fri, 02 Aug 2002 05:48:19 -0800
Message-ID: <F001.004A9CA8.20020802054819@fatcity.com>

Thanks alot, that worked perfectly!  

thank you
bob  

> You'd need to do something like this under the SYS account:

		SQL> create view v_$dual
		2    as
		3    select dummy
		4    from x$dual
		5    where inst_id = userenv('INSTANCE');
		 
		View created.
		 
		SQL> grant select on v_$dual to public;
		 
		Permission granted.
		 
		SQL> create public synonym v$dual for v_$dual;
		 
		Synonym created.

	This would leave you with a publicly available view called

V$DUAL...                   Hope this helps...          

• Original Message ----- From: "Bob Metelsky" <bmetelsky_at_cps92.com <mailto:bmetelsky_at_cps92.com> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com <mailto:ORACLE-L_at_fatcity.com> > Sent: Thursday, August 01, 2002 4:13 PM Subject: How to hook up x$dual

        Hello All         

	Im looking to experiment with using x$dual opposed to dual.
	from my reading
	http://www.optimaldba.com/internals/oraint_dual.html
<http://www.optimaldba.com/internals/oraint_dual.html> 
	Which refers to using the memort structure of X$DUAL....
	
	if I 
	SQL>desc x$dual
	ORA-04043: object x$dual does not exist
	
	So how do I hook up x$dual??
	
	Ive searched orafaq, google, and comp.os.oracle.databases with

no avail         

        I recall this was a topic here a while back but nothing on how to create

        x$dual if it dosnt exist??         

	its not in this select
	select table_name from dba_tables where owner = 'SYS';
	
	Is this suposed to be an actual created table or a "memory
object" and
	how can I create/use in it place of dual
	
	

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bob Metelsky
  INET: bmetelsky_at_cps92.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 Fri Aug 02 2002 - 08:48:19 CDT