DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: question regarding expdp utility

Threaded View

  1. #4
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    I have been practising use of expdp and impdp. I m facing this problem.
    C:\>expdp 'hr/hr@orac as sysdba' dumpfile=t2.dmp logfile=lg2.log query=employees : "where department_id in (20)"

    Export: Release 10.2.0.1.0 - Production on Thursday, 16 July, 2009 15:31:24

    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
    With the Partitioning, OLAP and Data Mining options
    ORA-39001: invalid argument value
    ORA-39035: Data filter SUBQUERY has already been specified.


    The action suggested "Specify a different data filter" is not understood to me. That's why , I need assistance.
    Last edited by mahajanakhil198; 07-16-2009 at 06:09 AM.
    lucky

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width