Re: Export files & their embedded DDL

From: Wayne Linton <lintonw_at_cadvision.com>
Date: 1996/12/17
Message-ID: <32B768E0.18A7@cadvision.com>#1/1

John Verhoeven wrote:
>
> Does anybody have a script ot read an export file and pull out all the
> o Create <type> commands
> o Alter <type> commands
> o Grant commands
>
> What I want to do is to export a table and parse the export file to get
> all the DDL relating to the creation of an object.
>
> --
> _--_|\ John Verhoeven Unix / Database Administrator Westrail
> / \ johnv_at_DIALix.oz.au / jverhoeven_at_westrail.wa.gov.au
> *_.--._/
> v "Smile! things could be worse... So I did... and they were..."

try the INDEXFILE option of the import command. you can then edit the resulting file with some editor of choice (or O/S file manipulator such as VMS's DCL).

Wayne Linton
Shell Canada Ltd. Received on Tue Dec 17 1996 - 00:00:00 CST