Silver_mani Posted July 23, 2013 Report Posted July 23, 2013 evaraina vunte naaku PM cheyyandi ...thanks in advance ...
SUbba LIngam Posted July 23, 2013 Report Posted July 23, 2013 naku kuda oka question undi - Can we create/rename a table on a different database using a dblink ??
peru_edaite_enti Posted July 23, 2013 Report Posted July 23, 2013 [quote name='SUbba LIngam' timestamp='1374615302' post='1304000685'] naku kuda oka question undi - Can we create/rename a table on a different database using a dblink ?? [/quote] Yes u can.. Create table as select @ dblink (ctas) to u can do
SUbba LIngam Posted July 23, 2013 Report Posted July 23, 2013 [quote name='CBZ' timestamp='1374616902' post='1304000801'] Yes u can.. Create table as select @ dblink (ctas) to u can do [/quote] Create table tabllename@dblink ( Col1 varchar Col2 varchar ) ila try chesa bhai inthakumundu, but error vastunde,,,,,,,, DDL operations cannot be performed on a remote database ani anduke adigaa
MeetFriendz Posted July 23, 2013 Report Posted July 23, 2013 [url="http://www.dbasupport.com/forums/showthread.php?34417-creating-table-on-a-remote-database"]http://www.dbasupport.com/forums/showthread.php?34417-creating-table-on-a-remote-database[/url] this link should be helpful to create table remotely.
Piscop Posted July 23, 2013 Report Posted July 23, 2013 [quote name='loser' timestamp='1374614976' post='1304000661'] boy ki pettu ltt [/quote] [img]http://2.bp.blogspot.com/-7FO16-Db_pQ/UYflFPxRf8I/AAAAAAAAEhE/8RDNSTcMd98/s1600/firefires.gif[/img]
SUbba LIngam Posted July 23, 2013 Report Posted July 23, 2013 [quote name='MeetFriendz' timestamp='1374619235' post='1304001001'] [url="http://www.dbasupport.com/forums/showthread.php?34417-creating-table-on-a-remote-database"]http://www.dbasuppor...remote-database[/url] this link should be helpful to create table remotely. [/quote] ayithe idi naa paridhi lo ledu, DBA ki escalate cheyadame thanks !
peru_edaite_enti Posted July 23, 2013 Report Posted July 23, 2013 [quote name='SUbba LIngam' timestamp='1374619392' post='1304001014'] ayithe idi naa paridhi lo ledu, DBA ki escalate cheyadame thanks ! [/quote] mari dba's ki kuda pani undali kada vayya.. anni meere chesesukunte vallu enduku nen annadi CTAS, nuvvu cheppindi db link to vere db lo create cheyatam.. dani kanna direct ga a DB loke login aiyi cheyochu kada.. why do you want to create it over the network?
SUbba LIngam Posted July 23, 2013 Report Posted July 23, 2013 [quote name='CBZ' timestamp='1374619679' post='1304001040'] mari dba's ki kuda pani undali kada vayya.. anni meere chesesukunte vallu enduku nen annadi CTAS, nuvvu cheppindi db link to vere db lo create cheyatam.. dani kanna direct ga a DB loke login aiyi cheyochu kada.. why do you want to create it over the network? [/quote] aa DB ki access ledu bhai, dblink ki access ivvandira antene vaaram rojulu teesukunnaru vedhavalu,,,,,,,,,,, so anduke nene create cheddam ani try chestunna.
peru_edaite_enti Posted July 23, 2013 Report Posted July 23, 2013 [quote name='SUbba LIngam' timestamp='1374620046' post='1304001075'] aa DB ki access ledu bhai, dblink ki access ivvandira antene vaaram rojulu teesukunnaru vedhavalu,,,,,,,,,,, so anduke nene create cheddam ani try chestunna. [/quote] oka ticket raise sesi padeyi.,. valle chestaru
SUbba LIngam Posted July 23, 2013 Report Posted July 23, 2013 [quote name='CBZ' timestamp='1374620204' post='1304001089'] oka ticket raise sesi padeyi.,. valle chestaru [/quote] tickets raise cheyadam lantivi em levu bhai ikkada, maa company lo em cheyalanna team lead ki cheppi manager ki mail pedithe, maa manager gadu DBA team tho contact avutadu,,,,,,,, idi jarigesariki inkoka vaaram rojulu pattuddii,,,,,,,,,,, federal clients ante endo anukunna, lol
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts