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