Database Administration (MOSC)

MOSC Banner

sqlcode - -001031 Old partition cannot be exchanged

edited Jan 6, 2014 3:29AM in Database Administration (MOSC) 8 commentsAnswered
The Application job had failed with below error

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 ;

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