Can we run statistics on one sysadm table using Datamover?
Any idea whether we can run Statistics on an Oracle table (under sysadm schema), Using peoplesoft Datamover? In that case could you please help me with the command syntax?
For example, the below command I can run directly in database (using sqlplus or sql developer etc.). But is there a direct or indirect way to run them(stored procedures or just statistics on table) using Peoplesoft Datamover
Execute dbms_stats.gather_table_stats (ownname=>'SYSADM',tabname=>'PSOPRDEFN',method_opt=>'FOR ALL COLUMNS SIZE REPEAT',estimate_percent=>100,degree=>5,CASCADE=>TRUE);
Thanks,
Nixon