Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Shell script Import Export
lian wrote:
> 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.
is impfis_1.sql exiting sqlplus? have you sucessfully tested line 2 of your script from command line? Received on Mon Jun 26 2006 - 07:23:45 CDT