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

"Richard Elliott" <richard.a.elliott_at_williams.com> wrote in message news:8c132b3c.0403311152.19375326_at_posting.google.com...
> Thanks for all the great feedback!
> Sorry I did not post the version or other relavant info. I posted the
> question because I am waiting on the real DBA to get Import working,
> and I think it's going to be a lot of work to make the EXP file create
> a small DB when it's imported.
>
> Oracle 8.1.7
> Need every object, triggers, indexes etc, not just table data.
> I think I can use IMP to get 90% of what I need, and DDL extract to a
> file I can edit for the tables/indexes/triggers etc. DataBee looks
> promising also, thanks for that one.
>
> I have DBArtisan, but have never used the scheama extract stuff, that
> may well be a feasible solution.
>
> Thanks again!

check out http://www.databee.com for a tool that supposedly does this. Received on Thu Apr 01 2004 - 20:31:26 CST