{"id":191,"date":"2023-03-02T12:14:15","date_gmt":"2023-03-02T12:14:15","guid":{"rendered":"https:\/\/www.matez.de\/?p=191"},"modified":"2023-03-02T12:14:16","modified_gmt":"2023-03-02T12:14:16","slug":"exclude-table-in-sqlcl-datapump","status":"publish","type":"post","link":"https:\/\/www.matez.de\/index.php\/2023\/03\/02\/exclude-table-in-sqlcl-datapump\/","title":{"rendered":"exclude table in sqlcl datapump"},"content":{"rendered":"\n<p>I was trying to use datapump feature of <a href=\"https:\/\/www.oracle.com\/de\/database\/sqldeveloper\/technologies\/sqlcl\/\">sqlcl <\/a>tool to export all tables from a schema, but it was not easy to find the solution to exclude a table in contrast to old expdp tool.<\/p>\n\n\n\n<p>So while in old expdp tool, the parameter can be filled like this: <code>EXCLUDE=TABLE:\u201dIN (\u2018CONTACTS\u2019,\u2019COUNTRIES\u2019,\u2019CUSTOMERS\u2019)\u201d\u00a0<\/code><\/p>\n\n\n\n<p>with sqlcl the parameters for exclusion do only allow object-types, one can get the same exclusion by table name using the <code>nameexpr<\/code> param and the <code>NOT IN<\/code> relational operator:<\/p>\n\n\n\n<p><code>-nameexpr TABLE:\"NOT IN (\u2018CONTACTS\u2019,\u2019COUNTRIES\u2019,\u2019CUSTOMERS\u2019)\"<\/code><\/p>\n\n\n\n<p>see documentation <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/sql-developer-command-line\/22.4\/sqcug\/using-data-pump.html\">here<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was trying to use datapump feature of sqlcl tool to export all tables from a schema, but it was not easy to find the solution to exclude a table in contrast to old expdp tool. So while in old expdp tool, the parameter can be filled like this: EXCLUDE=TABLE:\u201dIN (\u2018CONTACTS\u2019,\u2019COUNTRIES\u2019,\u2019CUSTOMERS\u2019)\u201d\u00a0 with sqlcl the parameters &hellip; <a href=\"https:\/\/www.matez.de\/index.php\/2023\/03\/02\/exclude-table-in-sqlcl-datapump\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;exclude table in sqlcl datapump&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[56,57,54,55],"_links":{"self":[{"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/posts\/191"}],"collection":[{"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/comments?post=191"}],"version-history":[{"count":1,"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/posts\/191\/revisions"}],"predecessor-version":[{"id":192,"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/posts\/191\/revisions\/192"}],"wp:attachment":[{"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/media?parent=191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/categories?post=191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.matez.de\/index.php\/wp-json\/wp\/v2\/tags?post=191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}