SYS.SEG$ is a special table:
select * from sys.bootstrap$ where sql_text like '% SEG$%';
that is created at startup
On Tue, Nov 10, 2015 at 7:20 PM, Bajwa, Sandeep <ssb14@xxxxxxxx> wrote:
Does this oracle internal table needs to have 0 as a Ini_Trans?
SQL> select table_name,ini_trans from dba_tables
2 where table_name in (select object_name from v$segment_statistics
where upper(statistic_name) like '%ITL%' and value > 0)
3 /
TABLE_NAME INI_TRANS
------------------------------ ----------
SEG$ 0
Thanks,
Sandeep
