select * from tab

From: Raja sekar <rduraich_at_supersolution.com>
Date: 1997/09/12
Message-ID: <3419A6B2.B24@supersolution.com>

My query returns
SQL> select * from tab where tname like 'PO%INTERFACE%' SQL> /

TNAME                          		TABTYPE   	CLUSTERID                                                  
------------------------------ 		--------- 		---------                                                  
PO_DISTRIBUTIONS_INTERFACE    	 TABLE                                                                
PO_DISTRIBUTIONS_INTERFACE_S  	SEQUENCE                                                             
PO_HEADERS_INTERFACE           	TABLE                                                                
PO_HEADERS_INTERFACE_S        	 SEQUENCE                                                             
PO_INTERFACE_ERRORS          	  TABLE                                                                
PO_INTERFACE_ERRORS_N1        	 INDEX                                                                
PO_INTERFACE_ERRORS_S         	 SEQUENCE                                                             
PO_LINES_INTERFACE            	 TABLE                                                                
PO_LINES_INTERFACE_S          	 SEQUENCE                                                             
PO_REQUISITIONS_INTERFACE_ALL 	 TABLE                                                                
PO_REQUISITIONS_INTERFACE_N1  	 INDEX                                                                
PO_REQUISITIONS_INTERFACE_N2  	 INDEX                                                                
PO_REQUISITIONS_INTERFACE_N3  	 INDEX                                                                
PO_REQUISITIONS_INTERFACE_N4  	 INDEX                                                                
PO_REQUISITIONS_INTERFACE_N5  	 INDEX                                                                
PO_REQUISITIONS_INTERFACE_N6  	 INDEX                                                                
PO_REQUISITIONS_INTERFACE_S 	 SEQUENCE                                                             
PO_REQUISITIONS_INTERFACE_U1 	 INDEX                                                                
PO_RESCHEDULE_INTERFACE       	TABLE                                                                
PO_RESCHEDULE_INTERFACE_N1   	 INDEX                                                                

20 rows selected.

I was not expecting to see tabtype other than 'TABLE', 'CLUSTER', 'VIEW', 'SYNONYM'. Could you explain

The content of the script in $ORACLE_HOME/rdbms/admin/catprc.sql between line numbers 839 and 1282 , is indicating to the various sys.obj$.type. They are 0 to 12.
remark
remark FAMILY "DEPENDENCIES"
remark Dependencies between database objects remark

create or replace view USER_DEPENDENCIES                                                                                     
       

  (NAME, TYPE, REFERENCED_OWNER, REFERENCED_NAME,    REFERENCED_TYPE, REFERENCED_LINK_NAME) as
select o.name,

       decode(o.type, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',
                      4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE',
                      8, 'FUNCTION', 9, 'PACKAGE', 10, 'NON-EXISTENT',
                      11, 'PACKAGE BODY', 12, 'TRIGGER', 'UNDEFINED'),
       decode(po.linkname, null, pu.name, po.remoteowner), po.name,
       decode(po.type, 0, 'NEXT OBJECT', 1, 'INDEX', 2, 'TABLE', 3, 'CLUSTER',
                      4, 'VIEW', 5, 'SYNONYM', 6, 'SEQUENCE', 7, 'PROCEDURE',
                      8, 'FUNCTION', 9, 'PACKAGE', 10, 'NON-EXISTENT',
                      11, 'PACKAGE BODY', 12, 'TRIGGER', 'UNDEFINED'),
       po.linkname

from sys.obj$ o, sys.obj$ po, sys.dependency$ d, sys.user$ pu where o.obj# = d.d_obj#
  and po.obj# = d.p_obj#
  and po.owner# = pu.user#
  and o.owner# = userenv('SCHEMAID')
/

The content of the script in $ORACLE_HOME/rdbms/admin/catalog5.sql between line numbers 573 and 582 is indicating to using the obj$.type between 2 and 5

create or replace view tab

        (tname, tabtype, clusterid) as
   select o.name,

      decode(o.type, 2, 'TABLE', 3, 'CLUSTER',
             4, 'VIEW', 5, 'SYNONYM'), t.tab#

  from sys.tab$ t, sys.obj$ o
   where o.owner# = uid and o.type >= 2 and o.type <=5      and o.obj# = t.obj# (+)
/

grant select on tab to public with grant option;

SQL> select owner,object_name,object_type from all_objects where object_name='TAB' SQL> /

OWNER                          OBJECT_NAME 		OBJECT_TYPE 
------------------------------ ------------------------------  	------------ 	 
SYS                           	      TAB                                  	VIEW                                         
                                                            
PUBLIC                           TAB                                  	SYNONYM                                              
                                                      
SYSTEM                         TAB                                  	SYNONYM 

 Can you solve this problem, please ?

     Thank's in advance

 bye Received on Fri Sep 12 1997 - 00:00:00 CDT