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 ?

  • 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

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.

  • I would like to add that the author should specify "CONTENT=METADATA_ONLY" in the datapump export, because they specified that they don't need the table data, just the structure. – andba77 Jun 22 '16 at 14:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy