Home » Other » General » Why did Oracle stray from the column OWNER in DBA_SEQUENCES?
Why did Oracle stray from the column OWNER in DBA_SEQUENCES? [message #267770] Fri, 14 September 2007 14:57 Go to next message
joy_division
Messages: 4640
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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

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 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Another....

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

By
Vamsi
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 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Tue Dec 06 00:29:37 CST 2016

Total time taken to generate the page: 0.09379 seconds