RE: How to hook up x$dual

2002-08-02 Thread Bob Metelsky
lps...   - Original Message - From: "Bob Metelsky" <[EMAIL PROTECTED]> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 01, 2002 4:13 PM Subject: How to hook up x$dual Hello AllIm looking to experime

Re: How to hook up x$dual

2002-08-01 Thread Tim Gorman
s of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 01, 2002 4:13 PM Subject: How to hook up x$dual Hello AllIm looking to experiment with using x$dual opposed to dual.from my readinghttp://www.optimaldba.com/internals/oraint_dual.htmlWhich refers to using the memort structu

RE: How to hook up x$dual

2002-08-01 Thread Fink, Dan
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

RE: How to hook up x$dual

2002-08-01 Thread Khedr, Waleed
It is visible from user sys only. -Original Message- Sent: Thursday, August 01, 2002 6: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

How to hook up x$dual

2002-08-01 Thread Bob Metelsky
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??