Thanks guys, i'll try those suggestions out. I'll let you guys know what the
hell this procedure does. :)
"DA Morgan" <damorgan_at_exesolutions.com> wrote in message
news:3E483539.D51EEF9A_at_exesolutions.com...
> "Howard J. Rogers" wrote:
>
> > On Mon, 10 Feb 2003 21:41:48 +0000, Frank wrote:
> >
> > > Wow that's easy, is there any way that you can run this per
tablespace? Or
> > > do you pretty much just run it against the instance and it works for
all the
> > > tablespaces in the instance. The reason i ask is because this is the
way
> > > they worded it:
> > >
> > > 1. Log off every user in the program.
> > > 2. Run the following validation against all tablespaces in the
Program
> > > instance
> > >
> > > declare
> > > begin
> > > validate_dependencies_all;
> > > end;
> > > /
> > >
> > > So they mean run it against the instance right? Or is there some
special way
> > > you have to run it against each tablespace.. I don't know, i'm just a
> > > newbie. :( Thanks
> > >
> > > Frank
> > >
> >
> > There's no answer to this question, Frank. What is
> > 'validate_dependencies_all'? Well, it's a package or a procedure or a
> > function, that's for sure. But what's actually *in* it?
> >
> > Who can say? You might doing a 'desc validate_dependencies_all' at the
SQL
> > Plus command prompt, to see if it takes any arguments. Maybe
> > tablespace_name is one of them.
> >
> > What's that procedure actually do? God knows. It's not one of Oracle's,
so
> > you are at the mercy of whatever the developer who coded it thought it
> > should do.
> >
> > Why don't you just type in the commands exactly as Daniel indicated, and
> > see what happens? Post the output if its small enough )or a part thereof
> > if its not) and maybe we can see what it's actually doing. What I'm
> > getting at is that who on Earth knows what 'validating a tablespace'
> > means? It's an essentially meaningless concept, unless we can see what
the
> > original developer thought it should mean (is it measuring free space?
Is
> > it finding tables which would be unable to extend in the near future? Is
> > it calculating statistics for every table? Or what??)
> >
> > Regards
> > HJR
>
> If you can, before you run it, try this:
>
> SELECT owner, object_type
> FROM all_objects
> WHERE object_name = 'VALIDATE_DEPENDENCIES_ALL';
>
> If you get no answer it either doesn't exist or you have no permission to
run it.
>
> If it does exist, try this:
>
> SELECT COUNT(*)
> FROM all_source
> WHERE owner = <owner from above query>
> AND name = 'VALIDATE_DEPENDENCIES_ALL';
>
> And if the number of lines isn't astronomical perform the following:
>
> spool c:\temp\vda.txt
>
> SELECT text
> FROM all_source
> WHERE owner = <owner from above query>
> AND name = 'VALIDATE_DEPENDENCIES_ALL'
> ORDER BY line;
>
> spool off
>
> Then post the source code (c:\temp\vda.txt) here and someone will tell you
what it
> does and if it is dangerous to run.
>
> Then tell your management at least some of us don't think much of them
asking you
> to do something like this without adequate understanding of what you are
doing or
> why. We will help if we can.
>
> Daniel Morgan
>
Received on Mon Feb 10 2003 - 19:28:48 CST
