SIMPLE TIP for EXPORT USING QUERY PARAMETER

EXPORT USING QUERY


1.Run this query by cheking the where clause is working or not

select <column name> FROM <table_name> WHERE <column_name> BETWEEN to_date('31-JAN-12') and to_date('30-MAY-12');



2.Run EXPORT(EXPDP) by using "QUERY" parameter like below

expdp dumpfile=1111.dmp tables=<tablename> query=\"where INSERT_TIME BETWEEN to_date\(\'01-JAN-2012\'\) AND to_date\(\'04-MAR-2012\'\)\"


TIP: If your query is not working in EXP/EXPDP follow these steps
        
       1. 1st put where clause in DOUBLE QUOTES( " ")
       2. then put SLASH( \ ) before each and every symbol in the query parameter
       3. please dont use SLASH( \ ) in the dates and column names