using query clause in expdp for timestamp character set
Hi Expert ,
i m facing problum with impdp. actually i have a table and size of table is very large but i have already taken the expdp of this table. now we are required to restore this backup in some other tablespace with other name in different DB. but we required on the data of spacifice date. to achieve this purpose i used query clause in impdp command.below is the sentext
impdp system/****** DIRECTORY=backup DUMPFILE=dump_file.dmp parfile=parfile=parfile.par content=data_only remap_schema=proddbuser:testdbuser
and in par file below is the content
include=TABLE:"IN ('testtable')"
QUERY="WHERE
NTIMESTAMP# between
to_date('20-APR-2011 01:00:59', 'DD-MON-YYYY HH24:MI:SS') and to_date('29-APR-2011 23:59:00', 'DD-MON-YYYY HH24:MI:SS')"
i m using where clause condition on NTIMESTAMP# which is of timestamp datatype.
now problum is when i execute impdp command its look its start in a good manner but it remain in process in seems its halted.
but it do not throw any error.
please tel me where i m wrong and what may be reason for this behavior of IMPDP
regards,