Skip to Main Content

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 data from external table

user8786417Jun 24 2014 — edited Jun 24 2014

Hi,

I want to copy the data from my external table and store it historically in a permancent table. How can i do this and set a schedule to run this job every x mins?

I think i will need a bit of PL\SQL and maybe somesort of internal database job to run.

Can someone please advise, i am new to this.

Many thanks.

Rgds,

Hussain

Comments

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

Post Details

Locked on Jul 22 2014
Added on Jun 24 2014
4 comments
178 views