Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Mix of Script's with import
Martin,
I use Perl scripts to automate these types of tasks on Windows servers. The following script shows how I do a full database export within Perl. http://www.dotcomsolutionsinc.net/products/installgen/win_901_32bit_files/in stallgen_win901_35_.html
The concept would be similar when using the import utility. The following script shows how you can run sql scripts with sqlplus from within a Perl program (you will want to scroll down towards the bottom of the file): http://www.dotcomsolutionsinc.net/products/installgen/win_901_32bit_files/in stallgen_win901_17_.html
David Simpson
www.dotcomsolutionsinc.net
"Martin Gehrke" <Martin.Gehrke_at_gawrijlidis_SMP.de> wrote in message
news:ageebn$cek$1_at_newsreader2.netcologne.de...
> We have the problem, that we have to create new Tablespace and users by
> script
> and then to call imp with existing backup dump file for this new users
> automatically.
> After this some other scripts should be executed.
> All in one session without going to Dos prompt for separat import.
> Does anyone has an idea or hint?
> Oracle Vers. 8.0.5 - 9.2.0 under NT
>
> Thanks
> Martin
>
>
>
Received on Tue Jul 09 2002 - 09:39:14 CDT
![]() |
![]() |