osman hömek / not defteri

Sql Server 2005 de birden fazla index’i ve data yogunlugu olan bir tablonun tasariminda degisiklik yapmak istedigimde ( var olan bir varchar alanin büyüklügü degistirildiginde), asagidaki time out hatasi ile karsilastim.
- Unable to modify table. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Cözüm olarak table designer transaction timeout süresini yükseltmek gerekli. Bunun icin, Sql Server Management Studio da;
Tools > Options > Designers > Table and Database Designers

“Transaction time-out after” alaninda default olarak gelen 30 saniyelik degeri yükseltirsek problemin üstesinden gelebiliriz.

TYPES
==================================================================================

CREATE OR REPLACE TYPE “T_EK_CZLG_19_5A_TABLE”
as table of T_EK_CZLG_19_5A_COL

CREATE OR REPLACE TYPE “T_EK_CZLG_19_5A_COL”
as object (
   su_cazibe_1 varchar2(300),
   su_cazibe_2   varchar2(300),
   su_pompaj_3   varchar2(300),
   kurutma_4   varchar2(300)
   )

CREATE OR REPLACE TYPE table_19_5A_ARRAY is VARRAY(5000) OF t_ek_czlg_19_5a_col

FUNCTIONS
==================================================================================

create or replace function get_ek_czlg_19_5A_table(ParamPeriyod in integer)
RETURN table_19_5A_ARRAY AS

l_data table_19_5A_ARRAY := table_19_5A_ARRAY();

cursor c_proje is
  select tblRow1.ad as su_cazibe_1 from
  (select a.id,a.ad from sdb_nesne_degeri a where a.id_nesne_tipi= 502000) tblRow1,
  (select p.id_ust_nesne_degeri,p.deger from sdb_periyodik_veri p where p.id_nesne_degeri=97144 and p.durum=0 and p.periyod=ParamPeriyod) tbl1
  where
  tblRow1.Id = tbl1.id_ust_nesne_degeri(+);

begin

for r1 in c_proje
loop

l_data.extend;
l_data(l_data.count) :=  t_ek_czlg_19_5a_col(r1.su_cazibe_1, ”, ”, ”);

end loop;

return l_data;

end get_ek_czlg_19_5A_table;

SELECT USE
==================================================================================
select * from table(get_ek_czlg_19_5A_table(2005))

static void runsql(string sql, OracleConnection dbconn){

OracleTransaction tran;tran = dbconn.BeginTransaction();

OracleCommand cmd = new OracleCommand();cmd.Connection = dbconn;

{

long rows = cmd.ExecuteNonQuery();tran.Commit();

Console.WriteLine(“islem tamamlandi {0}”, rows + ” satir guncellendi”);}

catch (Exception etc){

Console.WriteLine(“islem tamamlanamadi”);Console.WriteLine(etc.Message.ToString());}

IMP kullanici_adi/parola@SSID file=c:\yedek.dmp fromuser=from_user_name touser=to_user_name

bu komut direkt komut satırında (run command/cmd) satırından çalıştırılmalıdır

buradaki [select_sql] cümleciği ana sql cümleciğidir

içerisinde tüm where ve order işlenmiş haldedir

select * from
(select a.*, ROWNUM RNUM from ([select_sql]) a where ROWNUM<=maxRowIndex)
where
RNUM>=minRowIndex

create or replace
FUNCTION onh_udf(geleind in number)
return varchar2
is
retval varchar2(500);
cursor c1 is select AD FROM tabloX WHERE tabloID=gelenid;
begin
retval := ”;

FOR current_rec in c1
LOOP
retval := retval || ‘,’ || current_rec.ad;
END LOOP;

return retval;
end onh_udf;