OraFAQ Forum: Server Administration » Difference Magerly between Cat and Tab

Home » RDBMS Server » Server Administration » Difference Magerly between Cat and Tab

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Difference Magerly between Cat and Tab [message #144635]

Thu, 27 October 2005 08:49

kadedadba
Messages: 2
Registered: October 2005
Location: mumbai

Junior Member

wha tis the Diffrence between
"select * from cat" , "select * from tab"
i am new to dba consept
can any body give idea with examp[le

Report message to a moderator

Re: Difference Magerly between Cat and Tab [message #144636 is a reply to message #144635]

Thu, 27 October 2005 08:54

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

You can lookup the meaning of these views in the Oracle Server Reference Guide. For example:

"CAT is a synonym for USER_CATALOG."

"TAB is included for compatibility. Oracle recommends that you do not use this view."

Best regards.

Frank

Report message to a moderator

Re: Difference Magerly between Cat and Tab [message #144640 is a reply to message #144636]

Thu, 27 October 2005 09:12

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

To add what Frank has said,
Consider TAB as a 'handy' description of all TABLE like objects like tables,views and synonyms
and
CAT is the catalog of other objects included.

scott@9i > select * from tab;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
DD                             TABLE
DEPT                           TABLE
EMP                            TABLE
EMPLOYEE                       SYNONYM
MYVIEW                         VIEW

scott@9i > select * from cat;

TABLE_NAME                     TABLE_TYPE
------------------------------ -----------
DD                             TABLE
DEPT                           TABLE
EMP                            TABLE
EMPLOYEE                       SYNONYM
MYSEQ                          SEQUENCE
MYVIEW                         VIEW

6 rows selected.

Report message to a moderator

Previous Topic:	Setting up a DB link between servers and creating synonyms
Next Topic:	How to migrate Oracle 8i to 10G on solaris

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 12:28:27 CST 2025