|
-
Try to run export from your production database with following parameters
FULL=Y
ROWS=N
INDEXES=Y
This export will export all database objects' structure but no data.
Then run import with
FULL=Y
IGNORE=Y
Import will create all database objects and will ignore errors on objects that already exist. So, at the end you'll get all your missing indexes.
Hope that helps.
Regards.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|