expdp using query on date
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'"'