Re: v$abc.. table names - nightmare
Date: Wed, 18 May 2011 01:00:52 -0700 (PDT)
Message-ID: <7934bc8e-9b39-41ac-8d6b-05e4babdf8a7_at_q32g2000yqn.googlegroups.com>
> 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