Re: import trouble

IMP first tries to create the table in question and if CREATE fails because
the table exists, it can then ignore that error and proceed, but if the CREATE fails for any other reason it just skips it with an error.

The way I would choose in a similar case would be to open the .DMP in a HEX editor
(or an editor that preserves binary chars it cannot recognise) and change the INITIAL
there manually, then IMP as usual (with or without the table)... = Alex.

Boris Izotov wrote:
>
> .....................
> >
> >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 Fri Jan 19 2001 - 08:09:14 CST