Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / chandrashekar

Answer Posted / chandrashekar

These two Oracle utilities are used for loading data into the database. The difference is that the import utility relies on the data being produced by another Oracle utility EXPORT while the SQL*Loader utility allows data to be loaded that has been produced by other utilities from different data sources just so long as it conforms to ASCII formatted or delimited files.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

949

how can you find out if a table can be redefined?

961

What are the steps you will take to improve performance of a poor performing query?

2791

What are the different types of indexes available in sql server? : sql server DBA

1107

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2095

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1917

what are the benefits of flashback feature?

954

What is the difference between dropping a database and taking a database offline? : sql server DBA

1012

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2057

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

2061

What is dcl? : sql server DBA

1184

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1884

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2397

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3343

What is the default port no on which sql server listens? : sql server DBA

1082