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

How to export the table data (this table having 18 million
records) to .csv file. Please tell me is there any faster
way to export the data.

Answer Posted / vellai

Hi,
In oracle,We have SQL loader utility tool. You can use that
utility with out creating index and referencial constraint.
thereafter you can see 18 million records are loaded within
a hour into database.

Thank you
Vellai

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql better than access?

961


What is query execution plan in sql?

1125


What is sql used for?

1061


What is sql injection vulnerability?

868


what is offset-fetch filter in tsql? : Transact sql

890


Can we enter data in a table in design view?

910


What is left inner join in sql?

981


what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1080


name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1000


what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2411


What are the methods of filing?

872


What is the best partition size for windows 10?

946


What is normalization sql?

994


Mention what does plv msg allows you to do?

1053


Is sql a backend?

966