Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: connecting automatically as sys
If the script you are running is on the database machine/server then
(depending on who is logged on) you can do this ...
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.5.0 - Production on Fri Jul 16 08:39:05 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect / as sysdba;
Connected.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 -
64bit Producti
on
But take the caveats of the earlier posters. DBMS JOB can be used to automate things along with other things such as OEM, scripts kicked off by the system when it is changing run levels, etc.
Plus the questions "what is it I need to do and why" along with "what is minimum authority level needed to accomplish this?". Received on Fri Jul 16 2004 - 07:43:38 CDT