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.

Why don't you post the contents of the parameter files and the sql scripts that you are trying to run for a starter.

Often when people are exporting from production and importing into another environment, the user schema that is being "imported into" is dropped and then re-created so that conflicts with existing contents are eliminated. Received on Mon Jun 26 2006 - 08:28:00 CDT