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

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