RE: How to hook up x$dual

Title: Message 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

Re: How to hook up x$dual

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> creat

RE: How to hook up x$dual

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

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