Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Import Problem
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
![]() |
![]() |