Re: Need Help Fast: Can't Import Oracle Export direct option set to Y

Hi Mike,

Your restore procedure call back the hole database. If all is OK, your tables are available.

When you import the other file, the import function attempt to create object contained in the data file.
This object already exists !.

Two solutions :
1) drop table that you want the import and then import them. 2) cleanup table (with TRUNCATE for example) and import them with ignore warning clause (object already exists but records are needed).

Think that the export file contains SYSTEM table and so on. Depending of your apps, you can choose dropping table by table or more if needed (customer by customer, ..)

Hope this helps.

--
REIP Jean-Claude
Enlevez ".remove.this" de l'adresse (anti-spam)
jacari.consultant.remove.this_at_skynet.be
Administartor wrote in message <01bcf8e2$01943a00$13880cd1_at_iag-nt>...


>We have lost our database and tried to recover from and export which was

>done using the direc=y option set on Oracle 7.3.3. Apparently, their is and

>unreported bug and the file ma be corrupt. The system is set up on an NT

>platform and the database is Oracle Workgroup Server 7.3.3.

>

>We did not have archive log mode on and we do not have a cold backup other

>that the 11th.

>

>I have recovered using a Nov 11 backup but need the data back from the 11th

>on.

>

>Mike Brandt

>Systems Administrator

>Internet Association Group, Inc.

>mbrandt_at_resourcecenter.com