Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Emergency!! -- How to output all package from the database?

Re: Emergency!! -- How to output all package from the database?

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Thu, 14 Jun 2001 11:57:53 +0100
Message-ID: <992516180.12058.0.nnrp-14.c30bdde2@news.demon.co.uk>

Why not just keep your source scripts in a normal text editor instead of developing them in Sql*Plus (which is what I assume you are doing)?

When you have a version you want to load in, just do @packagename. If it doesn't work, then @old_packagename etc.

"JK Yao" <jkyf0131_at_hotmail.com> wrote in message news:93f65984.0106131756.26c3e265_at_posting.google.com...
> Anyone know if there is any way or any command that can export all the
> package in the database. Since, everytime when we create and replace
> package, if we make it wrong and then we cannot rollback to after we
> commit it. Or anyway to rollback the package with commited and
> nonarchive mode?
>
> plz help. Emergency!!!
> JK
Received on Thu Jun 14 2001 - 05:57:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US