Re: Refreshing test d/base

On 14 Apr 2005 08:44:43 -0700, "Eugene" <epipko_at_hotmail.com> wrote:

>Thanks for your replies.
>I didn't mentioned that we are using SAN and physical database files
>copy is done by the network admin. All I need is to refresh data, but
>leave the code as it was before. I am just looking for a way to save my
>test code(pkg,procs,views etc.), since we don't have development. I am
>not a dba, so by looking from the side, it looks to me that if I am
>able to save source$, let network guy to move d/files and then override
>new source$(from prod) with old one. That should restore all the code,
>shouldn't it?
>
>Eugene

No. It doesn't. It does two things
- It screws up the datadictionary as information about pl/sql is stored in more tables than source$ aolone. - It invalidates your support contract.

It's all up to you whether you want to continue hacking, or do things properly.

--
Sybrand Bakker, Senior Oracle DBA