Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sys as sysdba within a script?

sys as sysdba within a script?

From: hastenthunder <hastenthunder_at_hotmail.com>
Date: Mon, 20 Dec 2004 15:26:50 -0500
Message-ID: <fAGxd.2260$Ny6.3593@mencken.net.nih.gov>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US