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

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!

sybrandb schrieb:

> Yalta wrote:
> > Hello Everyone, thanks for the answers, i will test your suggestions. I
> > rewrote the text as i think i was missunderstood.. Please take a look
> > again...
> >
> > Yalta schrieb:
> >
> > Hello,
> > i have a oracle 10.2 database called tdbha50_storet which i am testing
> > from two different computers:
> > comp_1: windows xp professional 32bit with oracle CLIENT 9.2
> > comp_2: running windows xp professional 64bit with oracle CLIENT 10.2
> >
> > I realised that the table i create in the database using comp_1 can't
> > be readen from the
> > other comp_2 and vice-vers.
> >
> > For instance:
> > -- from comp_1i connect with tdbha50_storet and create the table
> > env1_xp32_orac92 with Oracle SQL Plus* and commited. the desc command
> > show me than the structure of this
> > table;
> >
> > -- from comp_2 i connect with tdbha50_storet, type into Oracle SQL
> > Plus* desc env1_xp32_orac92 and get ERROR: ORA-04043: object
> > env1_xp32_orac92 does not exist
> >
> > So my question is: why can't i see in comp_2 the table i created from
> > comp_1?
> >
> > Regards,
> > Yalta
>
> Please provide *EXACT* connection strings, and the *EXACT* commands you
> typed to connect, *INCLUDING* the username.
> This is because generally speaking your assertion
>
> 'I realised that the table i create in the database using comp_1 can't
> be readen from the
> other comp_2 and vice-vers.'
> is just blatant and utter nonsense!!
>
>
> It is *YOU* who is doing something wrong, and who is trying to annoy
> this forum submitting *Riddles* only you can resolve because you don't
> provide *EXACT* information, and are calling for crystal balls, which
> have worn out.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Tue Dec 05 2006 - 10:44:14 CST