Ora - 39002, 39070, 39087

PROBLEM:
During datapump import of tables from a schema, so get error code
ora - 39002, 39070, 39087
RESOLUTION:
On destination server, create a Directory, and then grant privilege to the user that you are using to import the data.
SQL> CREATE OR REPLACE DIRECTORY DATA_PUMP_DIR as '/u01/backup/export';
SQL> GRANT read, write ON DIRECTORY DATA_PUMP_DIR TO public;
To export the data, use the following command:
expdp username/password@connectstring
DUMPFILE=abc.dmp LOGFILE=abc.log parfile=/u01/backup/export/exp-query.par
Or in case of import:impdp username/password@connectstring
DUMPFILE=abc.dmp LOGFILE=abc.log parfile=/u01/backup/export/exp-query.par
Where,DUMPFILE is destination dump files (example: expdat.dmp). Please don't specify the full path directory because expdat.dmp should be located under the DATA_PUMP_DIR (which is /u01/backup/export in our example). LOGFILE is Log file name (example: export.log).
Also, log file will be found on DATA_PUMP_DIR (which is /u01/backup/export in our example). PARFILE is the parameter file name (you can specify the full path for this file). Actually, you can specify parameters such as schema, query, parallel, exclude &etc. below is a parameter file sample:
DIRECTORY=DATA_PUMP_DIRDUMPFILE=trdnprd-dump-exp.dmp
LOGFILE=tnngt-test.log
SCHEMAS=tradesuper
QUERY=Schema_Owner.Table_Name:"WHERE 1=2"
exclude=statistics
parallel=2
REMAP_SCHEMA=owner1:owner2

Hiç yorum yok:

2018 SGK İşten Çıkış Kodları (696 sayılı KHK kapsamında eklenenler dahil)

2018 SGK İşten Çıkış Kodları 1- Deneme süreli iş sözleşmesinin işverence feshi 2- Deneme süreli iş sözleşmesinin işçi tarafından feshi ...