importing tables.... [message #602733] |
Sun, 08 December 2013 03:57 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9996a32bf69a26d576c355127fae6a6d?s=64&d=mm&r=g) |
amjad_alahdal
Messages: 102 Registered: October 2013 Location: Saudi Arabia
|
Senior Member |
|
|
Hello guys, I have exported my tables in a file DMP extension,,,
I am trying to import it, but it doesn't import,,,,
I went to run,,,
cmd
then,, imp
username hr
password hr
then, I selected directory ,,,, c:\my_tables,,,,
it shows me this message in the end,,,
Import terminated successfully without warnings,,
but check the tables,,,
i see there are no tables imported ,,,,
where is the problemm,,,,
|
|
|
|
Re: importing tables.... [message #602737 is a reply to message #602733] |
Sun, 08 December 2013 05:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
martijn
Messages: 286 Registered: December 2006 Location: Netherlands
|
Senior Member |
|
|
Maybe you can show us exactly what you are doing (cut and paste from the command line)
As Cookiemonster suggested, if you get "Import terminated successfully without warnings" then I would suspect that there is no data in the export. What does the export log say? Are rows actually exported?
|
|
|
Re: importing tables.... [message #602744 is a reply to message #602733] |
Sun, 08 December 2013 05:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Perhaps there was something wrong with your import command. For example, your keyboard appears to insert multiple ",,,," characters in odd places.
|
|
|
Re: importing tables.... [message #602798 is a reply to message #602744] |
Mon, 09 December 2013 03:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gazzag
Messages: 1119 Registered: November 2010 Location: Bedwas, UK
|
Senior Member |
|
|
Copy and paste the entire command session from where you issue the original impdp statement until the error is returned.
|
|
|
Re: importing tables.... [message #602853 is a reply to message #602736] |
Mon, 09 December 2013 12:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
Or it was imported into a different schema.
Unless you know what you are doing with an export and an import, you may not know where things are going.
to see the amount of parameters you can use, of which you listed none that you used.
|
|
|
|
Re: importing tables.... [message #664506 is a reply to message #664485] |
Thu, 20 July 2017 06:38 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/d29f577f753cb4b873212fd5ed0da4cd?s=64&d=mm&r=g) |
EdStevens
Messages: 1376 Registered: September 2013
|
Senior Member |
|
|
amjad_alahdal wrote on Thu, 20 July 2017 01:50Thank You. Problem solved.
So what was the problem? Someone doing a google search might find this thread, and your solution may be helpful.
Never mind. I see now that you are just going back and trying to clean up old threads.
[Updated on: Thu, 20 July 2017 06:48] Report message to a moderator
|
|
|