Re: Refreshing test d/base

From: Valentin Minzatu <nospam_at_nowhere.com>
Date: Fri, 15 Apr 2005 00:08:28 -0400
Message-ID: <49adnaMSjfGjo8LfRVn-tQ@rogers.com>

Is there a constraint which prevents you from using transportable tablespaces? If not I would see that as an alternative to be considered. PL/SQL is stored in the SYSTEM tablespace so as far as you don't alter it your code stays the same.

Cheers,
Valentin Minzatu

"Eugene" <epipko_at_hotmail.com> wrote in message news:1113429184.973232.239280_at_z14g2000cwz.googlegroups.com...
> Hi all,
> DB: 9.2
> OS: Win 2003
> We need to refresh test d/base, but last time when we did that all the
> procedures and packages were overriden by the prod scripts.
> Is there a way to back up a source$ table, for instance, and then,
> after refresh of data, put it back in???
>
> Thanks,
> Eugene
>
Received on Thu Apr 14 2005 - 23:08:28 CDT