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 |
How to register a form and stored procedure in oracle apps
we are inserting,update and delete the data we can do simultaniously, but it will show error in updation? what to do?
In SQL Loader i have 100 Records to be loaded into my table. How do i load the first 30 Records and skip the last 10 Records within a single .ctl file ? So my total no.of records to be loaded would be 60. Could anybody help me in this ?
can we write sql statement in Format trigger?
HOW CAN U KNOW THE RESPONSIBILITY BELONGS TO OPERATING UNIT LEVEL OR NOT
while running a interface if we get 100 records as erors. how to debug it.
any one can expalin report registration steps?
what is pl/sql table and pl/sql records? what is the use of that?
HOW MANY LANGUAGES FOLDERS ARE ONE ORACLE APPLICATION
differentiate between intra & inter UOM class conversion with examples.
What is the link between AP and GL in oracle apps R/12?
4 Answers Bosch, Collabera, Synechron,
What are basic steps for AIM?