ERROR 000955: Error encountered migrating the database storage

[EmadAl-Mousa]

Hi,

while performing a "storage migration " of a group of "feature classes" under a feature dataset using the Geoprocessing Tool (Migrate Storage), i receive the following error:

i am facing the following errors:

ERROR 000955: Error encountered migrating the database storage
Insufficient permissions[Feature Class Name]
Failed to execute(MigrateStorage)

My Geodatabase is in Oracle Envrionment (ArcCatalog 10.2), and i am migrating the storage from "SDEBINARY" to "SDELOB".

my connection is through the "schema user" and DBTUNE file have been verified to be OK.

I have attached the snapshot image.

[NidhinKarthikeyan]

Try to decrease the number of Feature Class in the 'Migrate Storage' tool.

[NidhinKarthikeyan]

Please let us know the exact version of ArcSDE. There is a bug which was found in ArcSDE 10.0 SP3 and was fixed in ArcSDE 10.1SP1. It was for migrating storage from SDEBINARY to ST_GEOMETRY.

[EmadAl-Mousa]

ArcSDE Geodatabase is 10.1 SP1

[EmadAl-Mousa · Accepted solution]

The migration process will work with schema user if the user has the follwoing privileges:

GRANT ALTER ANY INDEX TO USER;
  GRANT CREATE ANY INDEX TO USER;
  GRANT CREATE TABLE TO USER;
  GRANT DROP ANY INDEX TO USER;


@nidhinkn Thanks for your support.

[EmadAl-Mousa]

just last comment....the ESRI documentation doesn't specify the privileges required while performing the storage migration !!!

i have read the following reference documentation:

http://resources.arcgis.com/en/help/main/10.1/index.html#//002n00000076000000
http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000000q000000
http://resources.arcgis.com/en/help/main/10.2/index.html#//002n00000076000000



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...

it will be great if ESRI can update their documentation.