Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Emergency!! -- How to output all package from the database?
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