probably system owns a table called dual ... check that first.
Raj
On 11/8/05, Frank B Hansen <frank4oraclel@(protected)> wrote: > > Hi David > OK. Next question and some additional info: > It is only when connected as SYSTEM that 3 rows are returned. If I > connect as SYS og SCOTT, only 1 row is returned. > A select from x$dual returns one row: > sys@(protected)> select * from x$dual; > ADDR INDX INST_ID D > -- ----- -- ---- -- -- ---- -- - > 01B74DC8 0 1 X > and the question: > How do I delete row number the second and third row from dual ? > Thanks, > Frank > > > *David Sharples <davidsharples@(protected)>* skrev: > > someone inserted 2 extra rows into dual, find them and tell them politely > not to do it again. > Then delete the other rows as you have a broken database right now > > On 11/8/05, Frank B Hansen <frank4oraclel@(protected)> wrote: > > > > No matter what I select from dual, I get 3 rows. Anyone seen this > > behaviour ? > > > > >
-- -- ---- ---- ---- ---- ---- ---- ---- ---- --- This space is available for rent.
probably system owns a table called dual ... check that first.<br><br>Raj<br> <br><div><span class="gmail_quote">On 11/8/05, <b class="gmail_sendername">Frank B Hansen</b> <<a href="mailto:frank4oraclel@(protected)">frank4oraclel@(protected) </a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div >Hi David</div> <div> </div> <div>OK. Next question and some additional info:</div> <div> </div> <div>It is only when connected as SYSTEM that 3 rows are returned. If I connect as SYS og SCOTT, only 1 row is returned.</div> <div> </div> <div>A select from x$dual returns one row:</div> <div> </div> <div><a href="mailto:sys@(protected)" target="_blank" onclick="return top.js .OpenExtLink(window,event,this)">sys@(protected)</a>> select * from x$dual;</div > <div>ADDR INDX  ; INST_ID D<br>-- ----- -- ---- -- -- ---- -- -<br>01B74DC8 0 1 X</div> <div> </div> <div> </div> <div>and the question:</div> <div>How do I delete row number the second and third row from dual ?</div> <div> </div> <div>Thanks,</div> <div>Frank</div> <div> </div> <div><br><br><b><i>David Sharples <<a href="mailto:davidsharples@(protected)" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)" >davidsharples@(protected)</a>></i></b> skrev:</div><div><span class="e" id="q _1076f99e1c5a507f_1">
<blockquote style="border-left: 2px solid rgb(16, 16, 255); padding-left: 5px; margin-left: 5px;"> <div>someone inserted 2 extra rows into dual, find them and tell them politely not to do it again. </div> <div>Then delete the other rows as you have a broken database right now<br><br> </div> <div><span class="gmail_quote">On 11/8/05, <b class="gmail_sendername">Frank B Hansen</b> <<a href="mailto:frank4oraclel@(protected)" target="_blank" onclick= "return top.js.OpenExtLink(window,event,this)">frank4oraclel@(protected) </a>> wrote:</span> <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204 ); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;"> <div> <blockquote style="border-left: 2px solid rgb(16, 16, 255); padding-left: 5px; margin-left: 5px;"> <blockquote dir="ltr" style="border-left: 2px solid rgb(0, 0, 0); padding-right : 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;"> <div>No matter what I select from dual, I get 3 rows. Anyone seen this behaviour ?</div> <div> </div></blockquote></blockquote></div></blockquote></div><br>< /blockquote> </span></div></blockquote></div><br><br clear="all"><br>-- <br>-- ---- ---- --- -- ---- ---- ---- ---- ---- --<br>This space is available for rent.<br>
