PDA

View Full Version : Import Problem


Kwizatz Haderach
06-08-2004, 01:15 AM
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


MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service