| importing tables.... [message #602733] |
Sun, 08 December 2013 03:57  |
 |
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  |
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 |
John Watson
Messages: 8962
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 |
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 |
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 |
 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
