I'm having two oracle databases. one is oracle 10G and another one is oracle 11G. Now I have to migrate database from 10g to 11g. I was tried with Oracle SQL developer tool's Database copy option, It was worked fine, But, the migrated triggers, procedures and indexes are in invalid status. what I have to do valid this ? or Is there any alternatives to sql developer tool ?


More...