Oracle 10g using the Sqlplus tool to log in to the database Sysdba

Two days ago, I saw a post on the itpub, referring to how to use the fastest way to SYSDBA log in to the database.

The method that is given is to sqlplus the direct carriage return and then enter/as SYSDBA when prompting the user name:

[Oracle@yans1 ~]$ Sqlplus

Sql*plus:release10.2.0.3.0-production on Saturday August 8 22:01:47 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Enter user-name:/As Sysdba

Connected to:

Oracle database10genterprise Edition release10.2.0.3.0-64bit Production

With the partitioning, OLAP and Data Mining options

Sql>

In fact, in 10g, Sqlplus has made improvements that can be directly followed by the Sqlplus/as SYSDBA without the need for double quotes or single quotes:

[Oracle@yans1 ~]$ Sqlplus/as SYSDBA

Sql*plus:release10.2.0.3.0-production on Saturday August 8 22:05:14 2009

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:

Oracle database10genterprise Edition release10.2.0.3.0-64bit Production

With the partitioning, OLAP and Data Mining options

Sql>

In 9i, Sqlplus does not yet have this feature and must enclose the/as SYSDBA on both sides.

bash-2.03$ Sqlplus/as SYSDBA

Usage:sqlplus [[<option>] [<logon>] [<start>]]

where <option>:: =-H | -V | [[L] [M <o>] [-R <n>] [-S]]

This article URL address: http://www.bianceng.cn/database/Oracle/201410/45455.htm

<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

bash-2.03$ sqlplus "/As SYSDBA"

Sql*plus:release9.2.0.4.0-production on Saturday August 8 22:25:16 2009

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

Connected to:

Oracle9i Enterprise Edition release9.2.0.4.0-64bit Production

With the partitioning, OLAP and Oracle Data Mining options

Jserver Release 9.2.0.4.0-production

Sql>

From this small change can also be seen, for Oracle's most basic sqlplus tools, is also constantly improving ease of use.