Database Backup and Recovery (MOSC)

MOSC Banner

Data pump data filters. How to filter table data by timestamp?

edited Mar 4, 2016 11:16AM in Database Backup and Recovery (MOSC) 11 commentsAnswered ✓

Hello All,

I  know it's possible but don't know exactly how to go about it. So I have a requirement to take a export back of a few tables using DataPump(Data only). The challenge is I want to export only the affected rows or new rows from last sccessful full export lets say that was a week before. and then I want to import this data from the table export into another table of different database without indexes and other constraints. I know about metadata filters but I dont know how to achieve the export of data from the tables by

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center