-- sample session ..execution of the batch job
C:>e

Export: Release 8.1.6.0.0 - Production on Thu Feb 20 11:28:48 2003

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
Export done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table                            EMP         14 rows exported
. . exporting table                           DEPT          4 rows exported
Export terminated successfully without warnings.

Table dropped.

Table dropped.

Table dropped.

Table dropped.

Import: Release 8.1.6.0.0 - Production on Thu Feb 20 11:28:54 2003

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Connected to: Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

Export file created by EXPORT:V08.01.06 via conventional path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
. importing MAG's objects into MAG
. . importing table                          "EMP"         14 rows imported
. . importing table                         "DEPT"          4 rows imported
Import terminated successfully without warnings.

Table created.

Table created.

--
-- this is batch script.
-- call this in your scheduler.
-- steps
--     do export
--     login to database and drop the objects (drop.sql)
--     do the import
--     login to database and create the objects(create.sql)

C:>type e.bat
@echo off
exp mag/mag tables=(emp,dept) file = s.dmp
sqlplus -s mag/mag  @drop.sql
imp mag/mag file=s.dmp tables=(emp,dept)
sqlplus -s mag/mag @create.sql

C:>type drop.sql
drop table dept;
drop table emp;
drop table dept_dept;
drop table emp_emp;
exit;
/
C:>type create.sql
create table emp_emp
as select * from emp;
create table dept_dept
as select * from dept;
exit;
/