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

Yalta wrote:
> Hello,
> i have a oracle 10.2 database called tdbha50_storet which i am testing
> from two different oracle enviroments:
> env_1: windows xp professional 32bit with oracle client 9.2
> env_2: virtual env running windows xp professional 64bit with oracle
> client 10.2
>
> I realised that the data i create in one env can't be readen from the
> other env.
>
> For instance:
> -- i create in env_1 the table env1_xp32_orac92 with Oracle SQL Plus*
> and commited. the desc command show me than the structure of this
> table;
>
> -- in env_2, i type into Oracle SQL Plus* desc env1_xp32_orac92 and get
> ERROR:
> ORA-04043: object env1_xp32_orac92 does not exist
>
> I am working too much or is that a fact?
>
> Any help will be more than appreciated and save me plenty of time.
>
> Regards,
> Yalta

A brief test:
Session 1: Oracle 10.2.0.1 client:
CREATE TABLE TABLE_1 (ANIMAL VARCHAR2(15)); (note that a COMMIT is not necessary)

Session 2: Oracle 10.2.0.1 client:
SQL> DESC TABLE_1
ERROR:
ORA-04043: object TABLE_1 does not exist

I connected with a different user name, so I guess that was expected.

SQL> DESC SCHEMA_1.TABLE_1
ERROR:
ORA-04043: object SCHEMA_1.TABLE_1 does not exist

That did not work either - Session 1 created the table in a different database located on the same server, try again after connecting to the correct database (this was intentional for this test case).

SQL> DESC TABLE_1
ERROR:
ORA-04043: object TABLE_1 does not exist

I connected with a different user name, so I guess that was expected.

SQL> DESC SCHEMA_1.TABLE_1

 Name                                      Null?    Type
 ----------------------------------------- -------- -------------
 ANIMAL                                             VARCHAR2(15)

Session 3: Oracle 10.2.0.2 64 bit client: SQL> DESC SCHEMA_1.TABLE_1

 Name                                      Null?    Type
 ----------------------------------------- -------- -------------
 ANIMAL                                             VARCHAR2(15)

Does the table show in the ALL_TABLES, DBA_TABLES, or DBA_OBJECTS views? Are you connected to the same database in both cases and using the same user name? Even though you may appear to be connecting to the same database, a change in the tnsnames.ora file on the client can actually cause a connection to take place to a different database.

Try this on both clients:
SELECT
  INSTANCE_NAME,
  HOST_NAME,
  VERSION,
  STARTUP_TIME
FROM
  V$INSTANCE; Do you see the same information when queried from both clients?

If you execute this SQL statement on one client: SELECT DISTINCT
  SID
FROM
  V$MYSTAT; And then this one (assuming that SID in the above was 220): SELECT
  SID,
  SERIAL#,
  USERNAME,
  PROGRAM
FROM
  V$SESSION
WHERE
  SID=220; And then execute the second SQL statement above on the second session, do you see the same values?

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Tue Dec 05 2006 - 08:45:01 CST