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 ?
asked Dec 21, 2012 at 9:00
dhileepan Mdhileepan M
-
1have you tried exp/imp ?Satya– Satya2012年12月21日 09:02:53 +00:00Commented Dec 21, 2012 at 9:02
-
@Satya Now I'm doing Database export option in SQL developer. Is it useful ?dhileepan M– dhileepan M2012年12月21日 09:18:58 +00:00Commented Dec 21, 2012 at 9:18
-
this is, however, as h4b0 has pointed out use Data PumpSatya– Satya2012年12月21日 09:22:52 +00:00Commented Dec 21, 2012 at 9:22
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.
answered Dec 21, 2012 at 9:05
-
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– andba772016年06月22日 14:22:04 +00:00Commented Jun 22, 2016 at 14:22
lang-sql