oracle - export large number of tables using expdp -


my environment has more 4000 tables. want export 2000 tables. tried using par file using include clause. export failing. details mentioned below

tool: expdp | oracle database version:11g r2 | number of tables exported: 2000

code used:

directory=pump dumpfile=exp_full_gold.dmp logfile=exp_full_gold.log compression=all schemas=gold include=table:"in('t1','t2','t3','t4'..'t2000')

error: partitioning, olap, data mining , real application testing options ora-39001: invalid argument value ora-39071: value include badly formed. ora-00920: invalid relational operator

even tried below code:

directory=pump  dumpfile=exp_full_gold.dmp  logfile=exp_full_gold.log  compression=all  schemas=gold content=data_only include=table:\"in \(select tname gold.t11\)\"

here t11 contains list of tables stored in column tname (2000 records).

but same error occurs. please searched on net lot, not able find solution. include clause number of tables allowed limit not available anywhere. tried using 900 tables failed same error.

regards,

sujit

found solution:

schemas=gold directory=debug compression=all content=data_only dumpfile=exp_gold_26jul2017.dmp logfile=exp_gold_26jul2017.log include=table:"in(select tname gold.t11)"

thanks.


Comments

Post a Comment

Popular posts from this blog

python - Selenium remoteWebDriver (& SauceLabs) Firefox moseMoveTo action exception -

while performing simple hover test on firefox through selenium (3.4.0) python bindings (3.4.3) using of available os in saucelabs (except linux, latest available firefox version old), performing following actionchain: hover = actionchains(driver) hover.move_to_element(elm_men_menu).perform() it throws following error: taceback: file [...] in testhover hover.perform() file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/common/action_chains.py", line 80, in perform action() file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/common/action_chains.py", line 290, in <lambda> command.move_to, {'element': to_element.id})) file "/usr/local/lib/python2.7/dist-packages/selenium/webdriver/remote/webdriver.py", line 256, in execute self.error_handler.check_response(response) file "/usr/local/lib/python2.7/...
Read more

html - How to custom Bootstrap grid height? -

why bootstrap grid has height 591.067 ? did height came ? .main-post { padding: 20px; background-color: #fff; border: 1px solid #d8d8d8; margin-bottom: 100px; } .main-post .post-categories { margin-bottom: 10px } .main-post h3 { margin: 0 0 10px; color: #777; letter-spacing: -1px; font-weight: bold } .main-post .post-author, .main-post .post-date, .main-post .post-comments { font-size: 12px } .main-post img { display: block; margin: 10px 0; } .main-post .post-summary { line-height: 1.7; color: #888 } .main-post { color: #999 } <div class="col-sm-6"> <div class="main-post"> <h3 class="post-title"> <a href="#"> post title </a> </...
Read more

transpose - Maple isnt executing function but prints function term -

im using maple im in worksheetmode tried using maple input , 2d input , want transpose matrix a: := `<|>`(`<,>`(1, .5, -2), `<,>`(.5, 9/4+b, 5+3*b), `<,>`(-2, 5+3*b, 18+9*b+4*a)); b:= transpose(a); when exectute sheet dont translated values, there same input. matrix looks same input matrix plus function term. you can see picture in following link: why arent functions executed? meanwhile b:=a^+ doing right way , transposed matrix. other functions return function body instead needed values... if using 2d input mode (the default) space you've got between transpose , bracketed (b) interpreted multiplcation. rid of such space. also, either load package @ start of document like, with(linearalgebra): before calling transpose command package, or call it's full name like, linearalgebra:-transpose(b);
Read more