What is the difference between the SQL*Loader and IMPORT
utilities?
Answer Posted / swetha
1) sql*loader is used only to load data into database
tables from external files.
It's all about data loading.
2) Import is used to read and write the operating system
files in and out of database.
it's completely a different aspect.
We can deal with structures as well as data here.
We can import entire database or a particular user/schema
or required table spaces with structures or even with data
according to the requirement.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between oracle media recovery and crash recovery?
as a technical developer in oracle applications which type errors feced in your experience sofar
What view would you use to determine free space in a tablespace?
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
What is Restricted Mode of Instance Startup in Oracle?
What is auto invoicing? Explain : oracle accounts receivable
which one is currently in used software cmpanies.
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable
What is the use of lockboxes? : oracle accounts receivable
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
can we use lexical perameter in oracle plsql if yes how
8. Supporting AP, AR and GL?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
What is the difference between recovery and restoring of the oracle database?