Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is there a way to Oracle wait for the end of the OS process??

647619Aug 12 2008 — edited Aug 12 2008
Hi, all!!

I have this PL/SQL script that creates an user and imports a dump-file to it, using the command $imp... .
What I need to know is if there is some way to wait for the end of the OS process to continue the execution of the rest of the script. I mean:

Create user XXX identified by YYY ...
$imp XXX / YYY@instance ... -- this line starts a new OS process
--------- HERE, I WANT TO WAIT FOR THE PROCESS ABOVE TO END ---------
connect XXX / YYY@instance; -- and ONLY THEN this line will be processed.

Is this possible?

Thank's!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2008
Added on Aug 12 2008
9 comments
2,169 views