Re: PLEASE : table create script

Hi,

To generate the script for all tables, indexes, constraints, grants table triggers with appropriate ( must have exprted file with COMPRESS = Y) storage parameters, you can simply use

imp show = y along with other relevent parameters.

Thomas Schade <intakt_at_t-online.de> wrote in article <36C8863F.D4C26A2D_at_intakt-online.de>...
> Adrian Klingel schrieb:
> >
> > I'm looking for a script that will spool 'create table' commands to a
file
> > for all the tables for a user from what's in the database. Does
anybody
> > have this? I was really surprised not to find something so basic at
> > technet.oracle.com. Thanks very much for your help.
> >
> > Remove the quotes and their contents from my email address below to
reply.
> >
> > Adrian Klingel
> > klingela@"please don't spam me"nortelnetworks.com
>
> The easiest way to do this is using export and import:
>
> 1. exp <youruser>/<passwd>@<connection> owner=<youruser> rows=no
> file=tempfile.dmp
> 2. imp <youruser>/<passwd>@<connection> fromuser=<youruser>
> indexfile=tablecreate.sql
>
> You have to remove the "REM" at the beginning of each row in
> tablecreate.sql. Maybe you don't like that the format ist not very
> readable.
>
> Thomas Schade
> ts_at_intakt-online.de
>
Received on Tue Feb 16 1999 - 11:20:42 CST