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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
