Conference orarep::nomahs::dbstars

741.0. "ORA-01445 restriction lifted in V7.0/ sent to mary" by BROKE::BASTINE () Thu Jan 30 1997 12:22

Copyright (c) 1996 by Oracle Corporation.  All Rights Reserved.

KEYWORDS: Rdb  OpenVMS  ROWID ORA-01445 Oracle View

TITLE:    LDRV-E-ORA_DB_SUPP, ORA-01445 Cannot Select ROWID from View

PRODUCT:  RDB Transparent Gateway for Oracle V7.0

OP/SYS:   OpenVMS VAX V5.5 and higher

SOURCE:   Oracle Worldwide Customer Support


SYMPTOM:

You attempt to access an Oracle view from the gateway and see the following 
error:

%RDB-F-IO_ERROR, input or output error                                      
 -LDRV-E-ORA_DB_SUPP, ORA-01445: cannot select rowid from view of more than
                                 one table   



RESPONSE:

Prior to V7.0 of the gateway, this was a restriction.  It was documented in
the Oracle Gateway release notes as:

"Oracle does not assign rowids (dbkeys) to a view composed of multiple tables.
If you attempt to select a dbkey from that view, the following error occurs:

%RDB-F-IO_ERROR, input or output error      
  -LDRV-E-ORA_DB_SUPP, ORA-01445: cannot select rowid from view of more than 
					one table   

WORKAROUND:

Starting in V7.0 of the RDB Transparent Gateway for oracle, there is now
a workaround for this restriction.  If you specify the table on the attach
statement along with the /DBKEY=NON_FUNC, the dbkeys will not be used and you
will be able to select data from the Oracle view that contains more than one
table.

Your attach string may look like this:

attach 'file/type=oracle/node=server/user=username/pass=password -
	/tx_mode=nowarn_1pc/tables=(table_name/dbkey=non_func)';

ENGINEERING RESPONSE:

The use of /DBKEY=NON_FUNC has now lifted the restriction documented in the
V3.* release notes.


\
\ CONTRIBUTORS:
\
\	Technical: Renee Bastine
\	Editorial: