Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do you create a small version of a large database ?
"Glen A Stromquist" <glen_stromquist_at_no_spam_yahoo.com> a écrit dans le
message de news:V3kac.32919$Ct5.15335_at_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 ?
> >
> >
You can also download dmp2sql, a perl script that works pretty well and extracts the SQL from an export file. You can download it from http://www.orsweb.com/downloads/source/523.html
It's free. You can also contect the author for the latest version, for some reason, the available version from the author's website is corrupted. Received on Tue Mar 30 2004 - 14:31:36 CST