Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie Question, Please help!
Frank wrote:
> I'm trying to make my oracle database work with one of my applications and I
> was told that I needed to run a validation script against everyone of my
> tablespaces. Now i know how to run scripts against an instance, but not a
> tablespace. I asked the software support people how to do it and the guy i
> talked to said well you need an Oracle DBA there and he should do it for
> you, if you don't have one, then we can't help you. What a bunch of crock. I
> got this script from their knowledge base, i just don't know how to execute
> them, please help!
>
> declare
> begin
> validate_dependencies_all;
> end;
> /
>
> Is this done in SQL Plus? I am running Oracle 8.1.7 on a Windows 2000
> server. Thanks again!
>
> Frank
What is VALIDATE_DEPENDENCIES_ALL? It certainly isn't in my 8i or 9i instances. And why are you running it? Based on the name it seems to be meaningless unless there is a problem.
But assuming someone internal to your organization created it log on in SQL*Plus and just copy it in at the command prompt then hit the <Enter> key.
Daniel Morgan Received on Mon Feb 10 2003 - 11:56:17 CST