Re: Table created with Oracle Client 9.2 (in 32bit) can't be readen with Oracle10.2 (in 64bit)

Yalta schrieb:
> there is just one database
> Name: tdbha50_storet (somewhere in the company no matter where the
> server phsically is)
> Username: aposto
> Password *****
>
> at computer_1( windows xp professional 32bit with oracle CLIENT 9.2) i
> start Oracle SQL Plus* login in the Database above using the username
> above and command:
>
> SQL> create table env1_xp32_orac92 (NAME VARCHAR2(20), VORNAME
> VARCHAR2(20), GEBURTSTAG DATE, STEUER
> KLASSE INTEGER, KINDER CHAR(1), ANZAHL_KINDER INTEGER, EINKOMMEN
> NUMBER(10,2), STUNDEN REAL);
>
> Table created.
>
> SQL> desc env1_xp32_orac92;
> Name Null? Type
> ----------------------------------------- --------
> ----------------------------
> NAME VARCHAR2(20)
> VORNAME VARCHAR2(20)
> GEBURTSTAG DATE
> STEUERKLASSE NUMBER(38)
> KINDER CHAR(1)
> ANZAHL_KINDER NUMBER(38)
> EINKOMMEN NUMBER(10,2)
> STUNDEN FLOAT(63)
>
> then i go to computer_2 (windows xp professional 64bit with oracle
> CLIENT 10.2), start Oracle SQL Plus*, login in the Database above using
> the username above and command:
>
>
> SQL> desc env1_xp32_orac92;
> ERROR:
> ORA-04043: object env1_xp32_orac92 does not exist
>
>
> the table should me readble from both computer1 e 2!
Yes, it should.
Unfortunately, as user you can't query v$instance. How is the database name resolved?
Do you have a TNS_ADMIN environmant variable set? You should ask your dba about this.

Lots of Greetings!
Volker

-- 
For email replies, please substitute the obvious.