Home » RDBMS Server » Server Utilities » importing tables....
importing tables.... [message #602733] Sun, 08 December 2013 03:57 Go to next message
amjad_alahdal
Messages: 39
Registered: October 2013
Location: Saudi Arabia
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 #602736 is a reply to message #602733] Sun, 08 December 2013 04:57 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you really got "Import terminated successfully without warnings" then the most likely problem is that there is no data in the export.
Re: importing tables.... [message #602737 is a reply to message #602733] Sun, 08 December 2013 05:17 Go to previous messageGo to next message
martijn
Messages: 267
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 messageGo to next message
John Watson
Messages: 4081
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 messageGo to next message
gazzag
Messages: 267
Registered: November 2010
Location: Bristol, 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
joy_division
Messages: 4454
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.
exp help=y
imp help=y

to see the amount of parameters you can use, of which you listed none that you used.
Previous Topic: Services restart during datapump expdp and impdp
Next Topic: ORA-01436 during export on Oracle 8i
Goto Forum:
  


Current Time: Fri Apr 18 05:43:51 CDT 2014

Total time taken to generate the page: 0.08882 seconds