Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Copying & resizing schema between dbs?
Functionality for the purpose of the poster being the same between KeepTool and DDL::Oracle, I feel obliged to point out the difference in pricing.
KeepTool per each copy -- $380 USD DDL:Oracle per 1,000 copies -- FREE ;-)
Richard
rvsutherland_at_yahoo.com
Holger Heidenbluth <heidenbluth_at_nis-rheinsberg.de> wrote in message
news:3a3ddbd7$0$8782$4dbef881_at_businessnews.de.uu.net...
> The Reverse/DDL Engineer from KeepTool (www.KeepTool.com,
> free 30 day trial version) generates the complete DDL script for a
> schema. Uncheck the option "generate storage clauses". Since you
> leave the storage clauses blank the default storage parameters of the
> tablespace will be used.
>
> Regards
> Holger
>
> ak <a_at_k.com> schrieb in im Newsbeitrag:
> Q4i%5.4206$%v1.137480_at_ozemail.com.au...
> > Hi,
> >
> > I want to create all the objects that are present under a user in one
> > database into another database, without data. The twist is that in the
> > source database, the objects are very large, and I want to resize them
in
> > the target database.
> >
> > I tried exporting the user with rows=n, but found that the initial
extent
> > for these objects is set to the actual size of the object in the source,
so
> > there's no benefit.
> >
> > I tried creating a DDL file from the export file using indexfile=...,
and
> > started changing the storage clauses manually, but there's way too many
> > clauses to change.
> >
> > Is there a simpler way for me to copy the schema, without data, and
default
> > the storage clauses to something smaller? Even if I have to change them
all
> > to the same size, and then expand them as required, it would be OK.
> >
> > Thanx for any help.
> >
> > -a
> >
> >
>
>
Received on Mon Dec 18 2000 - 17:28:12 CST