Oracle-L: RE: How to hook up x$dual

From: Fink, Dan <Dan.Fink_at_mdx.com>
Date: Thu, 01 Aug 2002 14:48:33 -0800
Message-ID: <F001.004A96DB.20020801144833@fatcity.com>

x$dual is owned by sys and is not visible to others (without sys granting permissions). This is why you use sys to create the view and synonym. In looking at what is posted, I did not indicate which user to login as for the view creation. My apologies...I'll fix it shortly.

Thanks for the catch and let me know how it turns out.

-----Original Message-----
Sent: Thursday, August 01, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L

Hello All

Im looking to experiment with using x$dual opposed to dual. from my reading
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

thanks
bob
--

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Fink, Dan
INET: Dan.Fink_at_mdx.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------