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?
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?
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.