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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Export using WinNT AT Command

Re: Oracle Export using WinNT AT Command

From: Alan <alanshein_at_erols.com>
Date: Wed, 20 Mar 2002 09:56:20 -0500
Message-ID: <a7a7uf$jsu9v$1@ID-114862.news.dfncis.de>


Here's an educated guess:

Try this after the ECHO line:

c:
cd \oracle\ora81\network\admin

Basically, you may need to make the directory with tnsnames.ora the current directory. Another possibility is that you are not running the AT command as a user who has rights to that directory.

"Meier Roland" <Roland_Meier_at_freesurf.ch> wrote in message news:a7a5mf$9gn$1_at_rex.ip-plus.net...
> Dear all,
>
> I have the following simple batch file. This batch exports an oracle
> database and packs it. When i am running the scrip manually the script
works
> fine, if i am running it using an AT command it cannot resolve TNS Name.
>
> Can anyone help me please ?
>
> Roland
>
> ECHO BACKING UP TST82 DATABASE. PLEASE WAIT...
>
>
> C:\oracle\ora81\bin\exp816.exe user/password_at_tst82 FULL=Y
> FILE=E:\Databases\TEMP\tst82.dmp LOG=E:\Databases\TEMP\tst82.log
>
>
>
> c:\winzip\wzzip.exe E:\Databases\tst82.zip E:\Databases\TEMP\*.*
>
>
>
>
>
Received on Wed Mar 20 2002 - 08:56:20 CST

Original text of this message

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