Доброго времени суток.
Решил сделать Exp/Imp БД
Все как положено, все по инструкции.
Экспорт прошел нормально, импорт вроде без ошибок (не уверен изучаю лог). Гранды раздал, но при перекомпиляции процедур вылазят 35 ошибок.
Код:
OBJECTS WITH ERRORS
-------------------
35
DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#
ERRORS DURING RECOMPILATION
---------------------------
0 вот результат запроса по части инвалидов.
Код:
OWNER||'.'||OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
SUPERMAG.ACCOUNTS
PACKAGE BODY INVALID
SUPERMAG.ACCOUNTS
PACKAGE INVALID
SUPERMAG.FIXREM_PRECALC
PACKAGE BODY INVALID
OWNER||'.'||OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
SUPERMAG.FVMAPREP
VIEW INVALID
SUPERMAG.FVMAPREPOPEN
VIEW INVALID
SUPERMAG.FVMAPREPOPENWITHBR
VIEW INVALID
OWNER||'.'||OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
SUPERMAG.FVMAPREPWITHBR
VIEW INVALID
SUPERMAG.LASTINC
PACKAGE BODY INVALID
SUPERMAG.SMEXPORTACCOUNTS
PROCEDURE INVALID
OWNER||'.'||OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
SUPERMAG.SMEXPORTCARDCLASS
PROCEDURE INVALID
SUPERMAG.SMEXPORTCARDPROPERTIES
PROCEDURE INVALID
SUPERMAG.SMEXPORTCARDS
PROCEDURE INVALID
OWNER||'.'||OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
SUPERMAG.SMEXPORTCARDTAXES
PROCEDURE INVALID
SUPERMAG.SMEXPORTCASHCHECKS
PROCEDURE INVALID
SUPERMAG.SMEXPORTCASHCHECKSCREDCARD
PROCEDURE INVALID
OWNER||'.'||OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
SUPERMAG.SMEXPORTCASHCHECKSDISCCARD
PROCEDURE INVALID
SUPERMAG.SMEXPORTCASHIERS
PROCEDURE INVALID
SUPERMAG.SMEXPORTCLICLASS
PROCEDURE INVALID
OWNER||'.'||OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
SUPERMAG.SMEXPORTCLIENTS
PROCEDURE INVALID
SUPERMAG.SMEXPORTCLIENTSOLAP
PROCEDURE INVALID
SUPERMAG.SMEXPORTCREDCARDTYPES
PROCEDURE INVALID
OWNER||'.'||OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
SUPERMAG.SMEXPORTDOCSCREDCARDOLAP
PROCEDURE INVALID
SUPERMAG.SMEXPORTDOCSOLAP
PROCEDURE INVALID
SUPERMAG.SMEXPORTFINISH
PROCEDURE INVALID
OWNER||'.'||OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
SUPERMAG.SMEXPORTOPER
PROCEDURE INVALID
SUPERMAG.SMEXPORTOPEROLAP
PROCEDURE INVALID
SUPERMAG.SMEXPORTPRODACCOUNTS
PROCEDURE INVALID
OWNER||'.'||OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
SUPERMAG.SMEXPORTSHOPCLASS
PROCEDURE INVALID
SUPERMAG.SMEXPORTSHOPS
PROCEDURE INVALID
SUPERMAG.SMEXPORTSTART
PROCEDURE INVALID
OWNER||'.'||OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
SUPERMAG.SMEXPORTSTOREUNITS
PROCEDURE INVALID
SUPERMAG.SMEXPORTSUPCLASS
PROCEDURE INVALID
SUPERMAG.SMEXPORTTAXGRP
PROCEDURE INVALID
OWNER||'.'||OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE STATUS
------------------- -------
SUPERMAG.SVAREALCOSTPRICE
VIEW INVALID
SUPERMAG.SVAREALCOSTPRICEOPENEDPERIOD
VIEW INVALID
35 rows selected.
Пытаюсь скомпилировать ручками не выходит.
Код:
SQL> ALTER PACKAGE SUPERMAG.ACCOUNTS COMPILE BODY;
Warning: Package Body altered with compilation errors.
Подскажите что еще можно попробовать?