I have these two files in my d:\oracle\ora81\bin
directory.
Windows 2000 Oracle 8.1.7

Contents of exp_test1.bat: ( 1 line )
exp user1/password1 parfile=usertables.txt

Contents of usertables.txt: (3 lines)
full = y
file = export_table_data.dmp
log = export_table_data.log


Make changes as necessary.

-- Jim Borths
-- Have a good day today and a better day tomorrow --


--- Oracle DBA Help <[Email Address Removed] wrote:
> Hi all,
>
> I've created the parfile to do this.but I was hoping
> to write a batch file
> in Windows 2000.
>
> The batch file I wrote contained this only:
>
>
>
> exp parfile=test.dat
>
>
>
> now the problem is that it's looping through the
> stmt infinite amt of time,
> unless I cancel. Is there something I should be
> doing?
>
>
>
> My parfile has the userid and password which is
> correct. I mean I've tried
> it in command and it works. But when trying to
> create a batch file, that's
> where I have problem.
>
>
>
> Also what I want it to do prior in batch was to
> create another batch file to
> connect to sqlplus and run the catexp.sql script.
>
> I haven't done scripting in some time.especially in
> Windows
>
> but I know can
>
>
>
> sqlplus [Email Address Removed]
> @%ORACLE_HOME%\rdbms\admin\catexp.sql
>
>
>
>
>
> The last stmt won't work.am I supposed to do
> something else there?
>
>
>
> Help would be really appreciated.
>
>


=====

- - - Have a good day today and a better day tomorrow - - -
[Email Address Removed] you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
Oracle LazyDBA home page