From: gs on 9 Mar 2010 14:13 gazzag wrote: > On 9 Mar, 14:37, gs <g...(a)gs.com> wrote: >> I always use command line for switching archive on/off - I will admit >> using EM in 9i once just to see how well it worked, but I just feel much >> more comfortable using command line rather than wondering if the GUI is >> really doing something or just sitting there hung. >> >> One thing I don't like about SQL developer is you need to be logged in >> as the user whose schema you want to see, which is a pain when you want >> to see tables from different schemas in the same session. Unless I am >> missing something, the only way to do this in SD is disconnect/reconnect- Hide quoted text - >> > > gs, > > If you log into SQL*Developer as SYSTEM, you will see "Other Users" at > the bottom of your object browser tree. Expand this to see other > schemas. > > HTH > > -g > > thanks - must have missed that, I was in as system
From: John Hurley on 9 Mar 2010 14:25 On Mar 9, 10:14 am, gazzag <gar...(a)jamms.org> wrote: snip > If you log into SQL*Developer as SYSTEM, you will see "Other Users" at > the bottom of your object browser tree. Expand this to see other > schemas. Ummm ... you don't need to be logged in as SYSTEM to see other schemas. It all depends on what has been granted ... etc.
From: Matthias Hoys on 9 Mar 2010 17:10 "gazzag" <gareth(a)jamms.org> wrote in message news:a66f4682-ade0-4ffd-9eb6-bb6182859b12(a)z11g2000yqz.googlegroups.com... > On 6 Mar, 13:03, "Matthias Hoys" <a...(a)spam.com> wrote: >> >> I believe on Windoze the quotes are still needed! >> >> Matthias- Hide quoted text - >> > > Microsoft Windows [Version 6.0.6001] > Copyright (c) 2006 Microsoft Corporation. All rights reserved. > > C:\>set ORACLE_SID=XXXXXXXX > > C:\>sqlplus / as sysdba > > SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 8 10:57:03 2010 > > Copyright (c) 1982, 2007, Oracle. All Rights Reserved. > > > Connected to: > Oracle Database 10g Release 10.2.0.4.0 - 64bit Production > > > Session altered. > > SYS(a)XXXXXXXX> > > HTH > > -g Guess not then :-) Matthias
From: Shakespeare on 9 Mar 2010 18:25 Op 9-3-2010 23:10, Matthias Hoys schreef: > "gazzag"<gareth(a)jamms.org> wrote in message > news:a66f4682-ade0-4ffd-9eb6-bb6182859b12(a)z11g2000yqz.googlegroups.com... >> On 6 Mar, 13:03, "Matthias Hoys"<a...(a)spam.com> wrote: >>> >>> I believe on Windoze the quotes are still needed! >>> >>> Matthias- Hide quoted text - >>> >> >> Microsoft Windows [Version 6.0.6001] >> Copyright (c) 2006 Microsoft Corporation. All rights reserved. >> >> C:\>set ORACLE_SID=XXXXXXXX >> >> C:\>sqlplus / as sysdba >> >> SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 8 10:57:03 2010 >> >> Copyright (c) 1982, 2007, Oracle. All Rights Reserved. >> >> >> Connected to: >> Oracle Database 10g Release 10.2.0.4.0 - 64bit Production >> >> >> Session altered. >> >> SYS(a)XXXXXXXX> >> >> HTH >> >> -g > > Guess not then :-) > > Matthias > > They never were.... Shakespeare
From: Frank van Bortel on 10 Mar 2010 03:39
Shakespeare wrote: > Op 9-3-2010 23:10, Matthias Hoys schreef: >> Guess not then :-) >> >> Matthias >> >> > They never were.... > > Shakespeare Try with 9.2: they are! -- Regards, Frank van Bortel Topposting in Usenet groups I regard as offensive - I will not reply |