https://blog.m9k.space/tags/expdp/ Заметки обо всём: devops, lifestyle, культура. M ru E2 (v3877; Aegea) M Заметки обо всём: devops, lifestyle, культура. 164 https://blog.m9k.space/all/oracle-cloning-scheme-in-entire-db/ Tue, 06 Aug 2024 07:27:14 +0000 M https://blog.m9k.space/all/oracle-cloning-scheme-in-entire-db/ <pre class="e2-text-code"><code class="">&gt;CREATE USER &lt;SCHEME_DEST&gt; IDENTIFIED BY &quot;&lt;SCHEME_DEST_PASSWORD&gt;&quot;; &gt;GRANT CONNECT TO &lt;SCHEME_DEST&gt;; &gt;GRANT CREATE SESSION TO &lt;SCHEME_DEST&gt;; &gt;ALTER USER &lt;SCHEME_DEST&gt; quota unlimited on &lt;DEFAULT_USER_TABLESPACE&gt;; &gt;expdp system/&lt;SYSTEM PASSWORD&gt;@&lt;DB_SID&gt; schemas=&lt;SCHEME_SRC&gt; directory=&lt;DIRECTORY NAME&gt; dumpfile=&lt;DUMP NAME&gt;.dmp logfile=explog.txt &gt;impdp system/&lt;SYSTEM PASSWORD&gt;@&lt;DB_SID&gt; directory=&lt;DIRECTORY NAME&gt; dumpfile=&lt;DUMP NAME&gt;.dmp logfile=implog.txt remap_schema=&lt;SCHEME_SRC&gt;:&lt;SCHEME_DEST&gt; transform=OID:N</code></pre>