I have a requirement to export / extract certain rows (matching some query) of some tables from one oracle database and import those rows in the respective tables of other database.
both source and target tables have same schema.
My question is, .Whats the best way to implement this requirement.?
Heard of oracle export data pump utility but I have to extract only certain rows.Or Is there any other way to achive this programmatically.
thanks in advance.