Author |
Message |
Pudingi
Pilla Bewarse Username: Pudingi
Post Number: 123 Registered: 08-2005 Posted From: 80.121.144.9
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 9:26 am: | |
mama i use to write dlls until 2004 mama..from past one year i am using.net frame work... nee vc++ loo rasthnau mama ..yeah mama Stored procs use cheesetodini.... I never used ASP...adi yeppudoo MS loo vunnappudu veere IT course vallaku help cheshtu nerchukunna back in 2000 mama... |
Fuhrer
Kurra Bewarse Username: Fuhrer
Post Number: 713 Registered: 07-2005 Posted From: 129.188.33.221
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 9:08 am: | |
mekenti mama bill gates vunnantha kalam baga chusukuntadu.. kikiki migatha vallam memu nelako tool nerchukovali... hehe |
Fuhrer
Kurra Bewarse Username: Fuhrer
Post Number: 712 Registered: 07-2005 Posted From: 129.188.33.221
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 9:07 am: | |
denilo rasthavu mama VB na leka VC++ na.. mama DLL lo nunchi DB ki connect ayyi SQL statements execute chesthara... leka just SPs ni call chesthara... mama meeru DDL rasthey... ASP coder dani lo methods ni chall chesthadu ganda.. ouna |
Pudingi
Pilla Bewarse Username: Pudingi
Post Number: 120 Registered: 08-2005 Posted From: 80.121.144.9
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 9:02 am: | |
aaayyyy... |
Fuhrer
Kurra Bewarse Username: Fuhrer
Post Number: 710 Registered: 07-2005 Posted From: 129.188.33.221
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 9:00 am: | |
ASP kada... ayithey enti mama.. DLLs rasthava |
Pudingi
Pilla Bewarse Username: Pudingi
Post Number: 119 Registered: 08-2005 Posted From: 80.121.144.9
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:57 am: | |
yeah but asp side kadhu mama.. sorry mayya vundhi nijamee...nenu yeppudu cheyyalee ledheemo anukunna...; |
Fuhrer
Kurra Bewarse Username: Fuhrer
Post Number: 709 Registered: 07-2005 Posted From: 129.188.33.221
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:55 am: | |
4000 anukunta |
Fuhrer
Kurra Bewarse Username: Fuhrer
Post Number: 708 Registered: 07-2005 Posted From: 129.188.33.221
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:50 am: | |
mama.. delete from <table> vundi ganda.. mayya .NET lo workingaaa |
Pudingi
Pilla Bewarse Username: Pudingi
Post Number: 118 Registered: 08-2005 Posted From: 80.121.144.9
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:49 am: | |
varchar2 max size yentha mamalu...monneppudo kanuukuni septhannai maa voodiki seppalee.. |
Pudingi
Pilla Bewarse Username: Pudingi
Post Number: 117 Registered: 08-2005 Posted From: 80.121.144.9
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:48 am: | |
delete from table ane stmt vuntadhaa..with out where .. |
Fuhrer
Kurra Bewarse Username: Fuhrer
Post Number: 707 Registered: 07-2005 Posted From: 129.188.33.221
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:44 am: | |
ok mama |
Megamama
Vooriki Bewarse Username: Megamama
Post Number: 5559 Registered: 07-2004 Posted From: 192.88.212.39
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:40 am: | |
hmmm I agree ..but just a suggestion always use delete for better results (even though its time consuming in your case) |
Fuhrer
Kurra Bewarse Username: Fuhrer
Post Number: 705 Registered: 07-2005 Posted From: 129.188.33.221
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:39 am: | |
thanks for your valuable suggestions... ice vesthunna anukoku.. kikiki |
Fuhrer
Kurra Bewarse Username: Fuhrer
Post Number: 704 Registered: 07-2005 Posted From: 129.188.33.221
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:38 am: | |
ha correcte MM mama idi kuda... inko doubt naku... delete from table and delete from table where PK = <value> pain rentiki time lo theda vuntundi gada... 1. Just one shot lo delete ayyiddi 2. Enni value vunte anni sarlu delete execute ayyiddi gada... naku 2nd option work ayyiddi.. 1st option work kadu... so 1&2 ki chala difference vundiddikada time taken lo.. |
Fuhrer
Kurra Bewarse Username: Fuhrer
Post Number: 703 Registered: 07-2005 Posted From: 129.188.33.221
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:35 am: | |
ETL(Extract, Transform, Load) tool mama... ippudu DWH ani vachhindi kada... aa centrlized repository loki data load cheyyataniki ee tool use chestharu... idi chala sources ni support chesiddi.. pani leni mangalodu pilli thala gorikadu antaruga aa type lo idi... kurchoni sources ni import chesi vatini target map chesi madhyalo business logic irikinchi run chesthey aa table/file lonchi data target loki velliddi... |
Megamama
Vooriki Bewarse Username: Megamama
Post Number: 5558 Registered: 07-2004 Posted From: 192.88.212.39
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:35 am: | |
Furher maama here is the clarification: DELETE:- THIS ALWAYS WORKS with a "COMMIT" command means when you DELETE the records..still the deleted records are stored in buffer though the table space is cleaned up...neeku kaavalante you can "ROLLBACK" at any point of time ..ORACLE ALWAYS SUGGESTS YOU USE DELETE even when you are issuing the command from informatica or from any oracle layered tools. TRUANCATE:- This just removes records ONCE FOR ALL and THE TABLE SPACE at a single shot and YOU HAVE NO OPTIONS TO ROLL BACK..idi maama sangathi PS: neev cheptunnattu time difference em undadu maama practically unless you table is linked with many childs..with my experience i can say that TRUNCATE takes more time than DELETE. adi maama .. |
Pudingi
Pilla Bewarse Username: Pudingi
Post Number: 116 Registered: 08-2005 Posted From: 80.121.144.9
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:31 am: | |
informatica....yentadi..??? naaku kooda same to same avakaya mama lagee normal rdbms gurunchi thaputhee ivanni thelvadu.. |
Fuhrer
Kurra Bewarse Username: Fuhrer
Post Number: 702 Registered: 07-2005 Posted From: 129.188.33.221
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:30 am: | |
neevu cheppinde correcte mama... i think it is always better to disable constraints whenever we are deleting rows from a table even though the cascade on delete option is in place... sare mama thanks... ayina nenu work chesedi OLAP applications mama.. so OLTP rules ni anthaga follow kanakkarledu anukunta... |
Fuhrer
Kurra Bewarse Username: Fuhrer
Post Number: 701 Registered: 07-2005 Posted From: 129.188.33.221
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:26 am: | |
MM correcte mama.. huge volumes of data vuntey yem chestham.. truncate chestham ganda... am issuing the truncate command through informatica mama.. Ofcourse, informatica provides option to delete the rows based on a primary key... but it is time consuming taking into the account the number of rows to be deleted... anduke truncate use chestham ... and sometimes, my table may not have a primary key for the informatica to identify each row and delete them... sare mama naku oka 1 million rows vunnayanuko table lo.. what do you suggest me to delete or truncate them... delete ayithey chala time paduthundi ganda.. ade truncate fast.... |
Pudingi
Pilla Bewarse Username: Pudingi
Post Number: 113 Registered: 08-2005 Posted From: 80.121.144.9
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:12 am: | |
>>on delete casacde option tho parent table lonchi delete chesthey child kuda pothayi gada i think its true... |
Megamama
Vooriki Bewarse Username: Megamama
Post Number: 5557 Registered: 07-2004 Posted From: 192.88.212.39
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:11 am: | |
Mamu never use truncate in oracle ..its bad way of removing the records .. the only thing is delete the records.. always make sure u create a synonym and purge data into that table as a backup(can use if the data gets corrupted)..then remove constraints on the tables where you wanna delete the data...do your deletions and apply contraints.. VERY IMP: make sure you complie all the objects within that schema/DB before using the data ..else there is every chance that the data getting corrupted.. inka etanna doubts unte seppu naaku telsina koosintha claripy chestha -MM |
Fuhrer
Kurra Bewarse Username: Fuhrer
Post Number: 700 Registered: 07-2005 Posted From: 144.189.40.222
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 8:06 am: | |
MM mama.. adi kadu mama... naa exact question enti ante... on delete casacde option tho parent table lonchi delete chesthey child kuda pothayi gada... aa option truncate tho work ayyidda ani.. sarele last ki aa option vunna lepoyina truncate work kadu ani samajh ayyindi foreing key constraints vunte.. |
Megamama
Vooriki Bewarse Username: Megamama
Post Number: 5556 Registered: 07-2004 Posted From: 192.88.212.39
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 7:49 am: | |
gintha chimple kochen ki thedda.. thalli table meeda constraints unte pilla pook table ni em peekalemu ani telsukovaali..
|
Aavakaaya
Bewarse Username: Aavakaaya
Post Number: 1385 Registered: 04-2004 Posted From: 195.220.151.50
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 7:33 am: | |
Nenu RDBMS specialist ni emi kaanu...but i think we cannot truncate objects that have child tables, first we may need to delete the foriegn key and then truncate the parent table and then put the foriegn key back. |
Fuhrer
Kurra Bewarse Username: Fuhrer
Post Number: 690 Registered: 07-2005 Posted From: 129.188.33.221
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 6:45 am: | |
hehehe... enu rendu sessions create chesa mama informatica lo master table child table load cheyyataniki... hehe rentini truncate cheyyali load chese mundu... foreign key constraint vundi vati madhyalo... first parent ni truncate chesthunte child table lo references vuntayi ganda.. avi delete avvatla. sare ani on cascade delete clause add chesa constraint ki... appatiki work kala.. so ikkada post chesa.. thruvatha discussion forums lo vethika.. |
Kasakbabu
Desanike Pedda Bewarse Username: Kasakbabu
Post Number: 8219 Registered: 11-2004 Posted From: 202.141.43.24
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 6:42 am: | |
nenu edo kamedy ki postaa...nuvvu deni gurinchi maattaaduthunnaavo koodaa telavadu |
A_n_d_h_r_u_d_u
Pilla Bewarse Username: A_n_d_h_r_u_d_u
Post Number: 72 Registered: 08-2005 Posted From: 69.92.207.138
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 6:41 am: | |
andukeyy BTDB ki raavadam maaneyyy F maamaaa |
Fuhrer
Kurra Bewarse Username: Fuhrer
Post Number: 689 Registered: 07-2005 Posted From: 136.182.2.222
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 6:41 am: | |
mama... discussion forum lo .. edo antunnaru... foreing key constraint vunte truncate cheyyathi kadu ani...danni disable chesi tharuvatha truncate chesi tharuvatha enable cheyyamantunnaru.. thanks mama anyhow |
Fuhrer
Kurra Bewarse Username: Fuhrer
Post Number: 688 Registered: 07-2005 Posted From: 136.182.2.222
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 6:39 am: | |
Can delete any row that will not violate a constraint, while leaving the foreign key as it is Whereas cannot truncate a table with foreign key constraint, so remove that then truncate and then add the foreign key constraint. dorikindile answer discussion forums lo... ammani basics dengayi naku... |
Kasakbabu
Desanike Pedda Bewarse Username: Kasakbabu
Post Number: 8218 Registered: 11-2004 Posted From: 202.141.43.24
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 6:38 am: | |
rendu work avuthaayi |
Fuhrer
Kurra Bewarse Username: Fuhrer
Post Number: 687 Registered: 07-2005 Posted From: 136.182.2.222
Rating: N/A Votes: 0 (Vote!) | Posted on Friday, August 19, 2005 - 6:35 am: | |
babulu... on delete cascade option truncate tho work avuthuna leka only delete thone work ayyidda... parent table ni truncate chesthuntey child table lovi delete kavatla rows.. evaraina thelisini vallu cheppandi |