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

Thread: Import Error

  1. #1
    Join Date
    May 2006
    Posts
    41

    Import Error

    A dump is created by taking 5 tables export,

    i tried to import those tables as follows,

    Parfile contains,
    ----------------
    file=exp5tab.dmp
    log=imp5tab.log
    buffer=1024000
    fromuser=system
    touser=cw
    commit=y

    $ imp parfile=imp5tab.par

    Import: Release 9.2.0.6.0 - Production on Sat Jun 3 22:00:55 2006

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Username: system
    Password:

    Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.6.0 - Production

    Export file created by EXPORT:V09.02.00 via direct path
    import done in US7ASCII character set and AL16UTF16 NCHAR character set
    Import terminated successfully without warnings.

    ---------------------------------------------------------------------

    In log,nothing about the imported tables is displayed,why it is so?

    Then,i checked the schema(cw),where no tables is created from the dump.


    what type of problem it's?how i've to rectify it?

    Please give me a solution as soon as possible.

    I'm waiting for the reply....

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    why are you trying to put systems objects into another users schema?

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