|
-
Oct 2nd, 2019, 03:29 AM
#1
Thread Starter
New Member
vb.net and oracle: How to Create table db2.myTable as select * from db1.myTable
i have two separate machines oracle 11g database servers (db1 and db2), vb.net 2015 installed on my laptop (Tested Connection with both database server. Please guide How to create table db2.myTable as select * from db1.myTable
'''
Dim OraConnStringDB1 As String = "Data Source=" & TextBox1.Text & ":1521/ " & TextBox2.Text & ";User Id=" & TextBox3.Text & " ;Password=" & TextBox4.Text & " ;"
Dim OraConnStringDB2 As String = "Data Source=" & TextBox5.Text & ":1521/ " & TextBox6.Text & ";User Id=" & TextBox7.Text & " ;Password=" & TextBox8.Text & " ;"
Dim OraConnDB1 As New OracleConnection(OraConnStringDB1)
Dim OraConnDB2 As New OracleConnection(OraConnStringDB2)
OraConnDB1.Open()
OraConnDB2.Open()
Dim cmd As New OracleCommand
cmd.Connection = OraConnDB1
''' Any thing to do i.e create table OraConnDB2.myTable as select * from OraConnDB1.myTable;
-----
-----
'''
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|