Re: Database Refresh

rbakare wrote:

> Hi,
>
> I have a Oracle 8i production database that is 300 GB in size. My
> development environment is quite small. I cannot refresh the
> Development database with the production one due to space and data
> sensitivity constraints.
>
> 1. How can I get a consistant "subset" of Production database and
> refresh the development schema ?
> 2. How can I maintain the refrential integrity ?
>
> Please advise ASAP.
>
> Thanks in advance.
>
> RBakare

In addition to the other responses you can go to http://tahiti.oracle.com and look at the SAMPLE clause to Oracle's SELECT statement.

It would allow you to take a percentage of the rows from a parent table and then you can easily populate from there.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)