1. Normal mode:

OraCmd > connect username/password@host:port:SID;

example:

or:

OraCmd userid=username/password@host:port:SID

example:

If you want to hide password, use:

OraCmd > connect username@host:port:SID;

example:

or:

OraCmd userid=username@host:port:SID

example:

2. SysDBA mode:

OraCmd > connect username/password@host:port:SID as sysdba;

or:

OraCmd userid=username/password@host:port:SID mode=sysdba

To hide password, use:

OraCmd > connect username@host:port:SID as sysdba;

or:

OraCmd userid=username@host:port:SID mode=sysdba

3. SysOper mode:

OraCmd > connect username/password@host:port:SID as sysoper;

or:

OraCmd userid=username/password@host:port:SID mode=sysoper

To hide password, use:

OraCmd > connect username@host:port:SID as sysoper;

or:

OraCmd userid=username@host:port:SID mode=sysoper

Disconnect from Oracle:

OraCmd > disconnect;

OraCmd is a command-line tools that can run sql command, import/export data, even without Oracle client.

30-day free trial US$49.95