copying indexes from production to test
Hi ,
I want to copy the missing indexes on a table from production database to non-production database.
The table in the non-production database has some indexes missing as compared to the production database.. What is the best method to do this.? Is it better to take the sructure of the index using the below method and create it in the target database?
select dbms_metadata.get_ddl('INDEX','INDEX_NAME','UAT_OWNER') from dual;
Database version:9.2.0.6
OS:Linux