What is the difference between the SQL Loader and IMPORT
utilities?

Answer Posted / ramesh

SQL Loader and IMPORT are ORACLE utilities

SQL Loader is used to Load the Data from Delimiter Seperted
files and files with fixed and Vaariable width Text
One can also use plsql functions and procedures to load
desired foramtted data


Import is the Utility that can only tool that understands
Oracle Export Utility used to manke logical backup against
Database/Schemas

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is grd?

890


How would you extract DDL of a table without using a GUI tool?

2270


What is dbcc? : sql server DBA

1020


How would you best determine why your MVIEW couldn't FAST REFRESH?

2086


what is the use of ocr?

822


What is a correlated sub-query? : sql server DBA

814


Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

814


Where would you look for errors from the database engine?

2636


What are statistics, under what circumstances they go out of date, how do you update them?

2046


How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2211


what is the diffrence between core dba and apps dba?

2348


How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

945


What are the operating modes in which database mirroring runs? : sql server DBA

898


how can you record information about current session?

770


how can you connect from 10g user to 11g user??

1946