Home » RDBMS Server » Server Utilities » importing tables....
importing tables.... [message #602733] Sun, 08 December 2013 03:57 Go to next message
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 #602736 is a reply to message #602733] Sun, 08 December 2013 04:57 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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: 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 messageGo to next message
John Watson
Messages: 8922
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: 1118
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 messageGo to next message
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.
exp help=y
imp help=y

to see the amount of parameters you can use, of which you listed none that you used.
Re: importing tables.... [message #664485 is a reply to message #602853] Thu, 20 July 2017 01:50 Go to previous messageGo to next message
amjad_alahdal
Messages: 102
Registered: October 2013
Location: Saudi Arabia
Senior Member
Thank You. Problem solved.
Re: importing tables.... [message #664506 is a reply to message #664485] Thu, 20 July 2017 06:38 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
amjad_alahdal wrote on Thu, 20 July 2017 01:50
Thank 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

Previous Topic: SQLloader does not load blob
Next Topic: SQL Loader parallel sessions
Goto Forum:
  


Current Time: Thu Mar 28 20:00:01 CDT 2024