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
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
How would you go about increasing the buffer cache hit ratio?
Is there any link between pr form(purchse requisition)and po form(purchase order)
How many segment are present in Oracle Manufacturing
What is the difference between oracle media recovery and crash recovery?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
Differentiate between transaction type and transaction source? : oracle accounts receivable
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?
how to write customizations in po
Explain prerequisites and post activities of oracle database installation
How to clone the database using RMAN back
Can we modify approve purchase order?if yes what is navigation?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me