Implementation of oracle command line Logon

The oracle command line logon method may not be available to everyone. The following describes the implementation process of oracle command line logon in detail, hoping to help you learn about oracle command line logon.

C: \ Documents ents and Settings \ Administrator> sqlplus system/manager as sysdba

SQL * Plus: Release 10.2.0.1.0-Production on Monday November 30 19:24:16 2009

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connect:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options

SQL>

--------------------

C: \ Documents ents and Settings \ Administrator> sqlplus scott/tiger @ oracle

SQL * Plus: Release 10.2.0.1.0-Production on Monday November 30 20:31:05 2009

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connect:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the Partitioning, OLAP and Data Mining options

SQL>
 

Oracle tablespace creation syntax

Statement for creating a tablespace in oracle

Implementation of oracle re-Indexing

Use with statements to improve Oracle query efficiency

Using replacement variables to improve Oracle Interaction