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

From: Richard Elliott <richard.a.elliott_at_williams.com>
Date: 31 Mar 2004 11:52:44 -0800
Message-ID: <8c132b3c.0403311152.19375326@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! Received on Wed Mar 31 2004 - 13:52:44 CST