Re: Partial export of a database ???

You can find instructions on cloning databases on my web site (at the backup and recovery page).

The short answer to your actual question is 'not really'.

The longer answer might be to arrange for the big tables to be in their own tablespace (which probably should already be the case), and clone a subset of the database, following the instructions mentioned earlier... in other words, you don't copy across all the datafiles. You then simply sit at the clone in mount stage doing 'offline drop' against the non-cloned datafiles, open what's left of the clone database, and drop the tablespaces that relate to those datafiles.

Just a thought,
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



"news.sky.fr" <ybuillas_at_sopra.com> wrote in message
news:8qss6l$dn4$1_at_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

>

>