Re: Copying & resizing schema between dbs?

I see that others have pointed you at third party tools where the export utility will do this for you.

use the syntax

exp .... compress=n

IT seems to me that the default of y is unhelpful for at least two reasons

1. People don't read docs and so assume that compress is to do with data compression and will make their export smaller and
2. It is far far too easy to end up unable to import an object because it is has an initial extent larger than the datafiles for the tablespace.

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"ak" <a_at_k.com> wrote in message news: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

>

>