-
export/import
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
Thanks.
Rick
Rick
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|