What is the difference between the SQL*Loader and IMPORT
utilities?
Answer / 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 |
what is the difference between TRUNCATE and DELETE command in SQL
23 Answers ICICI, Saama Tech, SkyTech, TCS,
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
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?
When creating a user, what permissions must you grant to allow them to connect to the database?
What is the difference between conversions and interfaces? : oracle accounts receivable
When the procedures or packagess become invalidate
How to clone the database using RMAN back
How do you use trigger to create mutating state of table
what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable
What is the Symbol use for Inner Join
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable