What are the SEQ$ and OBJ$ tables?

From: BEERYR <Ron.Beery_at_DaytonOH.ATTGIS.COM>
Date: 1996/06/24
Message-ID: <DtIovw.ItK_at_ranger.daytonoh.ncr.com>#1/1


I'm running the Oracle Financials application 10.4.2 running on Oracle 7.1.3.

In my stats of frequently run sql statements, the following keep comming up. What is the seq$, obj$, and user$ tables? What are they used for?

update seq$              
  set increment$=:2,     
      minvalue=:3,       
      maxvalue=:4,       
      cycle=:5,          
      order$=:6,         
      cache=:7,          
      highwater=:8,      
      audit$=:9          
  where obj#=:1          
                         
                         

select o.name, u.name
  from obj$ o, user$ u

 where obj# = :1     and 
       o.owner# = u.user#


Ron Beery
NCR
"Everything is computerized. What could possibly go wrong?" Received on Mon Jun 24 1996 - 00:00:00 CEST

Original text of this message