Category Archives: Oracle

3 Ways to Log In Through Sqlplus as ‘sysdba’

1.If you are a member of DBA group on the Linux/Unix OS level: sqlplus ‘/ as sysdba’ 2.Or you can first log on as ‘nolog’ sqlplus /nolog And then SQL>connect / as sysdba 3. Directly connect to Oracle instance as sysdba sqlplus ‘sys as … Continue reading

Posted in Oracle | Leave a comment

Get the “Current Directory” of an Oracle SqlPlus Session

I might be a very very late comer but I am starting to pick up Oracle and this is my first post about this platform. My current playground is my local win7 workstation with an Oracle Express Edition installed. And … Continue reading

Posted in Oracle | 1 Comment