[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::dbstars

Title:	DBSTARS Conference

Moderator:	BROKE::BASTINE

Created:	Wed Feb 02 1994
Last Modified:	Thu Jun 05 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	791
Total number of notes:	1521

740.0. "DBI-F-TAB_NO_COLS" by BROKE::GREEN () Thu Jan 30 1997 10:38

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

KEYWORDS: DBI-F-TAB_NO_COLS  Oracle  gateway  attach  

TITLE: Problem attaching to Oracle using Rdb Transparent Gateway for Oracle     

PRODUCT:  Rdb Transparent Gateway for Oracle

OP/SYS:   OpenVMS VAX or OpenVMS AXP

SOURCE:   Oracle Worldwide Customer Support


SYMPTOM: Attaching to an Oracle database using Rdb Transparent Gateway for
         Oracle yields the following error:

         DBI-F-TAB_NO_COLS


WORKAROUND: We've seen this problem when invalid Oracle objects exist and 
            users don't specify specific tables with the /TABLE attach 
            parameter.  In Oracle you can define a view based on a table and
            then drop the table afterwards.  If the orphaned view is accessible
            to the Oracle user specified in /USER then you will see this error.
            The workaround is to specify the exact tables you plan to use on
            the SQL attach using the /TABLE qualifier.



\
\ CONTRIBUTORS:
\
\	Technical: Don Green
\	Editorial: 
\
\

T.R	Title	User	Personal Name	Date	Lines
740.1	New protocol for me	BROKE::GREEN		`Thu Jan 30 1997 10:45`	2
	Unless specified otherwise, any articles I enter in this notesfile have been submitted to Mary Morman.