tag:blogger.com,1999:blog-5794742462833718439.post3431666105390787568..comments2024-03-26T16:41:52.813+06:00Comments on ORACLE: DBA's day out: Using QUERY parameter in expdp/impdpMohammad Hasan Shaharearhttp://www.blogger.com/profile/16334901749628047963noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-5794742462833718439.post-79925478002848443432013-03-26T15:42:58.213+06:002013-03-26T15:42:58.213+06:00Hi,
Any Query Parameter If i want to use it for m...Hi,<br /><br />Any Query Parameter If i want to use it for more than a tables with condition individually to each Table,Can we do it?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-39877954904807853372013-03-26T15:42:29.656+06:002013-03-26T15:42:29.656+06:00This comment has been removed by the author.Ashishhttps://www.blogger.com/profile/16348473370374632978noreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-67055730335551090812013-03-26T15:42:00.238+06:002013-03-26T15:42:00.238+06:00Hi,
Any Query Parameter If i want to use it for m...Hi,<br /><br />Any Query Parameter If i want to use it for more than a tables with condition individually to each Table,Can we do it?Ashishhttps://www.blogger.com/profile/16348473370374632978noreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-46058728889292156552013-03-26T15:40:00.226+06:002013-03-26T15:40:00.226+06:00in query optin can we use more condition for diff ...in query optin can we use more condition for diff table individually?Ashishhttps://www.blogger.com/profile/16348473370374632978noreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-72597899178880749312012-07-04T23:38:49.995+06:002012-07-04T23:38:49.995+06:00Hello, can you use "expdp" for export a ...Hello, can you use "expdp" for export a table with column at any order and adding other columns null? i am using a ".par" file with:<br /><br />QUERY=SCHEMA.TABLE1:'"SELECT COLUMN1, COLUMN2, COLUMN3, NULL,NULL,NULL,NULL,TO_CHAR(LASTDATE,'MM/DD/YYYY HH24:MI:SS')"'<br />NOLOGFILE=Y<br />DIRECTORY=MYDB<br />DUMPFILE=mytable_export.dmpTavoPlashttps://www.blogger.com/profile/06362461601158663140noreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-56646284316640932922012-06-18T22:07:04.492+06:002012-06-18T22:07:04.492+06:00nice post n more can be found here :
http://chand...nice post n more can be found here :<br /><br />http://chandu208.blogspot.com/2011/04/oracle-data-pump.htmlOracle DBAhttps://www.blogger.com/profile/13853786528521753164noreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-89807775380325920812012-05-08T23:44:26.123+06:002012-05-08T23:44:26.123+06:00Good work. More examples here..
http://shonythomas...Good work. More examples here..<br />http://shonythomas.blogspot.in/2012/01/oracle-10g-11g-datapump-expdp-query.htmlShonyhttps://www.blogger.com/profile/00445894755555234902noreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-37570543876289875082011-10-10T18:32:45.013+06:002011-10-10T18:32:45.013+06:00This comment has been removed by the author.Anjeet Kumarhttps://www.blogger.com/profile/04083211714336626287noreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-56036089209774648222011-10-10T18:32:15.371+06:002011-10-10T18:32:15.371+06:00try this
expdp hr/hr query="""wher...try this<br /><br />expdp hr/hr query="""where salary>15000""" tables=hr.employees directory=dir dumpfile=hr4.dmpAnjeet Kumarhttps://www.blogger.com/profile/04083211714336626287noreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-73956605053541867072011-10-06T09:07:43.073+06:002011-10-06T09:07:43.073+06:00@Mark Wintle
Are you sure ? I'm sure that the...@Mark Wintle<br /><br />Are you sure ? I'm sure that the syntax 'TABLE:' is correct. please check the oracle doc <br /><br />http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htmMohammad Hasan Shaharearhttps://www.blogger.com/profile/16334901749628047963noreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-14397001267808875722011-10-05T19:39:55.143+06:002011-10-05T19:39:55.143+06:00It should read tables=, not tables:
Otherwise, th...It should read tables=, not tables:<br /><br />Otherwise, this is a very useful example, thanks!Mark Wintlehttps://www.blogger.com/profile/05667026930690254382noreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-16915287084679319522010-12-13T06:36:57.760+06:002010-12-13T06:36:57.760+06:00I was too... be very careful with the escape chara...I was too... be very careful with the escape character ... better test out first before executing... I was having problem and ended up extracting tonnes of data that was quickly exhausted my database space.. I blog about my database work and system analysis actvities too at http://flcwork.co.ccFLChttp://flcwork.co.ccnoreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-342829508301285052010-10-20T02:25:54.585+06:002010-10-20T02:25:54.585+06:00Hi Hasan ;
I have been struggling with some '...Hi Hasan ; <br />I have been struggling with some '\' dashes and punctioations. Thank you much.<br />Come and visit my blog too.<br />http://www.comtmr.blogspot.com/Tamer ONEMhttp://www.comtmr.blogspot.com/noreply@blogger.comtag:blogger.com,1999:blog-5794742462833718439.post-21239799305159641452010-08-15T00:50:58.141+06:002010-08-15T00:50:58.141+06:00Hello
Thanks for this topics. It really helped me...Hello<br /><br />Thanks for this topics. It really helped me.Bishwaranjanhttps://www.blogger.com/profile/11432367520814475753noreply@blogger.com