Re: PLEASE : table create script

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 Mon Feb 15 1999 - 14:40:31 CST