Re: Instance installer
Date: Fri, 06 May 2005 21:39:28 +0200
Message-ID: <d5gh59$7mi$04$1_at_news.t-online.com>
I can only agree, that there can not be a single solution, the number of
different databases can not be ever estimated - you can have small
databases consisting of 10 tables, or huge consisting of thousands, what
sense can be to write insert scripts for table of 600 Gb, or table with
blobs etc.
For purposes of obtaining ddl scripts there are many solutions as well -
if you prefer comfort, you can use Oracle Designer, it generates scripts
for pretty grouped for different kinds of objects , but can't manage a
lot of new features.
If you have used them, i would recommend exp ( as it generates almost
100% correct ddl, i have seen really a very few failures ) at the first
place and as DA Morgan pointed out - DBMS_METADATA ( to obtain sql from
the dump file you can use impshow.sql script , Metalink Note:131437.1
or DDL Wizard from http://www.databee.com/dt_home.htm, of course a
little bit more buggy than impshow.sql for my taste ).
There are many 3rd party gui on the market , most of them have such a
capability ( pl sql developer, tora, sql navigator, keep tool ), all of
them generate ( again , its only my expirience ) less accurately code
than the oracle native tools.
As the last idea, this approach may be good for initial setup of your
product, but it should not be used for recreation of db in case of
failure, the only adequate method to do it - implement proper
backup/recovery strategy.
Best regards
Maxim
DA Morgan schrieb:
> 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.Received on Fri May 06 2005 - 21:39:28 CEST