Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> sys as sysdba within a script?
Hello.
I'm trying to run a batch job that requies sysdba privilege. Specifically, I trying to perform a transportable tablespace export within a script. However, the following command will encounter an error (caused by "as sysdba" clause)
exp sys/password as sysdba transport_tablespace-y tablespaces=tbs1 triggers=y file=test.dmp
Is there any way to get around that so I don't have to maually enter the sysdba password every time the script runs? Received on Mon Dec 20 2004 - 14:26:50 CST