Ora-39112:dependent Object Type Comment skipped

Ora-39112:dependent Object Type Comment skipp ed
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 number of Ora-39112:dependent object type comment skipped this error.

Online check, leading to the situation of this problem roughly a few cases,

1, in the original test library, the target schema and other users authorize each other, but the DMP you exported does not contain all the users, the corresponding user did not create the import.
2, then, the table space problem, the user of the test library under the index of a table is not in his default table space, so you have to the target side (here is the production environment), create a corresponding table space,
This means that if you give B the permissions of a user's table under a test library, you will be able to detect user B in the production library when you pour a user's data pump into the production library. Do the same thing.

It is really such a situation to think carefully.

Solution:
When you use the IMPDP tool to complete data import, the data is imported according to the stored parameter information in the dump file. In many cases we want to complete the import of the data according to the default parameters of the user being imported.
At this point we can use the IMPDP transform parameter to help complete

IMPDP system/oracle directory=mydump dumpfile=newllmj.dmp remap_tablespace=llmj_db:gold_mj_tab remap_schema= NEWLLMJ:GOLD_MJ schemas=newllmj table_exists_action=replace transform=segment_attributes:n

Remap_tablespace=llmj_db:gold_mj_tab the original tablespace: New table Space
The original schema of REMAP_SCHEMA=NEWLLMJ:GOLD_MJ: the present schema
Transform=segment_attributes:n The table space and the storage clause are removed, the REMAP_TABLESAPCE parameter is invalidated and the default table space is poured into the user.

The import statement is changed to the above, and then execution succeeds and no error is made.

Alibaba Cloud Hot Products
Elastic Compute Service (ECS)	Dedicated Host (DDH)	ApsaraDB RDS for MySQL (RDS)	ApsaraDB for PolarDB(PolarDB)	AnalyticDB for PostgreSQL (ADB for PG)
AnalyticDB for MySQL(ADB for MySQL)	Data Transmission Service (DTS)	Server Load Balancer (SLB)	Global Accelerator (GA)	Cloud Enterprise Network (CEN)
Object Storage Service (OSS)	Content Delivery Network (CDN)	Short Message Service (SMS)	Container Service for Kubernetes (ACK)	Data Lake Analytics (DLA)
ApsaraDB for Redis (Redis)	ApsaraDB for MongoDB (MongoDB)	NAT Gateway	VPN Gateway	Cloud Firewall
Anti-DDoS	Web Application Firewall (WAF)	Log Service	DataWorks	MaxCompute
Elastic MapReduce (EMR)	Elasticsearch