How to drop oracle database

shutdown abort;
startup mount exclusive restrict;
drop database;
exit

Drop all tables in a tablespace

select ‘drop table ‘, table_name, ‘cascade constraints \;’ from user_tables;

How to insert a character in a delimited chain

echo “e_ff_0123_1″ | awk -F_ ‘{print $1″_”$2″_”$3″_0″$4}’