This content has been marked as final. Show 1 reply
Connnect computer(B). If you set up a tnsalias on computer(a) enabling a sqlnet connection, its a bit easier. But if you want a change on (b) you have to.... make the change on (b).
That assumes on (a) you have added a tnsalias for "b" in the tnsnames.ora file, the (SERVER = DEDICATED) line is optional. unless you want to ensure you don't get a shared server connection to b:
$ sqlplus /nolog connect <username>@b ... password ... alter table <tablename> modify ( <column> <column change> );
B = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = [<b hostname>[.myco.com]]|[or b IP address])(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) )