Results 1 to 2 of 2

Thread: Import error

  1. #1
    Join Date
    Jun 2010
    Posts
    81

    Unanswered: Import error

    during an import I recieved a number of errors messages similar to the following: Although the import completed successfully

    IMP-00058: ORACLE error 1732 encountered
    ORA-01732: data manipulation operation not legal on this view
    . . importing partition "XDW_SOPH_TEST":"" 0 rows imported
    . . importing partition "XDW_TERMINATION_QUEUE":"" 336 rows imported
    . . importing partition "XDW_TR_STAGE":"" 0 rows imported
    . . importing partition "XDW_TR_TRANSACTION":"" 0 rows imported
    . . importing partition "XDW_HR_TIME":"" 73414 rows imported
    Import terminated successfully with warnings
    .


    I recieved quite a number of errors/warnings similar to this:-

    IMP-00058: ORACLE error 1732 encountered
    ORA-01732: data manipulation operation not legal on this view


    Can someone tell me what this means

    Much appreciated

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    This is what Oracle says:
    Quote Originally Posted by Oracle
    ORA-01732: data manipulation operation not legal on this view

    Cause: An attempt was made to use an UPDATE, INSERT, or DELETE statement on a view that contains expressions or functions or was derived from more than one table. If a join operation was used to create the view or the view contains virtual columns derived from functions or expressions, then the view may only be queried.

    Action: UPDATE, INSERT, or DELETE rows in the base tables instead and restrict the operations on the view to queries.

Posting Permissions

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