Are there any alternate tools other than sql* loader to
load data into oracle apps tables from external systems
Answers were Sorted based on User's Feedback
Answer / raam
Apart from sql*loader you can use UTL_FILE package to
upload the data from external systems to oracle tables.
| Is This Answer Correct ? | 21 Yes | 3 No |
Answer / amit trivedi
If you are on 9i and above you may use External Tables as
well. Though this feature has some limitations as to type
of delimiters that can be used.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / viswa
data loder,
utl_file,
with dba link(data should be in table),
pro*c,
style sheet convertion,
ora loader(tool)
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sachind
Apart from SQL Loader, web-adi can be used.Data Load is
another one but its windows specific.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / kks
You can use data pump (IMPDP) connect to external DB via DB
link and load the data.
| Is This Answer Correct ? | 1 Yes | 0 No |
why do we go for oracle apps technical other than sap and other packages?
name at least five reports in oracle inventory related to transaction ?
If we transfer the data from legacy system to oracle base tables. I want to hold the data in interface table how?
what is fiscalcalendar?
We have to show a logo/image in a report? what are the steps and which format it is?whether in pdf format is applicable or not?
How you will Diaplay the Company LOGO In report.Can anyone knows please give solution
How to print invoice from APPS(front end).if we have invoice number in hand with us???
how can develope the po variance and po summary report? with tables mandatory columns and query please?
What is GLOBAL TEMPORARY TABLE and It's significance ?
What do you understand by concurrent programs?
What are the tables in GL?
I am insert in data to a table X .Which one is better while writing commit statement After each row inset or after all row insert to table.