Re: Help !!!!!! SQL*Net Newbie

Ong Boo Huat wrote:

> case 1:
> when i use "connect h/m _at_T:PAS01", i can execute "select * from
> user_tables" and retrieve the info.

In this case you use the SQL*Plus command connect (not a SQL-command !) The string after _at_ has to be a database-connect string, which is 1. A valid SQL*NET version 1 connect-String (your case) or
2. A valid SQL*NET Version 2 alias (defined in TNSNAMES.ORA or
3. Another alias found in TNSNAMES.ORA or/and for PC in ORACLE.INI prefixed with SQLNET DBNAME xxxx = which evaluates to a connect-string described in 1. or 2.  

> case 2:
> when i use "connect h/m", and execute "select * from
> user_tables_at_PAS01;", i can't get anything, and Oracle will respond
> that it cannot contact the re

in this case you use a SQL-select command. Here the string after _at_ has to be a valid database link in your database to which you are currently connected.

So the solution for you is to create a DB-Link and use it. CREATE DATABASE LINK PAS01 connect to .... identified by... using '_at_T:PAS01';
select * ..... from user_tables_at_PAS01;

.... and it should work

   Juergen Brunner

   Robert Bosch GmbH	       
   Abt. QI/LBS2-Rt	       
   Anwendungssysteme	       E-Mail      : juergen.brunner_at_rt.bosch.de

========================================================================