SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Data export from Oracle database in csv

851268Dec 3 2015 — edited Dec 3 2015

Hello All

I have set of 10 tables whose data I want to export in a csv file. One option is to use UTL_FILE and extract data. In some of the tables data is around 500 million rows, which I am planning to extract in chunks of 20 - 30 million records per file. Is UTL_FILE good option to take an export for tables with 500 million rows?

Secondly, can we use expdp to just export but selective set of records every time? For example, lets say table "TEST1" contain a column load_date which has dates. Is it possible to just export using EXPDP only those records where load_date = <<input parameter>>. Since, this is a recurring activity, as a result the data input has to be parameterized.

Anything suggestions would be really helpful.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 31 2015

Added on Dec 3 2015

15 comments

9,108 views