Database Utilities (MOSC)

MOSC Banner

expdp using query on date

edited Sep 2, 2017 5:00AM in Database Utilities (MOSC) 4 commentsAnswered

Hello !

I am trying to understand how to export data between two dates. I cannot make it.

I read other threads here and trying what seems to work for them but I get an error

Maybe a typo or other error from me, but I do not see it

I created a test table by running create test as select * from dba_objects

now I want to export that table with rows between a certain interval and I use

this command

expdp mymaint/my00maint DIRECTORY=DATA_PUMP_DIR DUMPFILE=test.dmp tables=test reuse_dumpfiles=yes

query='TEST:"where to_char(CREATED,'YYYY-MM-DD') between '2016-12-17' and '2016-12-18'"'

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