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!

Copy table data online to Local Drive

Diwakar DayalanOct 20 2009 — edited Oct 21 2009

Hi Friends,

I have Oracle 9i installed in my machine. I have around 40 tables in a schema (SSDX_GEN) starting with the qualifier REF_IN_* (for inbound tables) and REF_OUT_* (for Outbound tables - for downstream).

I am a user (without DBA access to this schema and tables), i need to take a backup of data daily in my local machine.

How can i approach this requirement. Is there any script to take a backup of all in-bound tables(REF_IN_*) in my local machine?

Thanks for your help in advance.

Regards,
Diwakar

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2009

Added on Oct 20 2009

#backup

6 comments

418 views