dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

SP2-0640 Not connected. - Oracle Errors

This is a discussion on SP2-0640 Not connected. - Oracle Errors ; Oracle Error : SP2-0640 Not connected. Cause: The PASSWORD command was issued when there was no connection to the Oracle instance. Action: Connect to the Oracle database before re-issuing the PASSWORD command....


Home > Database Forum > Oracle Database > Oracle Errors > SP2-0640 Not connected.

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 10-28-2007, 06:54 AM
Database Bot
  
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default SP2-0640 Not connected.
Oracle Error : SP2-0640 Not connected.

Cause: The PASSWORD command was issued when there was no connection to the Oracle instance.

Action: Connect to the Oracle database before re-issuing the PASSWORD command.
Reply With Quote
  #2  
Old 03-04-2009, 08:40 AM
Database Newbie
  
Join Date: Mar 2009
Posts: 1
ravibeli is on a distinguished road
Default Re: SP2-0640 Not connected.
HTML Code:
Re: SP2-0640 Not connected.

1. you need to connect to the db before you start working 

Follow these three steps to connect to sql server
1. use "connect" command and enter it will ask you user-name after user-name next it will ask you to enter password of DB
example: (suppose user-name: scott and password: tiger)
SQL>connect
user-name: scott
password: tiger
Connected..
SQL> now you can start writing queries here.

Good luck

Ravi Beli
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode



All times are GMT -4. The time now is 01:41 PM.