Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sys as sysdba within a script?
"hastenthunder" <hastenthunder_at_hotmail.com> a écrit dans le message de
news:fAGxd.2260$Ny6.3593_at_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?
|
|
Try:
exp "sys/password as sysdba" transport_tablespace-y tablespaces=tbs1triggers=y file=test.dmp
Regards
Michel Cadot
Received on Mon Dec 20 2004 - 14:59:43 CST