DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: export/import

Hybrid View

  1. #1
    Join Date
    Aug 2003
    Location
    Virginia
    Posts
    392

    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.


  2. #2
    Join Date
    May 2002
    Posts
    2,645
    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
  •  


Click Here to Expand Forum to Full Width