Have you thought of writing your own utility to implement copytable.
You will need to look at Pl/SQL procedures, external procedures(Oracle 8),
and a couple of the DBMS_ built in packages.I think you would need
DBMS_PIPE, and DBMS_UTLFILE.(Im not sure if these are the exact names)
For an experienced oracle developer, I would think this could be achieved
in a couple of days.
Richard F wrote in message <86318t$vh5$1_at_aklobs.kc.net.nz>...
>Thanks for your reply, yes I have looked at SQL Loader, but this is run
>externally where as copy table is run from within the ingres db, I don't
>actually know if there is any tool that can be executed from within Oracle
>(Sqlplus) to retrieve information from outside oracle. Any other ideas?
>
>Thanks again
>Richard
Received on Wed Jan 19 2000 - 10:41:05 CST
