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
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
What is auto invoicing? Explain : oracle accounts receivable
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
which one is currently in used software cmpanies.
1. What is PO rate variance gain and loss?
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?
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?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
8. Supporting AP, AR and GL?
What is auto invoicing? : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
what are basic modules required to implement oracle application in any oraganisation?
What is db_recovery_file_dest in oracle? When do you need to set this value?