I have created the below shell script to disable triggers on a particualr schema.
This works fine in one environemnt. It disables triggers and also shows the output on the putty console, using which I am connecting to the Solaris box. But on another environment it just returns without giving any output. Can someone please help and let me know what could be the reason.
I even tried putting incorrect user/password in the script, hoping it would give an error but it just returns without giving any output.
echo "select 'ALTER TABLE' , table_name, 'DISABLE ALL TRIGGERS;' from user_tables;" | sqlplus -S user/passowrd460@dbserver | \
grep "ALTER TABLE" | sqlplus -S user/password@dbserver