Oracle DBA & All IT » ORA-Error » SYS.LT_EXPORT_PKG Warning When Export User Or Full Database
SYS.LT_EXPORT_PKG Warning When Export User Or Full Database
Error เกิดขึ้นเวลาที่ export full=y ที่ oracle9i วิธีแก้มีดังด้านล่างนี้ค่ะ ลองดูนะคะถ้าใครเจอ error นี้เหมือนกัน
Error Message in Log file
fact: Oracle Server – Enterprise Edition 9.0.1
symptom: Exporting pre-schema procedural objects and actions
symptom: EXP-00008: ORACLE error 6550 encountered
symptom: ORA-06550: line %, column %:
symptom: PLS-00201: identifier 'SYS.LT_EXPORT_PKG' must be declared
symptom: EXP-00083: The previous problem occurred when calling
SYS.LT_EXPORT_PKG.schema_info_exp
Cause:
Bug 1828996 SYS.LT_EXPORT_PKG WARNING WHEN EXPORT USER HAS JUST EXP_FULL_DATABASE ROLE
Export while exporting system procedural objects and actions expects the
'execute' privilege on those objects.
Script which installs LT_* packages should have the grants which is currently
missing.
Solution:
Connect โดย sys และ grant privileges แล้วรัน export อีกครั้ง:
GRANT EXECUTE ON sys.lt_export_pkg TO exp_full_database;
OR
GRANT EXECUTE ON sys.lt_export_pkg TO PUBLIC;
.. Preview : 8102
Related Search:
- SYS LT_EXPORT_PKG
- ora-06550
Filed under: ORA-Error · Tags: BUG:1828996, EXP-00008, EXP-00083, ORA-06550, PLS-00201
-
iphone5reviewed.com
-
car repo
-
penis enlargement exercises
-
iphone 5 release date