DBA's usually never grant a schema user "alter any index,drop any index, create any index...etc"

since this a very serious security issue to grant an oracle user "any" permission.

i have reached the conclusion of these required permissions after narrowing it down from "DBA" privilege granting which lead to the successful migration, and gradually revoked privileges unnecessary ones...