Re: Cloning database structure

  • From: Mladen Gogala <mgogala@xxxxxxxxxxx>
  • To: prabhu_adam@xxxxxxxxxxx
  • Date: Sat, 14 Oct 2006 22:42:32 -0400

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


Other related posts: