# Oracle Import алдаа

**URL:** <https://www.batmunkh.net/t/oracle-import/946>\
**Category:** Oracle Database\
**Created:** [November 5, 2018, 10:18am UTC](https://www.batmunkh.net/t/oracle-import/946 "2018-11-05T10:18:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Enkhtur\_Batbayar1](https://www.batmunkh.net/user_avatar/www.batmunkh.net/enkhtur_batbayar1/32/490_2.png) [@Enkhtur\_Batbayar1](https://www.batmunkh.net/u/Enkhtur_Batbayar1)\
**Post date:** [November 5, 2018, 10:18am UTC](https://www.batmunkh.net/t/oracle-import/946/1 "2018-11-05T10:18:48Z")

</div>

Сайн байна уу Oracle RAC export хийсэн DUMP Import хийхэд дараахь алдаа өгч байна. Энэ ямар алдаа вэ.  
Import: Release 12.1.0.2.0 - Production on Mon Nov 5 18:03:15 2018

Copyright © 1982, 2014, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production  
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options  
ORA-39002: invalid operation  
ORA-39059: dump file set is incomplete  
ORA-39246: cannot locate master table within provided dump files  
нилээн үзлээ. Мэддэг хүн байвал зөвөлгөө өгөөрэй

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [November 5, 2018, 12:28pm UTC](https://www.batmunkh.net/t/oracle-import/946/2 "2018-11-05T12:28:06Z")

</div>

Алдааны мэдэллийг харахад файл дутуу гээд байгаа юм уу даа… dump 100% уу?

```
[oracle@decoder ~]$ oerr ora 39002
39002, 00000, "invalid operation"
// *Cause: The current API cannot be executed because of inconsistencies
// between the API and the current definition of the job.
// Subsequent messages supplied by DBMS_DATAPUMP.GET_STATUS
// will further describe the error.
// *Action: Modify the API call to be consistent with the current job or
// redefine the job in a manner that will support the specified API.
[oracle@decoder ~]$
[oracle@decoder ~]$
[oracle@decoder ~]$ oerr ora 39059
39059, 00000, "dump file set is incomplete"
// *Cause: An IMPORT or SQL_FILE operation was being performed but not
// all of the files from the EXPORT dump file set were included.
// *Action: Check the export log file and make sure all of the files that
// were exported are included in the current job.
[oracle@decoder ~]$

```

export log файл аа сайн харах хэрэгтэй гэсэн байна.

---

<div class="post-metadata">

**Author:** ![nyamaa](https://www.batmunkh.net/letter_avatar_proxy/v4/letter/n/c6cbf5/32.png) [@nyamaa](https://www.batmunkh.net/u/nyamaa)\
**Post date:** [November 7, 2018, 8:43am UTC](https://www.batmunkh.net/t/oracle-import/946/3 "2018-11-07T08:43:51Z")

</div>

Directory замаа шалгаарай.
