Re: How to split a data definition SQL script file (DDL script)
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 16 Sep 2006 22:25:48 +0200
Message-ID: <9anog2lqcfjsh5oep04sbe79qr74q1633r_at_4ax.com>
Date: Sat, 16 Sep 2006 22:25:48 +0200
Message-ID: <9anog2lqcfjsh5oep04sbe79qr74q1633r_at_4ax.com>
[Quoted] [Quoted] On Sat, 16 Sep 2006 21:22:21 +0200, Seb <arx9qekubvq93e3_at_jetabe.net> wrote:
>Hello,
>
>I need to split a Oracle data definition SQL script file (DDL script) to
>many files, each file corresponding to one command category (table
>creation, constraint creation, index creation, etc).
>Do you know some tool to do that ?
>
>Thanks in advance for your answers !
awk, vi and sed come to mind. If you are on Windows, gvim is a vi clone for Windows, www.gvim.org If you need awk and sed too you can download Cygwin, which is (korn)shell clone for Windows.
And then of course Perl could do it.
-- Sybrand Bakker, Senior Oracle DBAReceived on Sat Sep 16 2006 - 22:25:48 CEST