{"id":374,"date":"2025-02-03T20:42:54","date_gmt":"2025-02-03T17:42:54","guid":{"rendered":"https:\/\/oraclius.com.tr\/?p=374"},"modified":"2025-04-05T21:47:29","modified_gmt":"2025-04-05T18:47:29","slug":"oracle-data-pump-expdp-impdp-kapsamli-rehber","status":"publish","type":"post","link":"https:\/\/oraclius.com.tr\/tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/","title":{"rendered":"Oracle Data Pump (expdp, impdp) &#8211; Kapsaml\u0131 Rehber"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Oracle Data Pump Nedir?<\/h2>\n\n\n\n<p>Oracle Data Pump, Oracle veritabanlar\u0131nda veri aktar\u0131m\u0131 i\u00e7in kullan\u0131lan y\u00fcksek performansl\u0131 bir ara\u00e7t\u0131r. <strong>expdp (export data pump)<\/strong> ve <strong>impdp (import data pump)<\/strong> komutlar\u0131yla veritaban\u0131 nesneleri h\u0131zl\u0131 ve verimli bir \u015fekilde d\u0131\u015fa ve i\u00e7e aktar\u0131labilir. Bu yaz\u0131da, Oracle Data Pump kullan\u0131m\u0131n\u0131 en ince detaylar\u0131na kadar ele alaca\u011f\u0131z.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Oracle Data Pump Kullan\u0131m Alanlar\u0131<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Veritaban\u0131 yedekleme ve geri y\u00fckleme<\/li>\n\n\n\n<li>Veri ta\u015f\u0131ma (migration)<\/li>\n\n\n\n<li>Geli\u015ftirme ve test ortamlar\u0131na veri aktar\u0131m\u0131<\/li>\n\n\n\n<li>B\u00fcy\u00fck veri setlerinin verimli y\u00f6netimi<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">1. EXPDP (DATA EXPORT)<\/h2>\n\n\n\n<p>Oracle Data Pump Export Modlar\u0131:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sutil\/oracle-data-pump-export-utility.html#GUID-079769D8-40F4-432F-88AD-E7264D7A2E2D\">Full Mode<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sutil\/oracle-data-pump-export-utility.html#GUID-2BBE8F6C-6D58-4C99-8A49-ED4DA53BECD2\">Schema Mode<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sutil\/oracle-data-pump-export-utility.html#GUID-0AA240BE-DBF3-452B-9F62-59CD2C2346D9\">Table Mode<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sutil\/oracle-data-pump-export-utility.html#GUID-90597B1B-9901-41A5-AE20-B36F6CEF6B50\">Tablespace Mode<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sutil\/oracle-data-pump-export-utility.html#GUID-BBDE50A3-4B7C-4A0A-8964-F689EF95651F\">Transportable Tablespace Mode<\/a><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1.1 Full Mode<\/h3>\n\n\n\n<p>Veritaban\u0131n\u0131n tamam\u0131n\u0131 d\u0131\u015fa aktarmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=backup_dir DUMPFILE=full_backup.dmp LOGFILE=full_backup.log FULL=Y;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">1.2 Schema Mode<\/h3>\n\n\n\n<p>Belirli bir veya birden fazla \u015feman\u0131n (kullan\u0131c\u0131n\u0131n) t\u00fcm nesnelerini d\u0131\u015fa aktarmak i\u00e7in kullan\u0131l\u0131r. <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\"><strong><code>SCHEMAS<\/code> <\/strong><\/mark>parametresi ile hangi \u015feman\u0131n d\u0131\u015fa aktar\u0131laca\u011f\u0131 belirtilir. Varsay\u0131lan olarak, i\u015flemi ba\u015flatan kullan\u0131c\u0131n\u0131n \u015femas\u0131 d\u0131\u015fa aktar\u0131l\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=backup_dir DUMPFILE=schema_backup.dmp LOGFILE=schema_backup.log SCHEMAS=HR,SCOTT;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">1.3 Table Mode<\/h3>\n\n\n\n<p>Belirli tablolar\u0131 d\u0131\u015fa aktarmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=backup_dir DUMPFILE=tables_backup.dmp LOGFILE=tables_backup.log TABLES=hr.employees,scott.departments;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">1.4 Tablespace Mode<\/h3>\n\n\n\n<p>Belirli tablespace\u2019leri yedekleyerek ta\u015f\u0131nmas\u0131n\u0131 sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=backup_dir DUMPFILE=tbs_backup.dmp LOGFILE=tbs_backup.log TABLESPACES=users;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">1.5 Transportable Tablespace Mode<\/h3>\n\n\n\n<p>Transportable Tablespace \u00f6zelli\u011fi bir dizi Tablespace&#8217;lerin bir Oracle veritaban\u0131ndan di\u011ferine ta\u015f\u0131man\u0131za olanak tan\u0131r. Bu modda yaln\u0131zca tablo alan\u0131n\u0131n meta verisi <code>expdp<\/code> ile d\u0131\u015fa aktar\u0131l\u0131r. As\u0131l veri dosyalar\u0131 (<code>.dbf<\/code> dosyalar\u0131) do\u011frudan fiziksel olarak kopyalan\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=backup_dir DUMPFILE=trans_tbs.dmp LOGFILE=trans_tbs.log TRANSPORT_TABLESPACES=users TRANSPORTABLE=Y;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">2. IMPDP(DATA IMPORT)<\/h2>\n\n\n\n<p>Oracle Data Pump Import Modlar\u0131:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sutil\/oracle-data-pump-export-utility.html#GUID-079769D8-40F4-432F-88AD-E7264D7A2E2D\">Full Mode<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sutil\/oracle-data-pump-export-utility.html#GUID-2BBE8F6C-6D58-4C99-8A49-ED4DA53BECD2\">Schema Mode<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sutil\/oracle-data-pump-export-utility.html#GUID-0AA240BE-DBF3-452B-9F62-59CD2C2346D9\">Table Mode<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sutil\/oracle-data-pump-export-utility.html#GUID-90597B1B-9901-41A5-AE20-B36F6CEF6B50\">Tablespace Mode<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/sutil\/oracle-data-pump-export-utility.html#GUID-BBDE50A3-4B7C-4A0A-8964-F689EF95651F\">Transportable Tablespace Mode<\/a><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2.1 Full Mode<\/h3>\n\n\n\n<p><strong>T\u00fcm veritaban\u0131n\u0131 i\u00e7e aktarmak i\u00e7in kullan\u0131l\u0131r.<\/strong>Export i\u015flemi de <strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">FULL=Y<\/mark><\/strong> parametresiyle yap\u0131lm\u0131\u015f olmal\u0131d\u0131r.<strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">EXP_FULL_DATABASE <\/mark>yetkisine sahip kullan\u0131c\u0131lar<\/strong> bu modu kullanabilir.<strong>T\u00fcm \u015femalar, tablolar, dizinler, g\u00f6r\u00fcn\u00fcmler, prosed\u00fcrler ve di\u011fer nesneler i\u00e7e aktar\u0131l\u0131r.<\/strong>Genellikle <strong>bir veritaban\u0131n\u0131 ba\u015fka bir sunucuya ta\u015f\u0131rken<\/strong> kullan\u0131l\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp system\/password@orcl DIRECTORY=backup_dir DUMPFILE=full_backup.dmp LOGFILE=full_import.log FULL=Y<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2.2 Schema Mode<\/h3>\n\n\n\n<p><strong>Belirli bir \u015feman\u0131n (kullan\u0131c\u0131n\u0131n) t\u00fcm nesnelerini i\u00e7e aktar\u0131r.<\/strong>Varsay\u0131lan mod budur. E\u011fer ba\u015fka bir mod belirtilmezse, yaln\u0131zca oturum a\u00e7an kullan\u0131c\u0131n\u0131n \u015femas\u0131 i\u00e7e aktar\u0131l\u0131r.<strong>Kullan\u0131c\u0131lar, kendi \u015femalar\u0131n\u0131 i\u00e7e aktarabilirler, ancak ba\u015fka bir \u015femay\u0131 i\u00e7e aktarmak i\u00e7in DBA yetkisi gerekir.<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp system\/password@orcl DIRECTORY=backup_dir DUMPFILE=schema_backup.dmp LOGFILE=schema_import.log SCHEMAS=HR<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2.3 Table Mode<\/h3>\n\n\n\n<p><strong>Sadece belirli tablolar\u0131 i\u00e7e aktarmak i\u00e7in kullan\u0131l\u0131r.Ba\u011flant\u0131l\u0131 tablolar ve <strong>ba\u011f\u0131ml\u0131 nesneler<\/strong> (dizinler, k\u0131s\u0131tlamalar, tetikleyiciler vb.) de i\u00e7e aktar\u0131l\u0131r.<\/strong> \u00d6zellikle <strong>b\u00fcy\u00fck veritabanlar\u0131ndan belirli tablolar\u0131 \u00e7ekmek i\u00e7in kullan\u0131\u015fl\u0131d\u0131r.<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp system\/password@orcl DIRECTORY=backup_dir DUMPFILE=tables_backup.dmp LOGFILE=tables_import.log TABLES=EMP,DEPT<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2.4 Tablespace Mode<\/h3>\n\n\n\n<p><strong>Belirtilen tablolar\u0131n bulundu\u011fu tablespace i\u00e7indeki t\u00fcm nesneleri i\u00e7e aktar\u0131r.<\/strong><strong>Tablespace baz\u0131nda veri ta\u015f\u0131mak i\u00e7in kullan\u0131l\u0131r.<\/strong>Kullan\u0131lmadan \u00f6nce, hedef veritaban\u0131nda <strong>ayn\u0131 tablespace ad\u0131 ile bir tablespace olu\u015fturulmal\u0131d\u0131r.<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp system\/password@orcl DIRECTORY=backup_dir DUMPFILE=tablespace_backup.dmp LOGFILE=tablespace_import.log TABLESPACES=USERS<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">2.5 Transportable Tablespace Mode<\/h3>\n\n\n\n<p><strong>Tablespace&#8217;leri farkl\u0131 veritabanlar\u0131 aras\u0131nda ta\u015f\u0131mak i\u00e7in en h\u0131zl\u0131 y\u00f6ntemdir.Sadece tablespace i\u00e7indeki nesneleri ta\u015f\u0131r, sistem tablolar\u0131n\u0131 ta\u015f\u0131maz.Export i\u015fleminde <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">TRANSPORTABLE=Y<\/mark> se\u00e7ene\u011fi ile al\u0131nm\u0131\u015f bir yede\u011fin kullan\u0131lmas\u0131 gerekir.Kaynak ve hedef veritabanlar\u0131nda ayn\u0131 tablespace ad\u0131 olmal\u0131d\u0131r.Ayn\u0131 karakter setini kullanan veritabanlar\u0131 aras\u0131nda \u00e7al\u0131\u015f\u0131r.<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp system\/password@orcl DIRECTORY=backup_dir DUMPFILE=transport.dmp LOGFILE=transport_import.log TRANSPORTABLE_TABLESPACES=USERS<\/code><\/pre>\n\n\n\n<p>Ek olarak datafile ayr\u0131 olarak ta\u015f\u0131n\u0131mal\u0131d\u0131r:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ALTER TABLESPACE USERS OFFLINE;\n!cp \/u01\/oracle\/oradata\/orcl\/users01.dbf \/target\/location\nALTER TABLESPACE USERS ONLINE;<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">3. EXPORT VE IMPORT ALMA ADIMLARI<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">3.1 Export Dosyas\u0131n\u0131n Path&#8217;ini Belirleme<\/h3>\n\n\n\n<p>Export alaca\u011f\u0131m\u0131z dump dosyas\u0131n\u0131 asm ve nfs \u00fczerinde belirledi\u011fimiz bir path&#8217;e alabiliriz. \u00d6nce dizin olu\u015ftural\u0131m:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>asmcmd mkdir +DATA\/EXPORT<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>mkdir -p \/home\/oracle\/EXPORT<\/code><\/pre>\n\n\n\n<p>NFS Dizininin yetkilerini ayarlayal\u0131m:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>chown -R oracle.oinstall \/home\/oracle\/EXPORT<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3.2 Export ve Import Kullan\u0131c\u0131s\u0131 Olu\u015fturma ve Yetkileri Tan\u0131mlama<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER PUMPUSER IDENTIFIED BY PUMPUSER;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT UNLIMITED TABLESPACE TO PUMPUSER;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT EXP_FULL_DATABASE TO PUMPUSER;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT IMP_FULL_DATABASE TO PUMPUSER;<\/code><\/pre>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\"><strong><code>EXP_FULL_DATABASE<\/code><\/strong> <\/mark>\u2192 Kullan\u0131c\u0131n\u0131n t\u00fcm veritaban\u0131n\u0131 <strong>export (d\u0131\u015fa aktarma)<\/strong> yapmas\u0131n\u0131 sa\u011flar.<\/p>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">IMP_FULL_DATABASE<\/mark><\/strong> \u2192 Kullan\u0131c\u0131n\u0131n t\u00fcm veritaban\u0131na <strong>import (i\u00e7eri aktarma)<\/strong> yapmas\u0131n\u0131 sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT CONNECT, RESOURCE TO PUMPUSER;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE OR REPLACE DIRECTORY EXPORT_DIR AS '\/home\/oracle\/EXPORT'\nveya\nCREATE OR REPLACE DIRECTORY EXPORT_DIR AS '+DATA\/EXPORT'<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT READ,WRITE ON DIRECTORY EXPORT_DIR TO PUMPUSER;<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3.3 Export Islemine Ba\u015flamas\u0131<\/h3>\n\n\n\n<p>\u00d6rnek bir export komutu:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp PUMPUSER\/PUMPUSER directory=EXPORT_DIR dumpfile=my_dump01.dmp logfile=my_logfile01.logfile content=metadata_only SCHEMAS=HR,SCOTT exclude=statistics<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3.4 Import Dosyas\u0131n\u0131n Path&#8217;ini Belirleme<\/h3>\n\n\n\n<p>Export ald\u0131\u011f\u0131m\u0131z dump dosyas\u0131n\u0131 asm ve nfs \u00fczerinde belirledi\u011fimiz bir path&#8217;e aktararak Import edebiliriz. \u00d6nce dizin olu\u015ftural\u0131m:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>asmcmd mkdir +DATA\/IMPORT<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>mkdir -p \/home\/oracle\/IMPORT<\/code><\/pre>\n\n\n\n<p>NFS Dizininin yetkilerini ayarlayal\u0131m:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>chown -R oracle.oinstall \/home\/oracle\/IMPORT<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">3.5 Export ve Import Kullan\u0131c\u0131s\u0131 Olu\u015fturma ve Yetkileri Tan\u0131mlama<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER PUMPUSER IDENTIFIED BY PUMPUSER;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT UNLIMITED TABLESPACE TO PUMPUSER;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT EXP_FULL_DATABASE TO PUMPUSER;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT IMP_FULL_DATABASE TO PUMPUSER;<\/code><\/pre>\n\n\n\n<p><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\"><strong><code>EXP_FULL_DATABASE<\/code><\/strong> <\/mark>\u2192 Kullan\u0131c\u0131n\u0131n t\u00fcm veritaban\u0131n\u0131 <strong>export (d\u0131\u015fa aktarma)<\/strong> yapmas\u0131n\u0131 sa\u011flar.<\/p>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">IMP_FULL_DATABASE<\/mark><\/strong> \u2192 Kullan\u0131c\u0131n\u0131n t\u00fcm veritaban\u0131na <strong>import (i\u00e7eri aktarma)<\/strong> yapmas\u0131n\u0131 sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT CONNECT, RESOURCE TO PUMPUSER;<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE OR REPLACE DIRECTORY IMPORT_DIR AS '\/home\/oracle\/IMPORT'\nveya\nCREATE OR REPLACE DIRECTORY IMPORT_DIR  AS '+DATA\/IMPORT'<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT READ,WRITE ON DIRECTORY IMPORT_DIR TO PUMPUSER;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">3.6 Import Islemine Ba\u015flamas\u0131<\/h3>\n\n\n\n<p>\u00d6rnek bir export komutu:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp PUMPUSER\/PUMPUSER directory=IMPORT_DIR dumpfile=my_dump01.dmp logfile=my_logfile01.logfile table_exists_action=replace<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">4. EXPORT VE IMPORT PARAMETRELERI<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">4.1 Export Parametreleri<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">4.1.<strong>1. \u0130\u015flem Ak\u0131\u015f\u0131 ve Kontrol Parametreleri<\/strong><\/h4>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ABORT_STEP<\/mark>:<\/strong> Export i\u015flemini ba\u015flat\u0131r ve belirtilen ad\u0131mda durdurur.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp LOGFILE=mylog.log <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ABORT_STEP<\/mark>=3<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ATTACH<\/mark>:<\/strong> Mevcut bir Export i\u015fine ba\u011flanmay\u0131 sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ATTACH<\/mark>=myjob<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">JOB_NAME<\/mark>:<\/strong> Export i\u015fi i\u00e7in bir ad tan\u0131mlar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">JOB_NAME<\/mark>=exp_full<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">KEEP_MASTER<\/mark>:<\/strong> Export i\u015finin kontrol tablosunun saklan\u0131p saklanmayaca\u011f\u0131n\u0131 belirler.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">KEEP_MASTER<\/mark>=YES<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">LOGFILE<\/mark>:<\/strong> Export i\u015flemi s\u0131ras\u0131nda olu\u015fturulan log dosyas\u0131n\u0131n ad\u0131n\u0131 belirler.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">LOGFILE<\/mark>=expdp.log<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">NOLOGFILE<\/mark>:<\/strong> Log dosyas\u0131 olu\u015fturulmas\u0131n\u0131 engeller.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">NOLOGFILE<\/mark>=YES<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">PARFILE<\/mark>:<\/strong> Parametrelerin bir dosyadan okunmas\u0131n\u0131 sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password PARFILE=export_params.par<\/code><\/pre>\n\n\n\n<p>export_params.par i\u00e7eri\u011fi:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DIRECTORY=dpump_dir\nDUMPFILE=mydump.dmp\nLOGFILE=expdp.log<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">STATUS<\/mark>:<\/strong> \u0130\u015fin durumu hakk\u0131nda periyodik bilgi verir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp STATUS=5<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">4.1.<strong>2. Verinin Hangi Format ve \u015eekilde D\u0131\u015fa Aktar\u0131laca\u011f\u0131n\u0131 Belirleyen Parametreler<\/strong><\/h4>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ACCESS_METHOD<\/mark>:<\/strong> Export i\u015flemi i\u00e7in kullan\u0131lacak veri eri\u015fim y\u00f6ntemini belirler.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp ACCESS_METHOD=DIRECT_PATH<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">COMPRESSION<\/mark>:<\/strong> Dump dosyas\u0131ndaki verilerin s\u0131k\u0131\u015ft\u0131r\u0131lmas\u0131n\u0131 sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp COMPRESSION=ALL<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">COMPRESSION_ALGORITHM<\/mark>:<\/strong> S\u0131k\u0131\u015ft\u0131rma i\u00e7in kullan\u0131lacak algoritmay\u0131 belirler.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp COMPRESSION_ALGORITHM=LOW<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">CONTENT<\/mark>:<\/strong> D\u0131\u015fa aktarma i\u015fleminin sadece veri, sadece metadata veya her ikisini i\u00e7ermesini belirler.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp CONTENT=DATA_ONLY<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">DATA_OPTIONS<\/mark>:<\/strong> Veri i\u015fleme ile ilgili ek se\u00e7enekler sunar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp DATA_OPTIONS=SKIP_LOB_STORAGE<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">DUMPFILE<\/mark>:<\/strong> Dump dosyalar\u0131n\u0131n adlar\u0131n\u0131 ve dizinlerini belirler.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydata.dmp<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ENCRYPTION<\/mark>:<\/strong> Dump dosyas\u0131na yaz\u0131lacak verilerin \u015fifrelenmesini sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp ENCRYPTION=ALL ENCRYPTION_PASSWORD=mysecret<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ENCRYPTION_ALGORITHM<\/mark>:<\/strong> \u015eifreleme i\u00e7in kullan\u0131lacak algoritmay\u0131 belirler.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp ENCRYPTION_ALGORITHM=AES256<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ENCRYPTION_MODE<\/mark>:<\/strong> \u015eifrelemenin hangi seviyede uygulanaca\u011f\u0131n\u0131 belirler.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp ENCRYPTION_MODE=PASSWORD<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ENCRYPTION_PASSWORD<\/mark>:<\/strong> \u015eifreleme i\u00e7in parola belirler.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp ENCRYPTION_PASSWORD=mysecurepwd<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ENCRYPTION_PWD_PROMPT<\/mark>:<\/strong> \u015eifreleme parolas\u0131n\u0131n interaktif olarak girilmesini sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp ENCRYPTION_PWD_PROMPT=YES<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ESTIMATE<\/mark>:<\/strong> D\u0131\u015fa aktarman\u0131n ne kadar disk alan\u0131 kullanaca\u011f\u0131n\u0131 tahmin eder.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp ESTIMATE=BLOCKS<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ESTIMATE_ONLY<\/mark>:<\/strong> Sadece alan tahmini yapar, d\u0131\u015fa aktarma i\u015flemi yapmaz.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir ESTIMATE_ONLY=YES<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">FILESIZE<\/mark>:<\/strong> Dump dosyas\u0131n\u0131n maksimum boyutunu belirler.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump_%U.dmp FILESIZE=1G<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">LOGTIME<\/mark>:<\/strong> Log dosyas\u0131na zaman damgas\u0131 ekler.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp LOGTIME=ALL<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">METRICS<\/mark>:<\/strong> Export i\u015flemi ile ilgili daha detayl\u0131 istatistikleri log dosyas\u0131na yazar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp METRICS=YES<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">4.1.<strong>3. D\u0131\u015fa Aktar\u0131lacak Verinin Se\u00e7ilmesi<\/strong><\/h4>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">EXCLUDE<\/mark>:<\/strong> Belirtilen nesneleri d\u0131\u015fa aktarmaz.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp EXCLUDE=TABLE:\"='EMPLOYEES'\"<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">INCLUDE<\/mark>:<\/strong> Belirtilen nesneleri d\u0131\u015fa aktar\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp INCLUDE=TABLE:\"='EMPLOYEES'\"<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">QUERY<\/mark>:<\/strong> Belirtilen sorguya uygun sat\u0131rlar\u0131 d\u0131\u015fa aktar\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp QUERY=\"WHERE hire_date &gt; '01-JAN-2020'\"<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">REMAP_DATA<\/mark>:<\/strong> Belirtilen kolon verilerini d\u00f6n\u00fc\u015ft\u00fcrerek d\u0131\u015fa aktar\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp REMAP_DATA=EMPLOYEES.SALARY:TO_NUMBER(SALARY)*1.1<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">SAMPLE<\/mark>:<\/strong> Verinin belirli bir y\u00fczdesini d\u0131\u015fa aktarmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp SAMPLE=50<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">4.1.<strong>4. D\u0131\u015fa Aktarma Modlar\u0131<\/strong><\/h4>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">FULL<\/mark>:<\/strong> T\u00fcm veritaban\u0131n\u0131 d\u0131\u015fa aktarmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp FULL=YES<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">SCHEMAS<\/mark>:<\/strong> Belirtilen \u015femalar\u0131n d\u0131\u015fa aktar\u0131lmas\u0131n\u0131 sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp SCHEMAS=HR<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">TABLES<\/mark>:<\/strong> Belirtilen tablolar\u0131n d\u0131\u015fa aktar\u0131lmas\u0131n\u0131 sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp TABLES=EMPLOYEES,DEPARTMENTS<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">TABLESPACES<\/mark>:<\/strong> Belirtilen tablespace\u2019lerin d\u0131\u015fa aktar\u0131lmas\u0131n\u0131 sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=exp.log TABLESPACES=users,system<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">TRANSPORTABLE<\/mark>:<\/strong> Ta\u015f\u0131nabilir tablespace modunda d\u0131\u015fa aktarma yapar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=exp.log TRANSPORTABLE=ALWAYS<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">TRANSPORT_TABLESPACES<\/mark>:<\/strong> Tablespace ta\u015f\u0131maya y\u00f6nelik bir d\u0131\u015fa aktarma i\u015flemi yapar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=exp.log TRANSPORT_TABLESPACES=users,hr<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">4.1.<strong>5. Performans ve Paralel \u00c7al\u0131\u015fma Parametreleri<\/strong><\/h4>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">CLUSTER<\/mark>:<\/strong> Oracle RAC kullanarak i\u015flemi h\u0131zland\u0131rmay\u0131 sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=exp.log CLUSTER=YES<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">PARALLEL<\/mark>:<\/strong> Export i\u015fleminin ka\u00e7 paralel i\u015flemci ile \u00e7al\u0131\u015faca\u011f\u0131n\u0131 belirler.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp user\/password directory=DATA_PUMP_DIR dumpfile=exp%U.dmp logfile=exp.log PARALLEL=4<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">PARALLEL_THRESHOLD<\/mark>:<\/strong> Paralel \u00e7al\u0131\u015fman\u0131n hangi tablo b\u00fcy\u00fckl\u00fc\u011f\u00fcne g\u00f6re ayarlanaca\u011f\u0131n\u0131 belirler.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=exp.log PARALLEL_THRESHOLD=100M<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">REUSE_DUMPFILES<\/mark>:<\/strong> Mevcut dump dosyalar\u0131n\u0131n \u00fczerine yaz\u0131lmas\u0131n\u0131 sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=exp.log REUSE_DUMPFILES=YES<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">SERVICE_NAME<\/mark>:<\/strong> RAC ortamlar\u0131nda kullan\u0131lacak servis ad\u0131n\u0131 belirtir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=exp.log SERVICE_NAME=my_rac_service<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">4.1.<strong>6. Flashback ve Zaman Tabanl\u0131 Se\u00e7enekler<\/strong><\/h4>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">FLASHBACK_SCN<\/mark>:<\/strong> Belirtilen SCN numaras\u0131na g\u00f6re ge\u00e7mi\u015fteki veriyi d\u0131\u015fa aktarmay\u0131 sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=exp.log FLASHBACK_SCN=12345678<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">FLASHBACK_TIME<\/mark>:<\/strong> Belirtilen zamana en yak\u0131n SCN kullan\u0131larak d\u0131\u015fa aktarma yapar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=exp.log FLASHBACK_TIME=SYSTIMESTAMP-INTERVAL '10' MINUTE<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">SOURCE_EDITION<\/mark>:<\/strong> Belirtilen veritaban\u0131 s\u00fcr\u00fcm\u00fcndeki verileri d\u0131\u015fa aktarmay\u0131 sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=exp.log SOURCE_EDITION=my_edition<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">TTS_CLOSURE_CHECK<\/mark>:<\/strong> Transportable tablespace i\u015flemleri i\u00e7in tutarl\u0131l\u0131k kontrol\u00fc yapar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=exp.log TRANSPORT_TABLESPACES=my_tbs TTS_CLOSURE_CHECK=FULL<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">VERSION<\/mark>:<\/strong> Export edilen verilerin hangi veritaban\u0131 s\u00fcr\u00fcm\u00fcne uygun olaca\u011f\u0131n\u0131 belirler.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=exp.log VERSION=12.2<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">4.1.<strong>7. Uzak Veritaban\u0131ndan Export<\/strong><\/h4>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">NETWORK_LINK<\/mark>:<\/strong> Uzak bir veritaban\u0131ndan do\u011frudan d\u0131\u015fa aktarma yapmay\u0131 sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>expdp system\/password DIRECTORY=dpump_dir DUMPFILE=mydump.dmp NETWORK_LINK=remote_db_link<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4.2 Import Parametreleri<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">4.2.<strong>1. \u0130\u015flem Ak\u0131\u015f\u0131 ve Kontrol Parametreleri<\/strong><\/h4>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ABORT_STEP<\/mark>:<\/strong> \u0130\u015flem ba\u015flat\u0131ld\u0131\u011f\u0131nda, i\u015flemin durdurulmas\u0131n\u0131 sa\u011flar ve verilerin i\u00e7eri aktar\u0131lmadan \u00f6nce Data Pump kontrol tablosunun sorgulanmas\u0131na olanak tan\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log ABORT_STEP=2<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ATTACH<\/mark>:<\/strong> Var olan bir import i\u015flemine ba\u011flan\u0131r ve etkile\u015fimli komut moduna ge\u00e7er.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password ATTACH=job_name<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">JOB_NAME<\/mark>:<\/strong> Import i\u015flemi i\u00e7in bir i\u015f ad\u0131 belirler.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log JOB_NAME=import_job_1<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">4.2.<strong>2. Veri \u0130\u015fleme ve Y\u00fckleme<\/strong><\/h4>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ACCESS_METHOD<\/mark>:<\/strong> Veri y\u00fckleme i\u00e7in kullan\u0131lacak y\u00f6ntemi belirtir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log ACCESS_METHOD=direct_path<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">CONTENT<\/mark>:<\/strong> Y\u00fckleme s\u0131ras\u0131nda hangi verilerin i\u00e7eri aktar\u0131laca\u011f\u0131n\u0131 filtreler.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log CONTENT=DATA_ONLY<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">DIRECTORY<\/mark>:<\/strong> Dump dosyas\u0131n\u0131n bulundu\u011fu klas\u00f6r\u00fc belirtir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password DIRECTORY=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">DUMPFILE<\/mark>:<\/strong> Export taraf\u0131ndan olu\u015fturulan dump dosyas\u0131n\u0131n ad\u0131n\u0131 belirtir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password DIRECTORY=DATA_PUMP_DIR DUMPFILE=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">PARALLEL<\/mark>:<\/strong> Paralel i\u015flem say\u0131s\u0131n\u0131 belirtir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log PARALLEL=4<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">NETWORK_LINK<\/mark>:<\/strong> Bir a\u011f ba\u011flant\u0131s\u0131 \u00fczerinden veri aktar\u0131m\u0131n\u0131 sa\u011flar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password NETWORK_LINK=remote_db directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">PARFILE<\/mark>:<\/strong> Parametre dosyas\u0131 kullanarak import i\u015flemini ba\u015flat\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password PARFILE=import.par<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">4.2.<strong>3. Zaman ve Flashback Se\u00e7enekleri<\/strong><\/h4>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">FLASHBACK_SCN<\/mark>:<\/strong> Belirtilen SCN&#8217;ye g\u00f6re ge\u00e7mi\u015fteki veriyi import eder.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password FLASHBACK_SCN=1234567890 directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">FLASHBACK_TIME<\/mark>:<\/strong> Belirtilen zamana en yak\u0131n SCN kullan\u0131larak veriyi i\u00e7eri aktar\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password FLASHBACK_TIME=\"TO_TIMESTAMP('2025-01-01 10:00:00', 'YYYY-MM-DD HH24:MI:SS')\" directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">4.2.<strong>4. \u015eema ve Tablolar<\/strong><\/h4>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">REMAP_SCHEMA<\/mark>:<\/strong> Tablolar\u0131 ba\u015fka bir \u015femaya ta\u015f\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password REMAP_SCHEMA=source_schema:target_schema directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">REMAP_TABLESPACE<\/mark>:<\/strong> Verilerin ta\u015f\u0131naca\u011f\u0131 hedef tablespace&#8217;i belirtir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password REMAP_TABLESPACE=source_ts:target_ts directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">SCHEMAS<\/mark>:<\/strong> \u015eema d\u00fczeyinde bir import i\u015flemi yapar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password SCHEMAS=hr,finance directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">4.2.<strong>5. Veri D\u00f6n\u00fc\u015f\u00fcm\u00fc ve Yeniden Adland\u0131rma<\/strong><\/h4>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">REMAP_TABLE<\/mark>:<\/strong> Tablo adlar\u0131n\u0131 yeniden adland\u0131r\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password REMAP_TABLE=old_table:new_table directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">REMAP_DATAFILE<\/mark>:<\/strong> Kaynak veri dosyas\u0131n\u0131 hedef veri dosyas\u0131na yeniden adland\u0131r\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password REMAP_DATAFILE='\/source_path\/datafile01.dbf'='\/target_path\/datafile01.dbf' directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">REMAP_DIRECTORY<\/mark>:<\/strong> Veritaban\u0131 aras\u0131nda ta\u015f\u0131nan dizin adlar\u0131n\u0131 yeniden adland\u0131r\u0131r.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password REMAP_DIRECTORY=source_dir:target_dir directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">4.2.<strong>6. Ekstra Se\u00e7enekler ve \u0130stisnalar<\/strong><\/h4>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">EXCLUDE<\/mark>:<\/strong> Import i\u015flemi s\u0131ras\u0131nda d\u0131\u015far\u0131da b\u0131rak\u0131lacak objeleri belirtir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password EXCLUDE=TABLE:\"IN ('table1', 'table2')\" directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">INCLUDE<\/mark>:<\/strong> Import i\u015flemi s\u0131ras\u0131nda dahil edilecek objeleri belirtir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password INCLUDE=TABLE:\"IN ('table1', 'table2')\" directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">SKIP_UNUSABLE_INDEXES<\/mark>:<\/strong> Ge\u00e7ersiz (unusable) indekslerin import i\u015flemi s\u0131ras\u0131nda atlan\u0131p atlanmayaca\u011f\u0131n\u0131 belirtir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password SKIP_UNUSABLE_INDEXES=Y directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">TABLE_EXISTS_ACTION<\/mark>:<\/strong> Var olan tablolar i\u00e7in i\u015flem yap\u0131lacak aksiyonu belirtir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password TABLE_EXISTS_ACTION=REPLACE directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">TRANSPORTABLE<\/mark>:<\/strong> Ta\u015f\u0131nabilir tablespace modunda import yapar.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password TRANSPORTABLE=ALWAYS directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">4.2.<strong>7. G\u00fcvenlik ve \u015eifreleme<\/strong><\/h4>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ENCRYPTION_PASSWORD<\/mark>:<\/strong> \u015eifreli kolon verilerini i\u00e7eri aktar\u0131rken kullan\u0131lacak \u015fifreyi belirtir.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password ENCRYPTION_PASSWORD=securepass directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-primary-color\">ENCRYPTION_PWD_PROMPT<\/mark>:<\/strong> ifre i\u00e7in kullan\u0131c\u0131dan etkile\u015fimli bir istem isteyip istemedi\u011fini belirtir<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>impdp user\/password ENCRYPTION_PWD_PROMPT=YES directory=DATA_PUMP_DIR dumpfile=exp.dmp logfile=imp.log<\/code><\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Oracle Data Pump, Oracle veritabanlar\u0131nda veri aktar\u0131m\u0131 i\u00e7in kullan\u0131lan y\u00fcksek performansl\u0131 bir ara\u00e7t\u0131r. expdp (export data pump) ve impdp (import data pump) komutlar\u0131yla veritaban\u0131 nesneleri h\u0131zl\u0131 ve verimli bir \u015fekilde d\u0131\u015fa ve i\u00e7e aktar\u0131labilir<\/p>\n","protected":false},"author":1,"featured_media":377,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43],"tags":[],"class_list":["post-374","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-genel-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Oracle Data Pump (expdp, impdp) - Kapsaml\u0131 Rehber<\/title>\n<meta name=\"description\" content=\"Oracle Data Pump, Oracle veritabanlar\u0131nda veri aktar\u0131m\u0131 i\u00e7in kullan\u0131lan y\u00fcksek performansl\u0131 bir ara\u00e7t\u0131r. expdp (export data pump) ve impdp (import data pump) komutlar\u0131yla veritaban\u0131 nesneleri h\u0131zl\u0131 ve verimli bir \u015fekilde d\u0131\u015fa ve i\u00e7e aktar\u0131labilir\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/oraclius.com.tr\/tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Data Pump (expdp, impdp) - Kapsaml\u0131 Rehber\" \/>\n<meta property=\"og:description\" content=\"Oracle Data Pump, Oracle veritabanlar\u0131nda veri aktar\u0131m\u0131 i\u00e7in kullan\u0131lan y\u00fcksek performansl\u0131 bir ara\u00e7t\u0131r. expdp (export data pump) ve impdp (import data pump) komutlar\u0131yla veritaban\u0131 nesneleri h\u0131zl\u0131 ve verimli bir \u015fekilde d\u0131\u015fa ve i\u00e7e aktar\u0131labilir\" \/>\n<meta property=\"og:url\" content=\"https:\/\/oraclius.com.tr\/tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/\" \/>\n<meta property=\"og:site_name\" content=\"oraclius\" \/>\n<meta property=\"article:published_time\" content=\"2025-02-03T17:42:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-05T18:47:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2025\/02\/resm-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"640\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"YUNUS EMRE ATAY\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"YUNUS EMRE ATAY\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-pump-expdp-impdp-kapsamli-rehber\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-pump-expdp-impdp-kapsamli-rehber\\\/\"},\"author\":{\"name\":\"YUNUS EMRE ATAY\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#\\\/schema\\\/person\\\/15e2f7b9dc977c71806301e629135e09\"},\"headline\":\"Oracle Data Pump (expdp, impdp) &#8211; Kapsaml\u0131 Rehber\",\"datePublished\":\"2025-02-03T17:42:54+00:00\",\"dateModified\":\"2025-04-05T18:47:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-pump-expdp-impdp-kapsamli-rehber\\\/\"},\"wordCount\":1724,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#\\\/schema\\\/person\\\/15e2f7b9dc977c71806301e629135e09\"},\"image\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-pump-expdp-impdp-kapsamli-rehber\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/resm-1.png\",\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-pump-expdp-impdp-kapsamli-rehber\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-pump-expdp-impdp-kapsamli-rehber\\\/\",\"url\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-pump-expdp-impdp-kapsamli-rehber\\\/\",\"name\":\"Oracle Data Pump (expdp, impdp) - Kapsaml\u0131 Rehber\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-pump-expdp-impdp-kapsamli-rehber\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-pump-expdp-impdp-kapsamli-rehber\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/resm-1.png\",\"datePublished\":\"2025-02-03T17:42:54+00:00\",\"dateModified\":\"2025-04-05T18:47:29+00:00\",\"description\":\"Oracle Data Pump, Oracle veritabanlar\u0131nda veri aktar\u0131m\u0131 i\u00e7in kullan\u0131lan y\u00fcksek performansl\u0131 bir ara\u00e7t\u0131r. expdp (export data pump) ve impdp (import data pump) komutlar\u0131yla veritaban\u0131 nesneleri h\u0131zl\u0131 ve verimli bir \u015fekilde d\u0131\u015fa ve i\u00e7e aktar\u0131labilir\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-pump-expdp-impdp-kapsamli-rehber\\\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-pump-expdp-impdp-kapsamli-rehber\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-pump-expdp-impdp-kapsamli-rehber\\\/#primaryimage\",\"url\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/resm-1.png\",\"contentUrl\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2025\\\/02\\\/resm-1.png\",\"width\":640,\"height\":640,\"caption\":\"datapump\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/oracle-data-pump-expdp-impdp-kapsamli-rehber\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\\\/\\\/oraclius.com.tr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Data Pump (expdp, impdp) &#8211; Kapsaml\u0131 Rehber\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#website\",\"url\":\"https:\\\/\\\/oraclius.com.tr\\\/\",\"name\":\"oraclius\",\"description\":\"Linux, SQL, Oracle rehberleri ve daha fazlas\u0131 i\u00e7in oraclius.com.tr\u2019yi ziyaret edin.\",\"publisher\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#\\\/schema\\\/person\\\/15e2f7b9dc977c71806301e629135e09\"},\"alternateName\":\"oracle\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/oraclius.com.tr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#\\\/schema\\\/person\\\/15e2f7b9dc977c71806301e629135e09\",\"name\":\"YUNUS EMRE ATAY\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/oradb.jpeg\",\"url\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/oradb.jpeg\",\"contentUrl\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/oradb.jpeg\",\"width\":512,\"height\":512,\"caption\":\"YUNUS EMRE ATAY\"},\"logo\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/oradb.jpeg\"},\"description\":\"oracle\",\"sameAs\":[\"https:\\\/\\\/oraclius.com.tr\",\"https:\\\/\\\/instagram.com\\\/lemratal\",\"https:\\\/\\\/linkedin.com\\\/in\\\/emreatayy\",\"https:\\\/\\\/www.youtube.com\\\/@lemratal\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Data Pump (expdp, impdp) - Kapsaml\u0131 Rehber","description":"Oracle Data Pump, Oracle veritabanlar\u0131nda veri aktar\u0131m\u0131 i\u00e7in kullan\u0131lan y\u00fcksek performansl\u0131 bir ara\u00e7t\u0131r. expdp (export data pump) ve impdp (import data pump) komutlar\u0131yla veritaban\u0131 nesneleri h\u0131zl\u0131 ve verimli bir \u015fekilde d\u0131\u015fa ve i\u00e7e aktar\u0131labilir","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/oraclius.com.tr\/tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/","og_locale":"tr_TR","og_type":"article","og_title":"Oracle Data Pump (expdp, impdp) - Kapsaml\u0131 Rehber","og_description":"Oracle Data Pump, Oracle veritabanlar\u0131nda veri aktar\u0131m\u0131 i\u00e7in kullan\u0131lan y\u00fcksek performansl\u0131 bir ara\u00e7t\u0131r. expdp (export data pump) ve impdp (import data pump) komutlar\u0131yla veritaban\u0131 nesneleri h\u0131zl\u0131 ve verimli bir \u015fekilde d\u0131\u015fa ve i\u00e7e aktar\u0131labilir","og_url":"https:\/\/oraclius.com.tr\/tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/","og_site_name":"oraclius","article_published_time":"2025-02-03T17:42:54+00:00","article_modified_time":"2025-04-05T18:47:29+00:00","og_image":[{"width":640,"height":640,"url":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2025\/02\/resm-1.png","type":"image\/png"}],"author":"YUNUS EMRE ATAY","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"YUNUS EMRE ATAY","Tahmini okuma s\u00fcresi":"8 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/oraclius.com.tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/#article","isPartOf":{"@id":"https:\/\/oraclius.com.tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/"},"author":{"name":"YUNUS EMRE ATAY","@id":"https:\/\/oraclius.com.tr\/#\/schema\/person\/15e2f7b9dc977c71806301e629135e09"},"headline":"Oracle Data Pump (expdp, impdp) &#8211; Kapsaml\u0131 Rehber","datePublished":"2025-02-03T17:42:54+00:00","dateModified":"2025-04-05T18:47:29+00:00","mainEntityOfPage":{"@id":"https:\/\/oraclius.com.tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/"},"wordCount":1724,"commentCount":0,"publisher":{"@id":"https:\/\/oraclius.com.tr\/#\/schema\/person\/15e2f7b9dc977c71806301e629135e09"},"image":{"@id":"https:\/\/oraclius.com.tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/#primaryimage"},"thumbnailUrl":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2025\/02\/resm-1.png","inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/oraclius.com.tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/oraclius.com.tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/","url":"https:\/\/oraclius.com.tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/","name":"Oracle Data Pump (expdp, impdp) - Kapsaml\u0131 Rehber","isPartOf":{"@id":"https:\/\/oraclius.com.tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/oraclius.com.tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/#primaryimage"},"image":{"@id":"https:\/\/oraclius.com.tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/#primaryimage"},"thumbnailUrl":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2025\/02\/resm-1.png","datePublished":"2025-02-03T17:42:54+00:00","dateModified":"2025-04-05T18:47:29+00:00","description":"Oracle Data Pump, Oracle veritabanlar\u0131nda veri aktar\u0131m\u0131 i\u00e7in kullan\u0131lan y\u00fcksek performansl\u0131 bir ara\u00e7t\u0131r. expdp (export data pump) ve impdp (import data pump) komutlar\u0131yla veritaban\u0131 nesneleri h\u0131zl\u0131 ve verimli bir \u015fekilde d\u0131\u015fa ve i\u00e7e aktar\u0131labilir","breadcrumb":{"@id":"https:\/\/oraclius.com.tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/oraclius.com.tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/oraclius.com.tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/#primaryimage","url":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2025\/02\/resm-1.png","contentUrl":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2025\/02\/resm-1.png","width":640,"height":640,"caption":"datapump"},{"@type":"BreadcrumbList","@id":"https:\/\/oraclius.com.tr\/oracle-data-pump-expdp-impdp-kapsamli-rehber\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/oraclius.com.tr\/"},{"@type":"ListItem","position":2,"name":"Oracle Data Pump (expdp, impdp) &#8211; Kapsaml\u0131 Rehber"}]},{"@type":"WebSite","@id":"https:\/\/oraclius.com.tr\/#website","url":"https:\/\/oraclius.com.tr\/","name":"oraclius","description":"Linux, SQL, Oracle rehberleri ve daha fazlas\u0131 i\u00e7in oraclius.com.tr\u2019yi ziyaret edin.","publisher":{"@id":"https:\/\/oraclius.com.tr\/#\/schema\/person\/15e2f7b9dc977c71806301e629135e09"},"alternateName":"oracle","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/oraclius.com.tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/oraclius.com.tr\/#\/schema\/person\/15e2f7b9dc977c71806301e629135e09","name":"YUNUS EMRE ATAY","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg","url":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg","contentUrl":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg","width":512,"height":512,"caption":"YUNUS EMRE ATAY"},"logo":{"@id":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg"},"description":"oracle","sameAs":["https:\/\/oraclius.com.tr","https:\/\/instagram.com\/lemratal","https:\/\/linkedin.com\/in\/emreatayy","https:\/\/www.youtube.com\/@lemratal"]}]}},"_links":{"self":[{"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/posts\/374","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/comments?post=374"}],"version-history":[{"count":6,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/posts\/374\/revisions"}],"predecessor-version":[{"id":587,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/posts\/374\/revisions\/587"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/media\/377"}],"wp:attachment":[{"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/media?parent=374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/categories?post=374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/tags?post=374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}