Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to save my tables structures in a file?
circuit_breaker wrote:
> 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.
create a database link between the "other box" & existing DB.
The from the "other box"
create table <table> as select * from <table>@orig where 1 = 2;
Received on Wed Oct 01 2003 - 19:46:19 CDT