Re: how to save my tables structures in a file?

From: Glen A Stromquist <glen_stromquist_at_no.spam.yahoo.com>
Date: Wed, 01 Oct 2003 19:04:40 GMT
Message-ID: <czFeb.209$qq2.120@edtnps84>

Michel Cadot wrote:

> "circuit_breaker" <circuit_breaker_at_canada.com> a écrit dans le message de
> news:2863e14b.0310011001.1b31a1a6_at_posting.google.com...
>

>>Hi,
>>
>>I created a database in which I have several fields.  I would like to
>>rebuild this structure on another Oracle box and I'd like to know how
>>to "export" the tables data structure to a file in order to re-create
>>it on the other box.
>>
>>
>>Thank you.

>
>
> At least 2 ways:
> - export: exp rows=n tables=...
> - procedure: dbms_metadata.get_ddl
>
> Hope this helps
> Michel Cadot
>
>

If its just a table or a few, a nice fast way it to right-click on the table in OEM or DBA studio and pick "show object ddl" (or something like that), it'll let you save it to a file or just crtl-c it and paste into notepad, vi, sqlplus or whatever...

hth Received on Wed Oct 01 2003 - 14:04:40 CDT