Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Mix of Script's with import

Re: Mix of Script's with import

From: David Simpson <dsimpson_at_dotcomsolutionsinc.net>
Date: Tue, 09 Jul 2002 14:39:14 GMT
Message-ID: <lACW8.129879$Uu2.29304@sccrnsc03>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US