Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Import Problem

Re: Import Problem

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 08 Jun 2004 22:00:40 -0700
Message-ID: <1086757254.102284@yasure>


Kwizatz Haderach wrote:

> After having a database crash, we havec created a new database instance.
>
> Then we tried to import our last export doing a fullimport.
>
> We had problems during import due to a materialized view.
>
> After solving this problem, we try to import the missing tables.
>
> Our problem is that the import utility tell us that he cannot find these
> tables in the export file. We have checked the export file and found the
> "INSERT INTO" part of each missing tables inside the file.
>
> Our dump file is about 13GB
>
> Does anyone has an idea of how to solve the problem :
> - forcing the import to find those tables in the dump file
> - convert the export file into an sql file
> - other ...
>
> We are running Oracle 9.2.0.5
>
> Thanks

Not without an ORA- error message. We have no idea what went wrong.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Jun 09 2004 - 00:00:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US