Re: Reorganisation of a large database table

From: Rainer Scheel <rainer.scheel_at_sno.drs1.x400.sni.de>
Date: Tue, 30 Jun 1998 14:15:01 +0200
Message-ID: <3598D6C5.6BBF654A@sno.drs1.x400.sni.de>

Sigrid Staudte wrote:

> when I use the
> export utility with compress extents, oracle want to create an initial
> extent bigger than 2 GBytes.

> Is it possible to edit the export file to reduce the size of the initial
> extent of the database table?

Editing the dump file is not recommended. Before doing the import, you should create the table via SQL. Be sure to include the storage options, e.g.

CREATE TABLE BIG(
FILENAME VARCHAR2 (200), WORDDOC LONG RAW )
STORAGE(INITIAL 10M ); After that, you can do the import with "ignore=y", e.g. imp73 ignore=y userid=scott/tiger file=...

Hope this helps.

Rainer Scheel
Software Engineer Received on Tue Jun 30 1998 - 07:15:01 CDT