Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Creating tables from views ...

Re: Creating tables from views ...

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Thu, 09 Jun 2005 19:57:09 +0200
Message-ID: <d89vk4$sve$1@news2.zwoll1.ov.home.nl>


ManChild wrote:
> I was wondering if there was a tool sitting out there anywhere that
> would enable me to quickly generate CREATE TABLE statements using the
> schema used in a set of views?!
>
> I have an application which is running on several hundred views, I know
> want to produce a version using identical tables and yet am feeling
> underwhelmed by the time this will take.
>
> I'd rather the scripts over anything as I will need to go back and
> insert all those fun foreign keys, indexes and everything else ......
>

Learn to sed and/or awk:
s/view/table/g

-- 
Regards,
Frank van Bortel
Received on Thu Jun 09 2005 - 12:57:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US