impdp匯入使用者sechema ORA-39082

來源:互聯網
上載者:User

impdp導資料,出現ORA-39082 ORA-39083錯誤號碼,對象無法編譯匯入結束後可以通過編譯對象來嘗試: alter view view_name compile;如果報錯:使用show errors定位問題所在源,是許可權的問題還是dblink的問題;如果是許可權問題,說明之前建立使用者時沒有給足夠的使用者權限(主要是對一些表的讀許可權)    主要查詢以下兩個視圖:dba_sys_privs,dba_role_privs如果是dblink問題,建議使用 dbms_metadata.get_ddl查看dblink定義ddl,並嘗試重建db_link
接著繼續編譯對象。
查看對象定義ddl:select dbms_metadata.get_ddl('OBJECT_TYPE','OBJECT_NAME','USERNAME') from dual;
編譯無效對象:view:    alter view view_name compile;function:    alter function function_name compile;
sys使用者查看無效對象:select owner,object_name,object_type,statusfrom dba_objectswhere status !='VALID'and owner not in ('SYS','SYSTEM')/
show error 的用法:編譯view出現問題: alter view view_name compile;Warning:view view_name with compilation errors.
SQL>show errors view view_nameErrors for view view_name:
LINE/COL    ERROR-----------    -------------------------0/0               ORA---


相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.