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 |
What is multoorg and what is it's level or structure
Can you explain the difference between architecture followed in 10g & 11g?
explain registration steps of a concurrent program.
What r the type Models in the system parameters of the report?
What are do's and dont's of Interface?
tell my any difficult situtation you solved in your experience in your company?
oracle apps architecture
how can i print random rows in plsql table
What are file in oracle.
What is the Exception. Types of exception, Difference between those. And example
what is global tempory table?
What is cursor?