Re: Instance installer

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 06 May 2005 07:49:42 -0700
Message-ID: <1115390744.333559_at_yasure>


ciccio wrote:
> IANAL_VISTA wrote:
>

>> ciccio <ciccio_at_ciccio.it> wrote in news:427a282e_1_at_x-privat.org:
>>
>>> I'm searching for a product that allows me to obtain, from an 
>>> existing instance, a set of scripts that recreates it on a different 
>>> computer, allowing me to choose (during script preparation) whether a 
>>> particular table must be created empty or with data and, in the last 
>>> case, creating me insert scripts too.
>>> Is there anything like this?
>>
>> Such as EXPORT & IMPORT?

>
>
> Something with a smmother approach, i.e. something that lets me choose
> the instance, export packages, stored procedures and so on, mark the
> tables to be exported empty and those whose contents must be exported
> to, in order to have a set of scripts such as:
>
> oradim etc etc etc
>
> create procedure blah blah blah
> /
> [...]
> create sequence blah blah blah
> /
> [...]
> create table blah blah blah
> /
> [...]
> insert into blah blah blah values etc etc etc
> /
> [...]
>
> So the resulting set of script can be released to the customer and allow
> him to recreate the DB in case of failure or in case reinstallation is
> needed for any reason.
>
> Thanks

I don't think there is any single solution to what you want other than using a CASE tool such as ERwin. But also look at the DBMS_METADATA built-in package.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri May 06 2005 - 16:49:42 CEST

Original text of this message