Re: view re-creation

DDL Wizard will do the job for you. Just export the schema rows=n

The tool runs on windows, so copy the dmp file back to your PC.  Fire up it
up and select the dmp file.

From there its a piece of cake... just follow the on screen steps.

Its a free tool, see http://www.ddlwizard.com/

HTH
Tony

Other related posts: