Copy data from external table

user8786417

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

Lalit Kumar B

To schedule the job use DBMS_SCHEDULER

SomeoneElse

and to get the rows from the external table to your history table, just use an insert/select.

insert into your_history_table (cols...)

select cols... from your_external_table;

Your external table is populated so often you need to do this every x minutes?

user8786417

does this need to be in a procedure? or i can simply use the statement when the job runs?

Thanks.

BluShadow

Wrap it in a procedure and have the scheduled job call the procedure.

You'll probably want a procedure anyway if you need to do 'other stuff' like truncating the table before you insert the fresh set of data or to gather statistics after loading a bulk of data etc.  It all depends on your exact requirements.