Re: How to Exp/Imp Subsets of Data?

From: <abalbekov_at_my-dejanews.com>
Date: Wed, 10 Jun 1998 15:22:26 GMT
Message-ID: <6lm8bi$l2t$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
>

No, Oracle Export does not provide such possibility. Instead you can create SQL script with SELECT statements you want, run it with SQL*Plus and spool output to ASCII file. After that use SQL*Loader to load data to development database.

Hope this helps

Albert Balbekov,
GRT Inc.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Jun 10 1998 - 10:22:26 CDT