|
|
|
CONNECT
Start a user session.
Syntax:
CONNECT username [AS {SYSDBA|SYSOPER}]
CONNECT username/password [AS {SYSDBA|SYSOPER}]
CONNECT username/password@sid [AS {SYSDBA|SYSOPER}]
options:
username An Oracle User
sid Database System ID
In Oracle versions up to 8i 'INTERNAL' is a synonym for 'sys AS SYSDBA'
"I get to go to lots of overseas places, like Canada."
- Britney
Spears
Related Commands:
COMMIT
DISCONNECT
ROLLBACK
ALTER SYSTEM ENABLE RESTRICTED SESSION
SET TRANSACTION
Related Views:
DBA_PENDING_TRANSACTIONS
USER_RESOURCE_LIMITS
V$SESSION
V$SESSION_CONNECT_INFO
V$SESSION_CURSOR_CACHE
V$SESSION_EVENT
V$SESSION_LONGOPS
V$SESSION_OBJECT_CACHE
V$SESSION_WAIT
V$SESSTAT
V$SESS_IO