1 Reply Latest reply: Jun 25, 2014 9:43 AM by rp0428 RSS

    Datapump global where

    1016450

      Hi I am using datapump wizard for exporting data of 60 tables.It works fine with a simple where clause...

      however now i am using a subquery in global where

      global where :- where x in (select x from y where z='xyz');-- the log shows "missing expression"

       

      I tried another way :

      global where :- where x in (x1,x2...x10); -- the log shows "missing expression"

       

      Please let me know if datapump can handle slightly complex issues and subqueries...Is there any way oiut?