Cannot change ARCHIVELOG-MODE via EM

#21

gazzag wrote:

Quote:

On 9 Mar, 14:37, gs <g... (AT) gs (DOT) 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

#22

On Mar 9, 10:14*am, gazzag <gar... (AT) jamms (DOT) org> wrote:

snip

Quote:

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.

#23

"gazzag" <gareth (AT) jamms (DOT) org> wrote

Quote:

On 6 Mar, 13:03, "Matthias Hoys" <a... (AT) spam (DOT) 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@XXXXXXXX

HTH

-g

Guess not then :-)

Matthias

#24

Op 9-3-2010 23:10, Matthias Hoys schreef:

Quote:

"gazzag"<gareth (AT) jamms (DOT) org> wrote in message
news:a66f4682-ade0-4ffd-9eb6-bb6182859b12 (AT) z11g2000yqz (DOT) googlegroups.com...
On 6 Mar, 13:03, "Matthias Hoys"<a... (AT) spam (DOT) 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@XXXXXXXX

HTH

-g

Guess not then :-)

Matthias

They never were....

Shakespeare

#25

Shakespeare wrote:

Quote:

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

#26

On Mar 10, 3:39*am, Frank van Bortel <frank.van.bor... (AT) gmail (DOT) com>
wrote:

snip

Quote:

Try with 9.2: they are!

This was on the original post ... "connected to an Oracle 10.2" which
is what I believe Shakespeare was referring to with the "They never
were" part.

#27

On 9 Mar, 23:25, Shakespeare <what... (AT) xs4all (DOT) nl> wrote:

Quote:

They never were....

Shakespeare-

Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\>set ORACLE_SID=XXXXXX

C:\>sqlplus / as sysdba
Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
where <option> ::= -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
<logon> ::= <username>[/<password>][@<connect_string>] | / | /
NOLOG
<start> ::= @<URI>|<filename>[.<ext>] [<parameter> ...]
"-H" displays the SQL*Plus version banner and usage syntax
"-V" displays the SQL*Plus version banner
"-L" attempts log on just once
"-M <o>" uses HTML markup options <o>
"-R <n>" uses restricted mode <n>
"-S" uses silent mode

C:\>sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.8.0 - Production on Wed Mar 10 13:10:57 2010

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Release 9.2.0.8.0 - Production
JServer Release 9.2.0.8.0 - Production

SQL>

#28

On Mar 10, 8:13*am, gazzag <gar... (AT) jamms (DOT) org> wrote:

snip

Quote:

Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\>set ORACLE_SID=XXXXXX

C:\>sqlplus / as sysdba
Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
where <option> ::= -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
* * * <logon> *::= <username>[/<password>][@<connect_string>] |/ | /
NOLOG
* * * <start> *::= @<URI>|<filename>[.<ext>] [<parameter> ...]
* * * * "-H" displays the SQL*Plus version banner and usage syntax
* * * * "-V" displays the SQL*Plus version banner
* * * * "-L" attempts log on just once
* * * * "-M <o>" uses HTML markup options <o
* * * * "-R <n>" uses restricted mode <n
* * * * "-S" uses silent mode

C:\>sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.8.0 - Production on Wed Mar 10 13:10:57 2010

Copyright (c) 1982, 2002, Oracle Corporation. *All rights reserved.

Connected to:
Oracle9i Release 9.2.0.8.0 - Production
JServer Release 9.2.0.8.0 - Production

SQL

The OP posted 10.2 in the original post in this thread.

#29

On Mar 10, 3:03*pm, John Hurley <johnbhur... (AT) sbcglobal (DOT) net> wrote:

Quote:

On Mar 10, 8:13*am, gazzag <gar... (AT) jamms (DOT) org> wrote:

snip

Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\>set ORACLE_SID=XXXXXX

C:\>sqlplus / as sysdba
Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ]
where <option> ::= -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]
* * * <logon> *::= <username>[/<password>][@<connect_string>]| / | /
NOLOG
* * * <start> *::= @<URI>|<filename>[.<ext>] [<parameter> ...]
* * * * "-H" displays the SQL*Plus version banner and usage syntax
* * * * "-V" displays the SQL*Plus version banner
* * * * "-L" attempts log on just once
* * * * "-M <o>" uses HTML markup options <o
* * * * "-R <n>" uses restricted mode <n
* * * * "-S" uses silent mode

C:\>sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.8.0 - Production on Wed Mar 10 13:10:57 2010

Copyright (c) 1982, 2002, Oracle Corporation. *All rights reserved.

Connected to:
Oracle9i Release 9.2.0.8.0 - Production
JServer Release 9.2.0.8.0 - Production

SQL

The OP posted 10.2 in the original post in this thread.

And Shakespeare said "they never were" and gazzag showed they
were.

Thread drift happens, deal with it.

jg
--
@home.com is bogus.
http://1.bp.blogspot.com/_bMH90GEkTL...00-h/drive.jpg

#30

On Mar 10, 8:35*pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:

snip

Quote:

The OP posted 10.2 in the original post in this thread.

And Shakespeare said "they never were" and gazzag showed they
were.

Thread drift happens, deal with it.

Unless Shakespeare replies back hard to know for sure if his reply was
specifically targeted to the posting by the OP.

I thought almost everyone in the Oracle DBA world realized that the
double quotes were gone after version 9. It certainly was talked
about a lot back then.