OraFAQ Forum: General » Upgrade Your DB!

Home » Other » General » Upgrade Your DB!

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

Upgrade Your DB! [message #603244]

Thu, 12 December 2013 09:34

oraclebabe
Messages: 7
Registered: December 2013

Junior Member

[Mod Edit] Conversation split out from main topic as not relevant to the OP]

Nice query, but unfortunately this construction doesn't work in Oracle 8i.

[Updated on: Thu, 12 December 2013 10:46] by Moderator

Report message to a moderator

Re: Query to find tables/views with cross referencing foreign keys [message #603245 is a reply to message #603244]

Thu, 12 December 2013 09:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

consider joining the 21st Century at your earliest convenience

Report message to a moderator

Re: Query to find tables/views with cross referencing foreign keys [message #603246 is a reply to message #603244]

Thu, 12 December 2013 09:38

oraclebabe
Messages: 7
Registered: December 2013

Junior Member

This query is quite close to what I need...Thanks!
I just need to figure out/understand how to interpret the results :S

Report message to a moderator

Re: Query to find tables/views with cross referencing foreign keys [message #603247 is a reply to message #603245]

Thu, 12 December 2013 09:40

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

BlackSwan wrote on Thu, 12 December 2013 15:36

consider joining the 21st Century at your earliest convenience

Possibly a valid point if OracleBabe has any control whatsoever over what Database the company for which she is working uses. What do you think the odds are on that? What say you OracleBabe, do you have any control over what version of Oracle you have to work with?

Report message to a moderator

Re: Query to find tables/views with cross referencing foreign keys [message #603248 is a reply to message #603247]

Thu, 12 December 2013 09:44

oraclebabe
Messages: 7
Registered: December 2013

Junior Member

I have no control. If I did, I wouldn't be working with 8i.

Report message to a moderator

Re: Query to find tables/views with cross referencing foreign keys [message #603249 is a reply to message #603247]

Thu, 12 December 2013 09:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>(Oracle 8.1.7.4.1, Windows server 2003 R2)
uncertified combination above; since Windows 2003 did not exist when V8 was released.
Somebody chose to run on new hardware & new OS while retaining unsupported & obsoleted DB.
There are costs & benefits with every decision.

Report message to a moderator

Re: Query to find tables/views with cross referencing foreign keys [message #603254 is a reply to message #603249]

Thu, 12 December 2013 10:19

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Sadly, management don't always listen to the DBAs. It's not right, but it happens.

Report message to a moderator

Re: Query to find tables/views with cross referencing foreign keys [message #603255 is a reply to message #603249]

Thu, 12 December 2013 10:41

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

BlackSwan wrote on Thu, 12 December 2013 15:45

>(Oracle 8.1.7.4.1, Windows server 2003 R2)
uncertified combination above; since Windows 2003 did not exist when V8 was released.
Somebody chose to run on new hardware & new OS while retaining unsupported & obsoleted DB.
There are costs & benefits with every decision.

I'm not disagreeing with that, but that wasn't my point. My point was that it is of little value to simply tell someone to upgrade their database as this is very often (most often?) not a viable option for the person posting the question. Even for those who do have the clout to get it changed may no be able to due to lack of available funds for such a project.
To stretch the "my car won't go, make it go" analogy to it's limits; I wouldn't want a mechanic to tell me to upgrade my car when I took it in for an oil change, simply because it's out of its service agreement, I'd want him to change the damn oil Smile

Report message to a moderator

Re: Query to find tables/views with cross referencing foreign keys [message #603256 is a reply to message #603254]

Thu, 12 December 2013 10:42

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

gazzag wrote on Thu, 12 December 2013 16:19

Sadly, management don't always listen to the DBAs. It's not right, but it happens.

And sometimes, they DO listen to them, but simply don't have the funds to do an upgrade.

Report message to a moderator

Previous Topic:	Why SNMP agent requried in network
Next Topic:	SAP information !

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 05:31:57 CST 2024