Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Shell script Import Export
Of course i've tested every single line of the scripts.
This is an action i've to do manually
But after more searching at other groups my problem is solved
by changing line 2 and 6
and adding 21 ans 61
> > 1 cd /proef/fis/impexp/imp
> > 2 sqlplus -S testfis/sysfis @impfis_1.sql <<label1
21 label1
> > 3 cd /proef/fis/impexp
> > 4 imp parfile=/proef/fis/impexp/import.par
> > 5 cd /proef/fis/impexp/imp
> > 6 sqlplus -S testfis/sysfis @impfis_2.sql <<label2
61 label2
hpuxrac schreef:
> 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:41:10 CDT