Re: restore 50% of a database

Got Oracle 8i? If so, create a very small database (ie, just a system tablespace) on your second PC and use the transportable tablespace feature to transfer whichever of the 'live' tablespaces you are interested in -you simply copy the relevant datafiles from one machine to another and plug them in a matter of minutes using an import of the tablespace metadata.

Couple of nasty restrictions: the operating system on the two systems must be identical, as must the release and patch of Oracle itself.

And in any event, unless you have date-based tablespaces, this won't satisfy your final stated requirement.

There are plenty of other, more long-winded alternatives.... doing selects on your source tables (with suitable 'where' clauses) to generate csv or tab-delimited text files, then sql*loader into a pre-created but empty database on the second machine, for example.

Regards
HJR

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

"Nat & Gil" <natetgil_at_evc.net> wrote in message
news:39FC8F12.82F7B2A7_at_evc.net...


> Hi,

>

> I have an one year old database. It's 8Gb big and i would like do a copy

> of this database on my pc to do some test. But i have'nt enough place on

> it. How can i just restore a part of this (eg : from a date to another

> date)

>

> Thanks