Re: How to Exp/Imp Subsets of Data?

From: <thomasj_at_platinum.com>
Date: Mon, 08 Jun 1998 16:29:52 GMT
Message-ID: <6lh3i0$8p8$1@nnrp1.dejanews.com>

In article <6leehf$dqo$1_at_nnrp1.dejanews.com>, vxf_at_akc.org wrote:
>
> I am trying to populate a test database and a development database with
> production data. I do not have the dasd or the need to export/import the
> entire database. Is it possible to export a subset of rows from a table?
> For example, if I wanted the first 500,000 rows out of a 3 million row table,
> are there parameters in exp/imp that will allow me to do this?
>
> If not what is an alternative? Any input would be appreciated. Thanx
>
> Vicky Foster, DBA
> American Kennel Club
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

PLATINUM Fast Unload for Oracle is a high performance data export utility which exports data five to ten times faster than Oracle Export. Fast Unload also allows users to tailor the format of the data output, and the user can determine the rows and columns being extracted and their order instead of unloading all of the data.

For more information, please visit the product page at: http://www.platinum.com/products/dba/fu_o_ps.htm

Janis Thomas
Platinum Technology, Inc.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 08 1998 - 11:29:52 CDT