iSQL*Plus User's Guide and Reference
Release 9.0.1

Part Number A88826-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Command Reference, 13 of 38


CONNECT

CONN[ECT] { logon | / } [AS {SYSOPER|SYSDBA}]

where logon requires the following syntax:

Connects a given username to Oracle.

Terms | Usage | Examples | Top

Refer to the following list for a description of each term or clause:

username/password

connect_identifier

/ (slash)

AS {SYSOPER|SYSDBA}

Usage | Terms | Examples | Top

CONNECT commits the current transaction to the database, disconnects the current username from Oracle, and reconnects with the specified username.

If you log on or connect as a user whose account has expired, SQL*Plus prompts you to change your password before you can connect.

If an account is locked, a message is displayed and connection into that account (as that user) is not permitted until the account is unlocked by your DBA.

For more information about user account management, refer to the CREATE and ALTER USER commands, and the CREATE PROFILE command in the Oracle9i SQL Reference.

Examples | Terms | Usage | Top

To connect across Oracle Net with username HR and password HR to the database known by the Oracle Net alias as FLEETDB, enter

Keyboard icon
CONNECT HR/HR@FLEETDB

To connect as user HR, letting SQL*Plus prompt you for the password, enter

Keyboard icon
CONNECT HR

For more information about setting up your password file, refer to the Oracle9i Administrator's Guide.

To use a password file to connect to an instance on the current node as a privileged user named HR with the password HR, enter

Keyboard icon
CONNECT HR/HR AS SYSDBA

To connect to an instance on the current node as a privileged default user, enter

Keyboard icon
CONNECT / AS SYSDBA

In the last two examples, your default schema becomes SYS.


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback