OraFAQ Forum: General » Why did Oracle stray from the column OWNER in DBA

Home » Other » General » Why did Oracle stray from the column OWNER in DBA_SEQUENCES?

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

Why did Oracle stray from the column OWNER in DBA_SEQUENCES? [message #267770]

Fri, 14 September 2007 14:57

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Did anyone ever wonder why almost all "owner" columns of the DBA_% tables are named OWNER (eg. DBA_TABLES, DBA_TRIGGERS, DBA_DIRECTORIES, etc.) yet for DBA_SEQUENCES they called it SEQUENCE_OWNER?

Did you ever have a slow day?

[Updated on: Fri, 14 September 2007 15:00]

Report message to a moderator

Re: Why did Oracle stray from the column OWNER in DBA_SEQUENCES? [message #267803 is a reply to message #267770]

Sat, 15 September 2007 01:20

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Another developer...

Why OWNER in DBA_TABLES and DBA_PART_TABLES, and TABLE_OWNER in DBA_TAB_PARTITIONS?...

Why DBA_TAB_PRIVS when it should be DBA_OBJ_PRIVS?...

Regards
Michel

Report message to a moderator

Re: Why did Oracle stray from the column OWNER in DBA_SEQUENCES? [message #267825 is a reply to message #267803]

Sat, 15 September 2007 07:36

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Another....

Why TABLE_OWNER and TABLE_NAME in DBA_SYNONYMS, when it should be OBJECT_OWNER and OBJECT_NAEME?

By
Vamsi

Report message to a moderator

Re: Why did Oracle stray from the column OWNER in DBA_SEQUENCES? [message #267828 is a reply to message #267825]

Sat, 15 September 2007 07:50

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And why there is no OBJECT_TYPE in this view?

Regards
Michel

[Updated on: Sat, 15 September 2007 07:50]

Report message to a moderator

Previous Topic:	Create a Table from .csv File
Next Topic:	general

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 05 21:25:19 CST 2025