Hi, I think TAB table (and TABS synonym) are here just for Oracle 5 compatibility. You should use user_tables novadays. Also, I don't use dba_catalog, instead I just query my objects from relevant specific views. I suspect it's there for backwards compatibility reasons as well? Tanel. ----- Original Message ----- From: "sarath kumar" <sarath_kumar0@xxxxxxxxx> > Dear list, > does any one has some detailed info on tab table, when > it is used and how it is created, can i use > user_tables instead of tab? > > also under what circumstances should we use > dba_catalog. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------