Database Utilities (MOSC)

MOSC Banner

impdb tables data based on date

edited Jun 26, 2014 4:00PM in Database Utilities (MOSC) 13 commentsAnswered ✓

Hi Team,

I am trying to refresh our Dev database based on some requested tables, which is not an issue, but I was wondering if there is a parameter within [ impdp ] to filter data based on date. For instance, I want to grab all tables that start with " _FACT " and qualify its data by year 2014.  Please note, there is a column name called DATE_ID that I can use to qualify the date to get year 2014 data only.  Also, my exported dump file has all tables. My database version is 11.2.0

Thank you for your input.
-AJ

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center