Skip to Main Content
  • Questions
  • How to export 44 lakhs of records from a table in oracle?

Breadcrumb

May 4th

Question and Answer

Chris Saxon

Thanks for the question, RUTHENDAR.

Asked: August 06, 2017 - 11:29 pm UTC

Last updated: August 07, 2017 - 2:50 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

How to export 44 lakhs of records from a table in oracle?

and Chris said...

The same way you'd export any other number of rows?

You could:

- Use data pump export
- Use the data export in SQL Developer (or similar tools)
- Spool the output of the query from SQL*Plus
- Query the data with your favourite tool, then manually write down the output (OK, probably not that one...)

It really depends on your requirements.

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

Utilities

All of the database utilities are explained in the Utilities guide.