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

What is union and union all keyword in sql and what are their differences?

1086


What is the basic form of sql query?

923


What do you mean by stored procedures?

996


How can we store rows in PL/SQL using array?

1203


What is the best free sql database?

1041


What are the packages in pl sql?

1000


Explain the purpose of %type and %rowtype data types?

906


What is dense_rank?

924


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

939


What is scalar data type in pl sql?

1054


What is pessimistic concurrency control? : Transact sql

1070


Can we use join in subquery?

1073


Is clustered index a primary key?

932


what are date and time data types in mysql? : Sql dba

953


Is pl sql useful?

967