Instance installer

[ciccio]

Hi,

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?

Thanks

[IANAL_VISTA]

ciccio <ciccio@ciccio.it> wrote in news:427a282e_1@x-privat.org:
Hi, 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? Thanks

Such as EXPORT & IMPORT?

[ciccio]

IANAL_VISTA wrote:
ciccio <ciccio@ciccio.it> wrote in news:427a282e_1@x-privat.org:I'm searching for a product that allows me to obtain, from an existinginstance, a set of scripts that recreates it on a different computer,allowing me to choose (during script preparation) whether a particulartable must be created empty or with data and, in the last case, creatingme 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

[Daniel Morgan]

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

Or transportable tablespaces?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[Daniel Morgan]

ciccio wrote: IANAL_VISTA wrote: ciccio <ciccio@ciccio.it> wrote in news:427a282e_1@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@x.washington.edu
(replace 'x' with 'u' to respond)

[Maxim Demenko]

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@ciccio.it> wrote in news:427a282e_1@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.