a2zinterviews

5.	How you improve the performance of SQL*Loader?
	You can use direct path load to improve the performance. Indexes and constraints make inserts slow. Removing indexes and constraints improve performance of inserts; and therefore, of SQL*Loader.
	Discuss Your Name Your Email-ID Your Answer

6.	How can you load Microsoft Excel data into Oracle?
	You can save the data in text file with proper separators from Microsoft Excel. After that, SQL * Loader can be used to load the data from any other text file.
	Discuss Your Name Your Email-ID Your Answer

7.	Can you skip header records while loading?
	You can use the SKIP parameter to skip number of records. In addition, you can use SKIP = 1 to skip the header record.
	Discuss Your Name Your Email-ID Your Answer

8.	Can you skip header records while loading?
	You can use the SKIP parameter to skip number of records. In addition, you can use SKIP = 1 to skip the header record.
	Discuss Your Name Your Email-ID Your Answer