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

Home -> Community -> Usenet -> c.d.o.tools -> Scheduled exports with 8.1.7

Scheduled exports with 8.1.7

From: Fredy Tschui <ftschui_at_edvpraxis.ch>
Date: Thu, 19 Apr 2001 09:49:26 +0200
Message-ID: <3ade976b$1_5@news.bluewin.ch>

Hello

I have troubles to run a scheduled export batch under Oracle 8.1.7 (Windows NT 4.0/SP5)
- When i'm running the export.bat from the command line, anything works fine.
- When i'm using the following AT-Command to schedule this batch, nothing works anymore

    at 23:00 /interactive /every:mo cmd /c .....\Export.bat

Thanks for any help,
Fredy

set ORACLE_SID=TEST
svrmgrl @.....\export.sql

connect internal;
shutdown immediate;
startup restrict;shutdown normal;
startup restrict;
host exp .....
alter system disable restricted session;

Dump file ORA00151.TRC
Tue Apr 10 18:56:00 2001
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows NT Version 4.0 Service Pack 5, CPU type 586 Oracle8i Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
Windows NT Version 4.0 Service Pack 5, CPU type 586 Instance name: test

Redo thread mounted by this instance: 1

Oracle process number: 0

151

Received on Thu Apr 19 2001 - 02:49:26 CDT

Original text of this message

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