How to gather statistics via CloverETL graph?

tomas

• September 08, 2015 00:00

• Answered

Follow

Hello,

my issue is simple - I want to gather statistics after inserting/deleting data using SQL:

execute DBMS_STATS.gather_table_stats('<scheme>', '<table>')

When I use DBExecute component, the answer is

ORA-00900: invalid SQL statement

However when I run it in SQL Developer, the command is processed correctly.
I have the rights to run the command.

Appreciate any help.
Thanks a lot
Tomas

• 

  Lukas Cholasta

  • September 09, 2015 07:34

  0

  Comment actions Permalink

  Hi Tomas
  
  You need to use PL/SQL statement instead of plain SQL:
  
  

  BEGIN
  	DBMS_STATS.gather_table_stats('<scheme>', '<table>');
  END;

  
  
  Also you have to change the SQL statement delimiter to ^
  
  I hope this helps.
  Best regards
• 

  tomas

  • September 11, 2015 14:26

  0

  Comment actions Permalink

  Thank you very much!!! It is working!
  Perfect help - thanks a lot!
  Tomas

Please sign in to leave a comment.