Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Including special characters in query generation

Re: Including special characters in query generation

From: David Sharples <davidsharples_at_gmail.com>
Date: Fri, 2 Sep 2005 16:46:45 +0100
Message-ID: <be592d55050902084643c40e96@mail.gmail.com>


I find this way easier
 begin
for i in (select username from dba_users) LOOP dbms_stats.gather_schema_stats(i.username,estimate_percent=>dbms_stats.auto_sample_size,method_opt=> for all columns size repeat,degree =>7); end loop;
end;
/

 On 9/2/05, Chirag DBA <chiragdba_at_gmail.com> wrote:
>
> I want to generate a script for all users.
> What is wrong here? There is one set parameter to set special characters
> off.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 02 2005 - 10:48:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US