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...

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

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

what functionality does oracle provide to secure sensitive information?

981


What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1095


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

1070


What is dcl? : sql server DBA

1253


What the different topologies in which replication can be configured? : sql server DBA

1258


Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2285


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

1192


Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1067


how can you generate profile of pl/sql applications to identify performance bottlenecks?

1073


What happens on checkpoint? : sql server DBA

1086


what are the types of connection load-balancing?

994


What are the different types of upgrades that can be performed in sql server? : sql server DBA

1202


Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2036


What are the different types of database compression introduced in sql server 2008? : sql server DBA

1095


What the different components in replication and what is their use? : sql server DBA

1042