Re: How do you create a small version of a large database ?

From: Glen A Stromquist <glen_stromquist_at_no_spam_yahoo.com>
Date: Tue, 30 Mar 2004 19:41:41 GMT
Message-ID: <V3kac.32919$Ct5.15335@edtnps89>

Richard Elliott wrote:

> I want to create a much smaller version of an existing database. I was
> planning on just using export/import with import being objects only,
> no data. The data was going to be loaded with custom sql to select a
> specific subset of the existing database via a BD link. The export
> however creates DDL that has the large extent sizes and these fail
> when being created in the smaller instance since there is not enough
> space in the table spaces. I am trying to create a database that is
> 10% the size of another. I can't edit the export text ( to adjust the
> DDL) without causing it to be corrupt. How else can this be done ?
>
>
> Thanks in advance for the help.

www.databee.com

Havent tried it yet, but heard that its pretty slick for exactly what you want to do...

hth Received on Tue Mar 30 2004 - 13:41:41 CST