Trouble in creating Types and instead of trigger in oracle 8.0.5
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Trouble in creating Types and instead of trigger in oracle 8.0.5

  1. #1
    Join Date
    Dec 2001
    Location
    Saudi Arabia
    Posts
    1
    I exported a database in Oracle 8.0.3, When I imported it to Oracle 8.0.5 Object types and Instead of triggers did not get imported.
    I could not even create those two. Any help?

  2. #2
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282

    Lightbulb


    Does Oracle 8.0.5 you imported have the 'Object Option''
    installed? Launch SQL*Plus and check if 'With Object Option' appears on the top of the screen. Without it object types don`t work.

    F.


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