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
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
What is supporting issues GL AP and AR?
which one is currently in used software cmpanies.
What is the difference between conversions and interfaces? : oracle accounts receivable
Differentiate between transaction type and transaction source? : oracle accounts receivable
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
what is the link between suppliers and banks in ap module in oracle apps? And also query?
as a technical developer in oracle applications which type errors feced in your experience sofar
Explain prerequisites and post activities of oracle database installation
as a technical developer in oracle applications which type errors feced in your experience sofar
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
Why more redos are generated when the oracle database is in begin backup mode?
can u give guidance abt packages of plsql
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable