Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Copying & resizing schema between dbs?
Hello,
You have to create all the tables and indexes before doing the import with
the good storage clause.
There is no other way.
You can try this :
* create tablespace DATA ... STORAGE (initial 4K next 16K pctincrease 50);
* extract from the export file all SQL : create table and create index, and
then supress the storage clause, but use
the tablespace DATA
Then you can create the tables and indexes, the storage clause of the
tablespace DATA will be use for the tables and indexes.
* import with ignore=y commit=y
Good luck
"ak" <a_at_k.com> a écrit dans le 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
>
>
Received on Mon Dec 18 2000 - 18:23:24 CST