我使用expdp/impdp进行数据库导入导出时出现了下面的问题:
--------------------------------------------------------------------------------
ORA-39082: Object type TRIGGER:"MMM"."TI_DI_TP_DEF" created with compilation warnings
ORA-39082: Object type TRIGGER:"MMM"."TU_AI_DEFINE" created with compilation warnings
--------------------------------------------------------------------------------
检查trigger的script:
(1) “:NEW”变成了“:EW?”
(2) “sql_str”变成了“sql_sr”SP:使用exp/imp就没问题。我查了很多网页,发现有人提到这个问题在metalink有bug记录,ID可能是:460267.1请问那问大侠知道这个问题怎么解决,或者有metalink账号帮我看一下解决方法。即使没有解决方法,能告诉我这个bug有没有patch,到哪一个版本能fix,也非常感谢!
--------------------------------------------------------------------------------
ORA-39082: Object type TRIGGER:"MMM"."TI_DI_TP_DEF" created with compilation warnings
ORA-39082: Object type TRIGGER:"MMM"."TU_AI_DEFINE" created with compilation warnings
--------------------------------------------------------------------------------
检查trigger的script:
(1) “:NEW”变成了“:EW?”
(2) “sql_str”变成了“sql_sr”SP:使用exp/imp就没问题。我查了很多网页,发现有人提到这个问题在metalink有bug记录,ID可能是:460267.1请问那问大侠知道这个问题怎么解决,或者有metalink账号帮我看一下解决方法。即使没有解决方法,能告诉我这个bug有没有patch,到哪一个版本能fix,也非常感谢!
解决方案 »
- Oracle存储过程问题
- Oracle如何进行资源管理,实现对Vip用户和普通用户的
- 我在使用外连接查询三个表时,结果集中有个字段有空值,vb使用ADO读取结果时,无法得到结果集
- sql查询转置
- 在oracle存储过程中使用alter命令的问题!
- oracle 的实例,我实在理解不了,谁能给我说明一下,谢谢!!
- 存储过程的变量问题
- 请问这条奇怪的语句是什么意思????
- penitent(只取一瓢) 瓢兄请进来,关于ORA-125000:TNS:监听程序无法启动专用服务器进程的问题?
- 谁能告诉我 oracle下面的 这个日志太过大怎么处理啊?
- 一个简单的数据插入问题
- 如何查找字段长度在某个范围内的所有记录?求高手!
Modified 08-APR-2009 Type PROBLEM Status PUBLISHED In this Document
Symptoms
Cause
Solution
References--------------------------------------------------------------------------------Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3
This problem can occur on any platform.Symptoms
You created a wrapped procedure/function in source database (important: the database uses a multibyte character set, like UTF8 or similar). Then you started DataPump export utility to export the schema containing the wrapped PL/SQL code and imported the dump either into a target database with multibyte caharacter set, or, into same source database in a new schema.Impdp returns the following messages:
Import: Release 10.2.0.3.0 - Production on Wednesday, 26 September, 2007 13:49:05 Copyright (c) 2003, 2005, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining Scoring Engine options
Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/******** directory=dpu dumpfile=usr001_1.dmp remap_schema=usr001:usr002
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
ORA-39082: Object type ALTER_PROCEDURE:"USR002"."PROC001" created with compilation warnings
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 13:49:09 Cause
Bug 5581731 WRAPPED PACKAGES WITH TRAILING BLANK LINES AND A / VS UNICODE D/B GIVES PLS-103, fixed with Oracle version 10.2.0.4.
Solution
1. Use original exp/imp utilities, or:2. Request a backport for bug 5581731 for your Oracle version and affected platformReferences
BUG:5581731 - WRAPPED PACKAGES WITH TRAILING BLANK LINES AND A / VS UNICODE D/B GIVES PLS-103
BUG:5855882 - ENCOUNTER COMPILE ERROR WHEN IMPDP THE WRAPPED PROCEDURE/FUNCTION--------------------------------------------------------------------------------
Related--------------------------------------------------------------------------------
Products
--------------------------------------------------------------------------------•Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
Errors
--------------------------------------------------------------------------------
PLS-103; ORA-39082
“Bug 5581731 WRAPPED PACKAGES WITH TRAILING BLANK LINES AND A / VS UNICODE D/B GIVES PLS-103, fixed with Oracle version 10.2.0.4.”
想麻烦您在metalink上帮我问问,为什么在10.2.0.4上仍然会出现ORA-39082。谢谢您!