Hi,
My requirement is to archive records from main DB to the archive DB after certain period. Using Dblink facility, I'm able to perform any kind of activity on the archive DB, except copying from Table of MainDb to a Table of ArchiveDb. Is it possible to move the selective records using following kind of query:
select dblink_exec ('dbname = ArchiveDb', 'insert into Archive_Table select * from To_Be_Archived_Table')
Request your suggestions to achieve this.
Thanks,
RamaKrishna.