How do I import an exported file?, I have followed the imp help=y to a T. When I complete the import I receieve the message that I have completed the import successfully, but when I go to the database through sqlplus to view the table I intended to import, it is no where to be found.
I import like this:
imp scott/tiger ignore=y rows=y destroy=n buffer=30000 grants=y
Sigh.....those were the days my friend, I thought they'd never end.
I too remember when this place was coo.
First of all, I'd recommend using a parameter file. That way, you don't have to keep entering all the options on the command line or have to answer the interactive session questions.
Second, use/create a log file of the session. There's a lot of information that scrolls by on the screen. If you had a log file, you could look to see if any of your user's objects were imported, specifically, the tables in this case.
So, given that you say the import was successful, yet there are no tables for your user, I'd guess you exported the wrong objects or used the wrong user. Your export and import parameter files should have userid=scott/tiger@SID.
Click Here to Expand Forum to Full Width