REPOST: Re: Scripts to generate views and tables

Yes, You can look through ALL_TABLES, ALL_TAB_COLUMNS and ALL_VIEWS to get the information.

Tom
www.oraclepower.com

"Vinnie" <vwas_at_nospam.hotmail.com> wrote in message news:zAg48.2052$s_7.1445465338_at_newssvr14.news.prodigy.com...
> I'm running an Oracle 8.0.6 database and would like to see if there is a
> script which I can run which will in turn generate both tables and views
for
> a test version of our production database. I don't want to use the
> export/import because I'd like to modify several of the tables at the time
> of creation. I saw a couple of scripts on Metalink but they were all crap.
> Any ideas?
>
> TIA
>

• WAS CANCELLED BY =======: From: "Tom Dyess" <tdyess_at_dyessindustries.com> Control: cancel <oFg48.122182$_w.16909714_at_typhoon.tampabay.rr.com> Subject: cmsg cancel <oFg48.122182$_w.16909714_at_typhoon.tampabay.rr.com> Date: Sun, 27 Jan 2002 23:52:01 GMT Message-ID: <cancel.oFg48.122182$_w.16909714_at_typhoon.tampabay.rr.com> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40722921

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 11:33:08 CST