May 19, 2009 #1 THEaix MIS Joined Jun 7, 2007 Messages 30 Location US I am wanting to expdp FULL=y a database but use a query to export only where sysdate= x. or by using a between clause. Any help would be appriciated
I am wanting to expdp FULL=y a database but use a query to export only where sysdate= x. or by using a between clause. Any help would be appriciated
May 19, 2009 #2 Thargy Technical User Joined Nov 15, 2005 Messages 1,348 Location GB expdp can do what you want. You need to investigate the QUERY clause, which enables you to perform predicate logic on one or more tables. See http://download-west.oracle.com/docs/cd/B12037_01/server.101/b10825/dp_export.htm#sthref148 for details. Regards T Upvote 0 Downvote
expdp can do what you want. You need to investigate the QUERY clause, which enables you to perform predicate logic on one or more tables. See http://download-west.oracle.com/docs/cd/B12037_01/server.101/b10825/dp_export.htm#sthref148 for details. Regards T