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 table? : Sql dba

1052


How many parts of a pl sql block are optional?

1119


How to execute a stored procedure?

1084


What do you mean by query optimization?

996


Is id a reserved word in sql?

1141


Define the select into statement.

1046


how can we optimize or increase the speed of a mysql select query? : Sql dba

938


When do we use triggers?

1071


What is memory optimized?

1076


What type of database is sql?

1019


How does rowid help in running a query faster?

1413


What is normalization in sql?

1008


What is the purpose of a sql?

973


What is sql character function?

1067


Which sorts rows in sql?

1011