Home » Other » General » Upgrade Your DB!
Upgrade Your DB! [message #603244] Thu, 12 December 2013 09:34 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 23155
Registered: January 2009
Senior Member
consider joining the 21st Century at your earliest convenience
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
pablolee
Messages: 2658
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?
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 Go to previous messageGo to next message
oraclebabe
Messages: 7
Registered: December 2013
Junior Member
I have no control. If I did, I wouldn't be working with 8i.
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 Go to previous messageGo to next message
BlackSwan
Messages: 23155
Registered: January 2009
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.
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 Go to previous messageGo to next message
gazzag
Messages: 388
Registered: November 2010
Location: Bristol, UK
Senior Member
Sadly, management don't always listen to the DBAs. It's not right, but it happens.
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 Go to previous messageGo to next message
pablolee
Messages: 2658
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
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 Go to previous message
pablolee
Messages: 2658
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.
Previous Topic: Why SNMP agent requried in network
Next Topic: SAP information !
Goto Forum:
  


Current Time: Sat Dec 20 15:56:49 CST 2014

Total time taken to generate the page: 0.07485 seconds