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


Please Help Members By Posting Answers For Below Questions

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

896


What is auto invoicing? Explain : oracle accounts receivable

790


while creating requisitions i am unable to see the list of organisation can anyone help me out ?

1921


which one is currently in used software cmpanies.

1863


1. What is PO rate variance gain and loss?

2518


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?

2151


Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7680


IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

1978


which gives Oracle R12 Financial training in delhi please give me answer its urgent?

2129


8. Supporting AP, AR and GL?

2034


What is auto invoicing? : oracle accounts receivable

842


How would you determine what sessions are connected and what resources they are waiting for?

1837


what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

1965


what are basic modules required to implement oracle application in any oraganisation?

1933


What is db_recovery_file_dest in oracle? When do you need to set this value?

877