Results 1 to 3 of 3

Thread: Import Problems

  1. #1
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    31

    Unanswered: Import Problems

    Hi, I'm trying to import a .dmp file into a blank database.

    my command is: imp mgr@SID_Host fromuser=**** touser=sys log="mylog.log"

    I got this message:
    Connected to: Oracle8i Release 8.1.7.0.0 - Production
    JServer Release 8.1.7.0.0 - Production

    Export file created by EXPORT:V08.01.07 via conventional path

    Warning: the objects were exported by ****, not by you

    import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
    . . importing table "table1" 451 rows imported
    . . importing table "table2" 2290 rows imported
    . . importing table "table3" 2387 rows imported
    . . importing table "table4" 338 rows imported
    . . importing table "table5" 433 rows imported
    . . importing table "table6" 44 rows imported
    .....
    . . importing table "tablen" 0 rows imported
    About to enable constraints...
    Import terminated successfully with warnings.

    C:\oracle\ora81\BIN>


    My problem is that when I tried to query a table or "desc table" using SQLPlus, I end up with a "OBJECT table1 does not exist" error. The import says that I have imported the tables, but I can't access them.

    Does anyone know what I did wrong? How do I have to change the character set to my new database?

    Thanks

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    You imported into SYS (not recommended).

    I imagine you did not log in as the SYS username so naturally you cannot see it's objects.

    Import into the schema you will be logging in as.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    31
    Hi, thanks for your reply.

    I see the data now.....I added "full=y" to the command and it works!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •