Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2003
    Posts
    53

    Unanswered: Error using dblink

    I am testing an insert statement and found the following error:
    ERROR at line 39:
    ORA-01732: data manipulation operation not legal on this view


    My statement is:
    insert into machines(MACH_ID,MACH_NAME,MACH_MTYP_TYPE,MACH_SIT E,EQUIPMENT)
    select MACH_ID,MACH_NAME,MACH_MTYP_TYPE,MACH_SITE,EQUIPME NT
    from machines@dblink.link.com
    where mach_mtyp_type='SYSTEM';

    the column that ihave selected are all primary leys so i should have included all relevant things.
    pls help

  2. #2
    Join Date
    Nov 2003
    Posts
    53
    ya i got it already, its a view..thanx anyway

  3. #3
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    You are using an INSERT statement on a view that might 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. INSERT rows in the base tables instead and restrict the operations on the view to queries.
    SATHISH .

  4. #4
    Join Date
    Nov 2003
    Posts
    53
    ok guys the table wa actually a view...ok thanx anyway...

  5. #5
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: Error using dblink

    Originally posted by Daven81
    I am testing an insert statement and found the following error:
    ERROR at line 39:
    ORA-01732: data manipulation operation not legal on this view


    My statement is:
    insert into machines(MACH_ID,MACH_NAME,MACH_MTYP_TYPE,MACH_SIT E,EQUIPMENT)
    select MACH_ID,MACH_NAME,MACH_MTYP_TYPE,MACH_SITE,EQUIPME NT
    from machines@dblink.link.com
    where mach_mtyp_type='SYSTEM';

    the column that ihave selected are all primary leys so i should have included all relevant things.
    pls help
    Is "machines" an table or view?
    If "machines" is view then this view is not updatable.

  6. #6
    Join Date
    Nov 2003
    Posts
    53
    yeah its a view..
    thanx satish_ct and ika...

Posting Permissions

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