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
Give two methods you could use to determine what DDL changes have been made.
How many segment are present in Oracle Manufacturing
Why more redos are generated when the oracle database is in begin backup mode?
What is Restricted Mode of Instance Startup in Oracle?
which one is currently in used software cmpanies.
1. What is PO rate variance gain and loss?
A scenario for amount correction & how to use amount correction functionality in AP invoices
What is db_recovery_file_dest in oracle? When do you need to set this value?
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
What is the mandatory setup in cyclecount ?
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
What is supporting issues GL AP and AR?
How would you go about increasing the buffer cache hit ratio?