Re: How to login as SYS to run dbmsstdx.sql

From: Anton Buijs <aammbuijs_at_xs4all.nl>
Date: Sun, 25 Aug 2002 21:13:41 +0200
Message-ID: <akbac7$c0v$1@news1.xs4all.nl>

The logon question is answered by Anurag. The second question: do you mean: how to run a script? A script is run by using a "@" (most common) or the start command. Extention .sql is the default and added when no extention is given in the file name. So:

@dbmsstdx
or
start dbmsstdx

should do the job.

Some more info, since I get the impression you are new with Oracle (sorry if I'am wrong).
When script1 calls another script script2 by using @@script2
it means that "script2.sql" must be in the same directory as "script1.sql".

On Windows SQL*Plus searches for scripts in :

a. the current directory
b. the directories specified in the variable SQLPATH (if it exists)
c. the directories specified in the registry key

\\HKLM\Software\Oracle\Home0\SQLPATH
The list of directories is separated by a ";' . Example: C:\ORACLE\ORA90\DATABASE;C:\ORACLE\ORA90\DBS

Dave <dave1_nyc_at_hotmail.com> schreef in berichtnieuws 4e13bd55.0208251021.693dd00a_at_posting.google.com...
| Hello. I've just installed Oracle 9.2 on Windows2000. I would like my
| user to create stored procs, but the doc says that the script
| dbmsstdx.sql must be run first by the user SYS. However, when I try to
| use sqlplus and login as SYS it tells me that I should login as SYSDBA
| or SYSOPER.
|
| This is not a password problem, as I recall the password I set for SYS
| when I did the install.
|
| One other thing: When in sqlplus or the sqlplus "worksheet", I can
| execute normal SQL by ending it with a semi-colon. But I can't figure
| out what it's looking for when I load a .sql script.
|
| Thanks for any help
| Dave
Received on Sun Aug 25 2002 - 14:13:41 CDT