sqlcode - -001031 Old partition cannot be exchanged
About the job :-
The job runs a shell script that calls a Cobol program. That Cobol program then calls a PL/SQL procedure. The PL/SQL procedure then does the alter table to exchange the partition. Since it is a procedure defined in the database, the use of roles to acquire security doesn’t work. The work around is to grant the permissions directly to the userid. I have done the following grants but still we are getting the same error
Grant DBA to User name;
GRANT ALTER ANY INDEX TO User name ;