Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I need to do migrate or copy the oracle 10g database from sun solaris to another sun solaris server (oracle 11g). I was tried with SQL Developer tool. But It is not able copy all the objects in the particular schema. By the same time I should copy objects only, Don't need for data. Is there any procedure or scripts to copy the database or else any Oracle tool ?

share|improve this question

migrated from stackoverflow.com Dec 21 '12 at 12:57

This question came from our site for professional and enthusiast programmers.

1  
have you tried exp/imp ? –  Satya Dec 21 '12 at 9:02
    
@Satya Now I'm doing Database export option in SQL developer. Is it useful ? –  dhileepan M Dec 21 '12 at 9:18
    
this is, however, as h4b0 has pointed out use Data Pump –  Satya Dec 21 '12 at 9:22
add comment

1 Answer 1

The best way to achieve what you want is to do full export/import using data pump technology.

After successful import, you will probably have to recompile invalid objects.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.