Re: retrieve database schema

From: Richard Sutherland <rvsutherland_at_yahoo.com>
Date: Tue, 6 Mar 2001 04:47:20 -0500
Message-ID: <ta9cg363qljpf9@corp.supernews.com>

TOAD works from a PC client.

If you'd rather do it from the Unix command line, for a single object (table, index, constraint, et al), try the free Perl module DDL::Oracle available from the CPAN, and from:

http://sourceforge.net/projects/ddl-oracle/

Richard Sutherland
rvsutherland_at_yahoo.com

Trevor <nospam_at_thanks.com> wrote in message news:3AA438EC.C19D2CFE_at_thanks.com...
> Hi
>
> Just moving to Oracle from other databases
>
> Can somebody please explain how you can access the DML
> which was used to create a table in the database?
>
> With IDS we would use something called 'dbschema'.
> What is the equivalent with Oracle (8i, if it matters)?
>
> Thanks
> Trevor
>
> reply-to address is invalid
> to reply directly, please use
> tcn at inform dot co dot nz
Received on Tue Mar 06 2001 - 03:47:20 CST