Cursor throwing error while passing to dbms_stats.gather_schema_stats [message #677918] |
Tue, 22 October 2019 14:23 |
|
chavva.kiru@gmail.com
Messages: 23 Registered: April 2012 Location: hyderabad
|
Junior Member |
|
|
Hi,
Below Cursor is throwing error while passing through schema_stats procedure.
error as:Encountered the symbol "DBMS_STATS" when expecting one of the following:=.(@ % The symbol ":=
can any one please help how to rectify below issue
declare
cursor c1 is
select distinct owner from all_tables;
begin
for i in c1
loop
exec dbms_stats.gather_schema_stats(ownname=>i.owner);
end loop;
end;
/
|
|
|