ORA-39112错误是Oracle数据库在使用Data Pump(Data Pump Import, impdp)工具进行数据导入时遇到的一个错误。这个错误表明在尝试创建或导入一个依赖对象时,其基础对象(base object)的创建或导入失败了。因此,依赖对象被跳过,没有被成功导入。 2. 指出“dependent object type object_grant:'orddata' skipped”这一部...
ORA-39112: dependent object type comment skipped 今天要把测试库schema用expdp倒进生产数据库中,本来非常简单的几个步骤,遇到了大量的 ora-39112: dependent object type comment skipped 这个错误。 网上查了查,导致这个问题的情况大致有一下几个情况, 1,在原来测试库中,目标schema和别的用户相互授权了,可是你导...
Ora-39112:dependent Object Type Comment skipped Original article: http://blog.itpub.net/29654823/viewspace-1779828/ Today, the test library schema will be inverted into the production database with EXPDP, a very simple few steps, encountered a large
ORA-39112: Dependent object type OBJECT_GRANT:"<schema>" skipped, base object type VIEW:"<owner>"."<view_name>" creation failedCauseSign In To view full details, sign in with your My Oracle Support account. Register Don't have a My Oracle Support account? Click to get started!
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded *** Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is: /tmp/seiang_wjq/scott_meta.dmp Job ...
ORA-39112: dependent object type comment skipped 今天要把测试库schema用expdp倒进生产数据库中,本来非常简单的几个步骤,遇到了大量的ora-39112: dependent object type comment skipped 这个错误。网上查了查,导致这个问题的情况大致有一下几个情况,1,在原来测试库中,目标schema和别的用户相 ...
Failing sql is:Processing object type DATABASE_EXPORT/SCHEMA/VIEW?GRANTOWNER_GRANT/OBJECT_GRANTORA-39112: Dependent object type OBJECT_GRANT:"<Schema Name>" skipped, base object type VIEW:"<Schema Name>"."<View Name>" could not be createdChanges...