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



Are there any alternate tools other than sql* loader to load data into oracle apps tables from ext..

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

Are there any alternate tools other than sql* loader to load data into oracle apps tables from ext..

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

Are there any alternate tools other than sql* loader to load data into oracle apps tables from ext..

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

Are there any alternate tools other than sql* loader to load data into oracle apps tables from ext..

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

Are there any alternate tools other than sql* loader to load data into oracle apps tables from ext..

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

Post New Answer

More Oracle Apps Technical Interview Questions

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

0 Answers   Tech Mahindra,


hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411

3 Answers   Oracle,


what is aim methodolozy

1 Answers  


What r the type Models in the system parameters of the report?

1 Answers  


how can u link a org-id with a responsibility in reports?

2 Answers   TCS,






in reports token is casesensitive or not?

2 Answers  


Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?

7 Answers   Satyam,


what is the back ground program run while transferring data from OM to AR?

4 Answers   Qwest,


A file has both header and corresponding lines. Explain design to load this data into respective interface tables.

1 Answers   Satyam,


What is INBOUND and OUT BOUND? (Different types of interfaces)

17 Answers   Accenture, Asian Paints, Inbound Solutions, Tech Mahindra,


while running a interface if we get 100 records as erors. how to debug it.

2 Answers   Zensar,


What is Value Set?

2 Answers   Accenture,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)