RE: PACKAGES
- From: "Aragon, Gabriel (GE Commercial Finance)" <gabriel.aragon@xxxxxx>
- To: <RROGERS@xxxxxxxxxxxxx>, <oracledbam@xxxxxxxxxxx>, <fairlie_r@xxxxxxxxx>
- Date: Tue, 9 Aug 2005 14:46:20 -0400
This also works nice
sql> set pagesize 0
sql> set long 90000
sql> select dbms_metadata.get_ddl('PROCEDURE', proc_name, owner) from dual;
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Ron Rogers
Sent: Martes, 09 de Agosto de 2005 06:26 a.m.
To: oracledbam@xxxxxxxxxxx; fairlie_r@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: PACKAGES
How about selecting the text from dba_source where name ='PACKAGE IN QUESTION'
and then running the sql on the other server.
It also is a good method of documenting the database.
Ron
>>> fairlie rego <fairlie_r@xxxxxxxxx> 08/08/05 11:37 PM >>>
Hi Seema,
You can use procedural replication.
Unfortunately I do not have an example on hand
but you can refer the documentation
at
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96568/rarmanma.htm#22542
Section: Using Procedural Replication
Regards,
Fairlie
Seema Singh <oracledbam@xxxxxxxxxxx> wrote:
Hi,
I want to copy 1 package from one database to another.
How can I do that?
how can we setup replication for package/procedure/functions?
thanks
--
//www.freelists.org/webpage/oracle-l
Fairlie Rego
Senior Oracle Consultant
Optus Telecommunications
www.optus.com.au
Mobile: +61 4 02 792 405
When I read about the evils of drinking, I gave up reading.
---------------------------------
Start your day with Yahoo! - make it your home page
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
