Re: Cloning database structure

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Sat, 14 Oct 2006 22:42:32 -0400
Message-id: <1160880152l.6445l.0l@medo.noip.com>

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

Received on Sat Oct 14 2006 - 21:42:32 CDT