Skip to Main Content

Oracle Forms

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!

Automate several table download in csv format from Oracle database

hemanAug 3 2013 — edited Aug 6 2013

Hi All,  I am new to Oracle database usage and currently using SQL Developer and PL/SQL for my day to day work.  Please help me with the below.

Currently I am querying a table for few columns and using EXPORT facility from Query Result tab.  However, I want to do this for several tables.  If possible I would like to keep all these table downloads as overnight job.  Is there a way to do this?

Thanks in advance.

Comments

Aravind N

Hi,
This is a known bug and is documented in MOS document ID 784038.1

If you are not particular about using exp/imp, try expdp and impdp which would be faster as well. Else you might have to apply the patch mentioned to fix this.

-Aravind

Paul M.
Answer

I like to copy the data from 10.2.0.4 oracle database to 11.2.0.3 db, so i tried to fired the traditional export from 11gr2 db server throw network

Apart that you should use expdp, you can't export a database using an exp utility from an higher version, you have to export using 10g exp utility, and import using 11g imp utility.

Export done in US7ASCII character set and AL16UTF16 NCHAR character set

server uses AL32UTF8 character set (possible charset conversion)

Couldn't this be a problem ? You should set NLS_LANG environment variable before exporting and importing.

Marked as Answer by 906790 · Sep 27 2020
Mark D Powell

I agree with Paul that if you are going to use exp you must use the 10.2 version to perform the export which the 11.2 imp can then process.  If you use expdp to run the export then you should be able to use the 11.2 version providing you specify the version= parameter to identify that an older database is being read. 

HTH -- Mark D Powell --


1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 3 2013
Added on Aug 3 2013
3 comments
442 views