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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Cloning database structure

RE: Cloning database structure

From: Peter McLarty <Peter_McLarty_at_technologyonecorp.com>
Date: Mon, 16 Oct 2006 11:18:15 +1000
Message-ID: <1BFEF5A6856E7C4D89A3DEE609AF884BAEB89B@brimail05.technologyonecorp.com>


Hi
Prabhu you haven't mentioned what version of database, a heads up that ddlwizard which I concur is great had a problem with 10.02 databases. The supplier knew about them and was resolving earlier this year

Cheers

Peter McLarty
Technical Consultant
Service Delivery
Tehcnology One  

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Mladen Gogala
> Sent: Sunday, 15 October 2006 12:43 PM
> To: prabhu_adam_at_hotmail.com
> Cc: niall.litchfield_at_gmail.com; oracle-l_at_freelists.org
> Subject: Re: Cloning database structure
>
>
> On 10/14/2006 10:32:35 PM, Prabhu, Krishnaswamy wrote:
> > Niall,
> >
> > Sorry for not giving full details, we did our export with rows=n and
> full=y.
> > As of now, we are trying to create only db structure not data, once
if
> the
> > structure are in sync with the corrupted development database then
we
> > thought of decommisioning that database and import the data from the
> stage
> > database. All our import are getting failled with "unable to extend
> initial
> > extents" error due to insufficient tablespace size.
>
> Have you considered magic? I know of a wizard that can help you out.
> The DDL wizard is available for free from: http://www.ddlwizard.com.
> It takes an empty export file (created with rows=no) and and extracts
> DDL commands into normal SQL files. It works on Windows and on Linux,
> using
> Wine. As everybody knows, Wine Is Not an Emulator, it's a program that
> can make some Win32 programs run under Linux. I personally tested
> it on Linux using wine and it works like a champ.
>
>
> --
> Mladen Gogala
> http://www.mladen-gogala.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Oct 15 2006 - 20:18:15 CDT

Original text of this message

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