| Trigger error [message #50796] |
Mon, 08 April 2002 07:31  |
malliga
Messages: 1
Registered: April 2002
|
Junior Member |
|
|
Dear friends,
Here we are using Oracle 8 database. i tried to create a trigger, the script will be
create trigger ctable
before create on database
begin
statements ;
end ;
/
Oracle throws an error
Invalid type trigger.
I want to monitor the user those who are all creating tables,synononyms,views, etc. or is there any way to monitor.
Pls help me in his regard.
Thanks in advance.
|
|
|
|
| Re: Trigger error [message #50797 is a reply to message #50796] |
Mon, 08 April 2002 07:47  |
saleem
Messages: 65
Registered: January 2002
|
Member |
|
|
|
since the complete syntax is not included i would recommend you check your statement against the 'create trigger' syntax in the oracle documentation to make sure you are writing the trigger properly.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
