Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

renaming a trigger

Pavan DBAJul 25 2007 — edited Jul 25 2007

Hi gurus,

i am having 4 databases of which 2 are in oracle8i and other 2 in oracle9i.

i am having same tables and triggers in all the four databases.
when i am trying to rename the triggers in all the four databases, i am successful in both 9i databases. but for 8i i am getting problem.

i am getting following error "ora-00922:missing or invalid option"

i want to know why it happend. did oracle8i doesn't support for trigger renaming?

plz help me

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 22 2007

Added on Jul 25 2007

#general-database-discussions

1 comment

206 views