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

Home -> Community -> Usenet -> c.d.o.server -> Re: how to extract create table scripts from datadictionary views?

Re: how to extract create table scripts from datadictionary views?

From: The Plums <nc1967_at_hotmail.com>
Date: Tue, 2 Nov 1999 16:06:26 -0000
Message-ID: <7vn28c$qh$1@pheidippides.axion.bt.co.uk>


TOAD (freely available from www.toadsoft.com ) provides a facility to create table scripts. You can also choose whether to include constraints, indexes etc;

HTH NeilC

Chroma wrote in message <941540763.23203.0.pluto.d4ee2f03_at_news.demon.nl>...
>Can anyone tell me, how to extract CREATE TABLE scripts for all user tables
>from the Oracle datadictionary views?
>
>Thanx,
>
>Martijn
>
>
Received on Tue Nov 02 1999 - 10:06:26 CST

Original text of this message

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