Why does oracle have a seperate data dictionary view v$tempfile for locally managed temporary tablespaces and dba_data_files for everything else?

also when I turn on autoextend on my temporary tablespaces I do not see an 'autoextend' column in v$tempfile? How do I tell if autoextend is turned on a temporary tablespace?


Oracle LazyDBA home page