Monday, August 3, 2009

Oracle 10g: Database Connection via SQL*PLUS

1. Open a command prompt.
2. To open SQL*PLUS console..do this..:
  • set oracle_sid=[instance/database]
  • sqlplus /nolog

3. Then...[I just created my table ..therefore I am logging in as sysdba]:
  • conn [username]/[password] as sysdba
4. There you go..You are connected!

No comments: