Dilli's Oracle/MySQL Linux Blog
Wednesday, June 3, 2015
bash Dynamic array variable name
›
#!/bin/bash # Declaring variables CNT=1 # Declaring dynamic array with space eval "arr_row${CNT}=( \"rajiv maharjan\" ...
Monday, May 25, 2015
Compare Oracle tables with linux md5
›
Comparison between two table with same name in different schema Lets say MEMBERS be the table that need to be compared on schemas SCHEM...
Tuesday, May 19, 2015
DDL trigger that will fire on create table
›
create or replace trigger DDLTrigger AFTER create or drop ON schema declare TRIG_NAME varchar2(32):='TRG_' || ora_dict_obj_name...
Thursday, March 13, 2014
Create Oracle role with Password
›
A role is a set of privileges that can be granted to users or to other roles. We can add privileges to a role and then grant the role to a...
Wednesday, March 12, 2014
ORA-01548: active rollback segment ' SYSSMU13 3758039048$' found, terminate dropping tablespace
›
Error noticed while creating tablespace. 1 create tablespace tbs_moha 2 datafile '/MOHA/oradata/orcl/moha_01.dbf' size 5G ...
Tuesday, March 11, 2014
›
Database or Data Waste. Its worth reading this post. http://www.gplivna.eu/papers/data_waste_or_data_base.htm
‹
›
Home
View web version
