Partial export of a database ???

From: news.sky.fr <ybuillas_at_sopra.com>
Date: Wed, 27 Sep 2000 15:20:14 +0200
Message-ID: <8qss6l$dn4$1@news.entreprises.cegetel.fr>

Hi and thanks for reading,

I would like to clone a database from one machine to another one (not on the same network)

There are just the datas of one user which need to be cloned.

At the moment, I use an export of all the object of this user, compressing of the dump file and transfert via ftp (and after, import of this user on the other machine)

There are a lot of tables (about 1500 !) and about 30 tables are very big and don't need to be transfered (but all of these table are owned by the same Oracle user)

So, my question is :
Is it possible to do a partial export of a database --- i.e. something like " export ( select * from tab where tname like 'x%' ) ---

Any idea ?

Thanks in advance,
Yan in Annecy (France)
mailto:ybuillas_at_sopra.com Received on Wed Sep 27 2000 - 08:20:14 CDT