Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle warehouse builder

Re: Oracle warehouse builder

From: Marino Ljubic <mljubic_at_globalnet.hr>
Date: Fri, 7 Apr 2006 17:50:30 +0200
Message-ID: <e161rp$dc1$1@ss405.t-com.hr>


"Apollo" <Apollonio.Valter.Mascellino_at_gmail.com> wrote in message news:1144405684.415024.49190_at_i39g2000cwa.googlegroups.com
> I sim,
>
> first of all, tank's.
>
> My problem is that i have an DB (and ETL procedures) created not by
> OWB (without metadata),
> now i need to replicate all the schema (DB and procedure) in a new
> instance, my customer system have to be created using OWB (process
> constrain)....my question is, exist an toolkit (OWB complient) to
> migrate all from the old to the new instance, is important that in
> this migration process i'll be sure about the metadata will be
> created and the etl procedure will be recognized and they will
> continue to work. The alternative is to create the new schema using
> the wizard of OWB (loosing all the work done)...isn it?
>

It is not problem to import metadata into OWB repository and deploy to another schema (database). But if you need to import rows too, it would be quicker to use export/import utility. Received on Fri Apr 07 2006 - 10:50:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US