Home » RDBMS Server » Backup & Recovery » Missed Proc and Package from Oracle 11G r2 to Oracle 12C r2 (Oracle 11G r2, Oracle 12C r2)
Missed Proc and Package from Oracle 11G r2 to Oracle 12C r2 [message #670768] Wed, 25 July 2018 02:44 Go to next message
swat1232
Messages: 1
Registered: July 2018
Junior Member
Dear Pro,

I meet an issue when was tried to move the database from Oracle 11G r2 to Oracle 12C r2, detail:
- Source: Oracle 11G r2, AIX
- Target: Oralce 12C r2, Redhat 7
I using the incremental backup method step by step.
But just the table was moved from 11 to 12. Proc, Packages,... is not move..
Please help me!

Thank Pro!
Re: Missed Proc and Package from Oracle 11G r2 to Oracle 12C r2 [message #670773 is a reply to message #670768] Wed, 25 July 2018 02:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I using the incremental backup method step by step.
Post link about that.
Copy and paste what you do and get.
Before, Please read How to use [code] tags and make your code easier to read.

Re: Missed Proc and Package from Oracle 11G r2 to Oracle 12C r2 [message #671156 is a reply to message #670768] Thu, 16 August 2018 09:23 Go to previous message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
swat1232 wrote on Wed, 25 July 2018 08:44
Dear Pro,

I meet an issue when was tried to move the database from Oracle 11G r2 to Oracle 12C r2, detail:
- Source: Oracle 11G r2, AIX
- Target: Oralce 12C r2, Redhat 7
I using the incremental backup method step by step.
But just the table was moved from 11 to 12. Proc, Packages,... is not move..
Please help me!

Thank Pro!

If you are doing what I think you are attempting, they wouldn't.

I guess you are migrating across endians using the new feature of incremental backups to reduce downtime? That being the case, you're dealing with what amounts to fancy transportable tablespaces - and all the limitations which come with that.

That includes various things but of most relevance to you:

You cannot transport the SYSTEM tablespace. Therefore, objects such as sequences, PL/SQL packages, and other objects that depend on the SYSTEM tablespace are not transported. You must either create these objects manually on the destination database, or use Data Pump to transport the objects that are not moved by transportable tablespace.


That being said I've not seen this method used to go from 11 to 12, but that doesn't mean it doesn't exist. I'd have expected you to do a full transportable option, but I'm not sure anyone has ever done that for real based on what I've seen playing with it.
Previous Topic: RMAN and Dataguard
Next Topic: rman encrypt on level_0_script_
Goto Forum:
  


Current Time: Thu Mar 28 18:07:03 CDT 2024