-
I was using SQLServer.
Now i am migrating it to Oracle.
I need to do bulkinsert from a text file into a Table.
in SQLServer there was bulkinsert command.
In oracle i tried UTL package.But it was very slow.
I tried SQLLoader in CMd prompt it was quite fast.
But how to use inside my procedure.
Ie. calling thesqlloader from inside my procedure.
Is there any way of doing it.
-
Hi.
You can run SqlLoader (or any other executable)
from within Oracle using ExtProc Listener.
If you have 9i you can use External tables feature, which
allows to manipulate data without loading it into DB.
Regards.
-
hi,
can you explain about how to use it .B'cos i am not familiar with it.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|