Re: Copying table structure programmatically

From: Andreas Walter <andreas.walter_at_moellergroup.com>
Date: Tue, 31 Oct 2000 09:15:09 +0100
Message-ID: <8tlv2i$8ss$1@news.bicos.de>

Hi,

have you thought of the export and import-utility with the ROWS=NO option ?

regards,
Andreas

<adnanbader_at_my-deja.com> schrieb im Newsbeitrag news:8tlqvg$3qf$1_at_nnrp1.deja.com...
> Hi All,
>
> I have an Oracle DB with a whole bunch of tables. What I want to do is
> create a copy DB using the tables/structures/constraints from the
> existing DB but without any data. And I want to achieve it
> programmatically, preferrably using Java/JDBC.
>
> The consturction of the new DB needs to be performed table-wise, i.e.
> all the information for one table needs to be extracted from the source
> DB and used to create that table with those constraints in the target
> DB. And some tables from the source DB may not be required to be moved
> over to the target DB at all.
>
> Any hints??
>
> Thanks in advance.
>
>
> Adnan
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Oct 31 2000 - 02:15:09 CST