DB version:10gR2
We have around 60 schemas in one of our databases. We have a table called err_msg_log in all of these schemas.
i need to issue the command
truncate table err_msg_log;
on every schema of this Database. How can i make a script which would connect to each schemas one by one and issue this TRUNCATE command. To make things easier, i've made the password for each schema same as its username(schema name)