Skip to main content
Home
Dave's Software and Hardware Projects

Search form

  • home
  • blog
  • notebooks
  • software projects
  • hardware projects
  • recent
  • presentations
  • about
  • !

optimizations

impdp too smart for its own good - ORA-2000 and missing indexes on target...

Submitted by dave on Mon, 05/18/2020 - 12:50

As we move on to 12.2 and 19c we're seeing more instances where simple schema export/import migrations are missing objects on the target database.

If you do object counts after a simple schema migration... Or see something like this pop up in your impdp logs:

Tags: 
impdp
import
optimizations
  • Read more about impdp too smart for its own good - ORA-2000 and missing indexes on target...
  • dave's blog
  • 2 comments
  • Add new comment
Subscribe to optimizations

Popular Content

Today's:

  • Enabling/Disabling/Deleting a SQL Profile
  • Pointing a private database link at another database without knowing the password...sorta...
  • Archived Log Switch Heat Map for SQL Developer...
  • The dreaded ORA-29024: Certificate validation failure... how to approach...
  • Using Proxy Connections with SQL Developer or SQLPLUS
  • impdp too smart for its own good - ORA-2000 and missing indexes on target...
  • Questioning Traditional Data Management

Management

  • Comment Approval
  • Top Referrers

User Login

  • Request new password
CAPTCHA
Are you a humanoid?

Content Copyright 2006-2022. Links are copyright of respective owners.