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

From: Neil Cudd <neil_at_cudd.demon.co.uk>
Date: Tue, 2 Nov 1999 15:12:09 -0000
Message-ID: <941555680.28407.0.nnrp-12.c2de6f3d@news.demon.co.uk>

An easier way would be to do an export with show=Y and pipe the output to file.

Yes you do get all the indicies and constraints, but your tables aren't much good without them anyway.

hth
neil

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 - 09:12:09 CST

This message: [ Message body ]
Next message: mark_at_vitalworks.com: "Re: using a double quote character inside a text field as an initial value..."
Previous message: Gazza: "Re: Max Extents"
In reply to: Chroma: "how to extract create table scripts from datadictionary views?"
Next in thread: The Plums: "Re: how to extract create table scripts from datadictionary views?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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