Re: import trouble

From: Boris Izotov <ibw_at_imail.dc.ukrtel.net>
Date: Sat, 13 Jan 2001 19:28:42 +0200
Message-ID: <93q39h$l8k$1@news.dc.ukrtel.net>

.....................

>
>You are probably experiencing the errors on the indexes associated with
>your tables. Try using indexes=n and commit=y on your import. The
>first will not attempt to create any indexes on your tables and the
>second will commit each buffer of data imported. This should put most,
>if not all, of your data into your tables so that you can go back and
>build your indexes after the import completes.

I tried both indexes=y and indexes=n. Commit=y I use always because of some tables are large - from 5 to 10 Gb.
The problem is invalid value in storage parameters - initial 2147483648. I tried to create manually tables with such value and got the same error - ora-02218. But when I specified initial 2147483646 (2 less than original parameter) - table was created wih initial extent 2146435072 bytes. Anyway I created this tables manually but import gets error 2218 during process and ignores the tables. The question is how to get data from the dump file, are there any other utilities for getting data from export file?

>
>--
>David Fitzjarrell
>Oracle Certified DBA
>
>
>Sent via Deja.com
>http://www.deja.com/
Received on Sat Jan 13 2001 - 11:28:42 CST