Re: v$abc.. table names - nightmare

From: neilsolent <>
Date: Wed, 18 May 2011 01:00:52 -0700 (PDT)
Message-ID: <>

> Dude this has been done and redone so many times in the last 25 years
> that unless you know exactly what you are doing and why you are doing
> it ... using something pre-written and off the shelf will at least
> initially probably be a whole lot better than what you are currently
> doing.

It is very unlikely that scripts written 25 years ago will work now. There wasn't even Perl then!
Off the shelf code won't cater for the non-Oracle parts of the scripts I write - they do a whole lot more than just Oracle-related stuff.

> All in all ... it might be a whole lot easier for you to either find
> some good prewritten stuff ( google things like "oracle health check
> script" maybe beware of the references to the site run by you know
> who )

Errr .. that's what I'm doing. This is the internet right here :-)

> Not to be rude but if you are struggling just to be able to in a
> script issue sqlplus commands against v$database it seems like you
> have a pretty steep learning curve in your immediate future.

I am not struggling.
This thread was really just a simple question about the $ signs. Noone has presented any good reason why they are there (they've been there for 25 years - perhaps that was long enough to fix this design no-no?)
I know shell is not ideal for Oracle programming in general - but you do have to consider the bigger picture beyond Oracle. Perhaps I do know what I am doing and I was just asking a simple question.. Received on Wed May 18 2011 - 03:00:52 CDT

Original text of this message