https://mailnest.com/dbawiki/index.php?action=history&feed=atom&title=Recreate_objects_using_dbms_metadata.get_ddl 2026-04-05T15:09:13Z Revision history for this page on the wiki MediaWiki 1.29.3 https://mailnest.com/dbawiki/index.php?title=Recreate_objects_using_dbms_metadata.get_ddl&diff=96&oldid=prev 2011-12-08T20:06:40Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;' lang='en'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 20:06, 8 December 2011</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>===Recreate all the users(including grants) in a database===</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>===Recreate all the users (including grants) in a database===</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; select dbms_metadata.get_ddl(&#039;USER&#039;, username) || &#039;/&#039; ddl</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; select dbms_metadata.get_ddl(&#039;USER&#039;, username) || &#039;/&#039; ddl</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; from dba_users</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; from dba_users</div></td></tr> </table>

127.0.0.1 https://mailnest.com/dbawiki/index.php?title=Recreate_objects_using_dbms_metadata.get_ddl&diff=95&oldid=prev 2011-12-08T19:54:53Z

<p>Created page with &quot;===Recreate all the users(including grants) in a database=== select dbms_metadata.get_ddl(&#039;USER&#039;, username) || &#039;/&#039; ddl from dba_users union all select dbms_metadata.get_grant...&quot;</p> <p><b>New page</b></p><div>===Recreate all the users(including grants) in a database===<br /> select dbms_metadata.get_ddl(&#039;USER&#039;, username) || &#039;/&#039; ddl<br /> from dba_users<br /> union all<br /> select dbms_metadata.get_granted_ddl(&#039;ROLE_GRANT&#039;, username) || &#039;/&#039; ddl<br /> from dba_users<br /> union all<br /> select dbms_metadata.get_granted_ddl(&#039;SYSTEM_GRANT&#039;, username) || &#039;/&#039; ddl<br /> from dba_users<br /> union all<br /> select dbms_metadata.get_granted_ddl(&#039;OBJECT_GRANT&#039;, username) || &#039;/&#039; ddl<br /> from dba_users;</div>

127.0.0.1