Your Doorstep to the Temple of Oracle

Oracle EBS

CEMLI Activity

Posted by appsdba11i on May 13, 2011

some times customer requires their package and package body to be run in their respective instance.

so, they provide us with the files.

As an analyst we need to perform the customer activity.
but can't perform it blindly.

so firstly we do check about the content in the package and package body.

Then we come to know that it is modifying some object ( by "CREATE OR REPLACE" syntax).
so prior applying we need to take backup of the object.

Here it follows:
================
1. Check the object existence and its Status prior applying a new one.
 
select owner,object_name,object_type,last_ddl_time,status from all_objects where object_name='&Name';



2. Then take the package backup as follows

Package backup
==============

set pagesize 0
set linesize 800
set trimspool on
set heading off
set feedback off
spool /tmp/mar2/XXXXXXXX_PKG
select text from dba_source where name='XXXXXX_PKG' and type='PACKAGE';
spool off


3. If Pakage body backup is also required then it is as follows

package body backup
===================
set pagesize 0
set linesize 800
set trimspool on
set heading off
set feedback off
spool /tmp/mar2/XXXXXXX_PKG.pkb
select text from dba_source where name='XXXXXXX_PKG' and type='PACKAGE BODY';
spool off
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: