Are there any alternate tools other than sql* loader to
load data into oracle apps tables from external systems
- 5 Answers
- 20089 Views
- Deloitte, IBM, I also Faced
- E-Mail Answers
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 |
do i need to declare bind parameter before using in the query?
How to write the no data found in XML Publiser Report in apps?
What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?
Is there any limitations on responsibility assigned to a apps user?
where do u specify in org_id?
when will formula,place holder and summary columns fire in reports?
how to move the one file from one instance to another instance?and ur scripts also?
In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.
What is profile and what is level of profile option and it's hierarchy
What is the use of format trigger?
What is sca and how is it useful?
How we will receive the work from the client? what type of documents we will develop in the entire implementation project? plz tell me the total scinario?
2 Answers Deloitte, Intelligroup,
Oracle Apps Technical 
