Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using EXTPROC to then make a system call to EXP hangs the EXP
On Wed, 24 Dec 2003 09:38:04 -0000, "steve hayes"
<steve.hayes_at_baesystems.com> wrote:
>Oracle replication did not exist in a viable state (for the infrastructure)
>when this s/w was written. The imp/exp route was a stop gap that seemed to
>remain.
>
>By saying it's stupid, do you have any further strategy for diagnosing the
>fault ? or does this mean you just don't know why it will not work in this
>new version?
>
>Steve
>
Apparently you think you know everything better. Dismissing
replication as useless inevitably results in 'solutions' like you
have implemented.
The external procedure facility was designed to call dll's. It was not
designed to call Oracle utilities through the system command. You get
2 connections , you get 2 times all resources, etc etc.
To imagine this 'solution' is more 'viable' than using replication is
utterly ridiculous. You are using a sledgehammer to kill a mouse and
you know it.
-- Sybrand Bakker, Senior Oracle DBAReceived on Wed Dec 24 2003 - 10:50:03 CST