PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Can we run statistics on one sysadm table using Datamover?

edited Jan 8, 2014 8:30PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered
Hi All,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center