.Dmp file restore

Backup, Recover, Import, Export, Datapump, etc
Post Reply
syscode
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 3
Joined: Wed, 30 Mar 2011 9:38 am
Location: Blumenau - SC

Environment information:
* Oracle version: Oracle Xe 10.2.0
* Operating system: Windows XP Pro Service Pack 3

Good morning.

I have the following problem: A client sent a .dmp file so that it is imported here in the company. However, I do not absolutely move anything with Oracle (very bad with mysql). I would like to know what I should do (if possible, very simple explanation). I tried the IMP in the end of the import is the following message:

IMP-00003: Oracle error: 439 Found

implys closed with ixito, with warnings.


I would like to know how to import .dmp simply.

Thanks in advance.
burga
Rank: DBA Pleno
Rank: DBA Pleno
Posts: 232
Joined: Thu, 26 Nov 2009 1:05 pm
Location: SP
Ricardo H. Tajiri

matters closed with ?exite, with warnings.
As the message itself said the import closed successfully. That is, you did the correct import procedure.
The rest must be Grants problems, some objects that need to be recompiled, etc ...
syscode
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 3
Joined: Wed, 30 Mar 2011 9:38 am
Location: Blumenau - SC

Thanks for the return, Buga.

One more question: Is it possible to get this file that was imported into my Oracle and generate a DBF file, for example? Where can I see inside Oracle Xe these tables?

again, thanks for the return.
burga
Rank: DBA Pleno
Rank: DBA Pleno
Posts: 232
Joined: Thu, 26 Nov 2009 1:05 pm
Location: SP
Ricardo H. Tajiri

As you already imported the dump for your instance, now just connect to it and hold your queries normally ... The tables have already been imported into a Datafile (DBF) of your instance.

If you know the schemes that are within your dump, mount consultations will not be a problem.
syscode
Rank: Estagiário Pleno
Rank: Estagiário Pleno
Posts: 3
Joined: Wed, 30 Mar 2011 9:38 am
Location: Blumenau - SC

Thanks a lot for the help!

Now I will look for some tool that convert Oracle to SQL Server that is freeware and that works well. I tried to use Microsoft but is not working very well ..

grateful!
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 10 guests