Re: view create table statements

From: Dick <d.w.pluim_at_kpn.com>
Date: Mon, 18 Mar 2002 10:46:31 +0100
Message-ID: <a74d1o$roh$1@hdxl22.telecom.ptt.nl>

"Bjoern Henning" <b.henning_at_safe4net.com> schreef in bericht news:fda028b0.0203150822.72469b65_at_posting.google.com...
> Is there a way of viewing the create table,view.. of an existing
> oracle database? I don't want to use a tool, just generating a file
> would be perfect. I need this for transforming a complex ora-db into
> mysql.

A former colleague-DBA'er wrote a script to generate a 'create table'-script based on owner and tablespace. It will take the current storage for the table in 1 extent. I rewrote it a bit, with respect to actual usage of the table. If you want a copy of it, I can drop it here.

Greetings, Dick Received on Mon Mar 18 2002 - 03:46:31 CST