Use the ORAPWD.EXE utility and create a password file: Assume your DB name is test:
1. Find any files named testpwd.ora. 2. Delete these file(s) 3. Find orapwd.exe and, at the command line: c:\oracle\ora92\bin> orapwd file=testpwd.ora password=ginger no spaces before or after the=signs. The sys as sysdba password will now be ginger. In the "User Name:" field of the SQL*Plus login screen, type: sys/[EMAIL PROTECTED] as sysdba of course substituting the name of your DB and your own password. HTH Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).