RE: Cloning database structure
- From: "Peter McLarty" <Peter_McLarty@xxxxxxxxxxxxxxxxxxxxx>
- To: <prabhu_adam@xxxxxxxxxxx>
- Date: Mon, 16 Oct 2006 11:18:15 +1000
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Mladen Gogala
> Sent: Sunday, 15 October 2006 12:43 PM
> To: prabhu_adam@xxxxxxxxxxx
> Cc: niall.litchfield@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
