Re: import trouble

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 12 Jan 2001 14:41:21 -0000
Message-ID: <93n52m$90k$1@soap.pipex.net>

rerun export with compress=n. compress=y tells oracle on import to import all data to a single extent..

regards

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Boris Izotov" <ibw_at_imail.dc.ukrtel.net> wrote in message
news:93n0vh$91b$1_at_news.dc.ukrtel.net...


> Hi All

>

> I have got trouble with import - ora-02218 invalid INITIAL storage option

> value.

> The first idea came to me was create tables manually, but anyway import

 gets


> the same error and skip all data for this tables. I tried use full

 database


> import and specified tables.

>

> Storage parameters for these tables -

> .... STORAGE(INITIAL 2147483648 NEXT 209715200 MINEXTENTS 1 MAXEXTENTS

> 2147483645  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)

>

> Manually I created with smallest initial extent, but import fails in any

> case.

>

> Server - Oracle 7.3.4.4.0, Windows NT 4.0 Server EE

> Client - Oracle 7.3.4.4 | 7.3.4.5 Windows NT Server 4.0

>

> What should I do for import finish successfully?

>

> Boris

>

>

Received on Fri Jan 12 2001 - 08:41:21 CST