Shell script Import Export

From: lian <lbo_at_helden.nl>
Date: 26 Jun 2006 04:46:53 -0700
Message-ID: <1151322413.422556.227960@m73g2000cwd.googlegroups.com>

Script below is to automate impor and export utility First a run this shell script with unix user prodfis   cd /proef/fis/impexp/exp
  sqlplus prodfis/sysfis @expfis_lbo.sql   cd /proef/fis/impexp
  exp parfile=/proef/fis/impexp/export.par

Now i've the export par file

The next file i want to run is

1 cd /proef/fis/impexp/imp
2 sqlplus testfis/sysfis @impfis_1.sql

3 cd /proef/fis/impexp
4  imp parfile=/proef/fis/impexp/import.par
5 cd /proef/fis/impexp/imp

6 sqlplus testfis/sysfis @impfis_2.sql

After the second row the script stops executing. In this script (row 2) there are several sql statements en some other sql scripts. The scripts is taking a 10 minutes to excecute

Can you give me some advise how to get this working. Received on Mon Jun 26 2006 - 06:46:53 CDT