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: 4758
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: 65079
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: 2108
Registered: October 2003
Location: Hyderabad, India
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: 65079
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: Thu Jul 20 21:53:20 CDT 2017

Total time taken to generate the page: 0.22254 seconds