In Oracle 11g, when SDEIMPORT command is executed against a feature class in the SDE.DEFAULT version, the import fails if SDE.DEFAULT is Protected. If the SDE.DEFAULT version is either Public or Private, the import will work fine.
Other non-command line data loading tools, like the Simple Data Loader and Append tool work.
Last Published: August 25, 2014ArcSDE/Enterprise Geodatabase
Bug ID Number
NIM062810
Submitted
November 15, 2010
Last Modified
April 2, 2025
Applies to
ArcSDE/Enterprise Geodatabase
Version found
10.0
Status
Known Limit
After review by the development team, it has been determined that this issue is related to a known limitation with the software that lies outside of Esri's control. The issue's Additional Information section may contain further explanation.
Additional Information
Use ArcGIS tools instead of the sdeimport command line.
Workaround
1. The simple data loader can be used instead of the command line.2. If workflows permit, the SDE.DEFAULT permissions can be changed to Private for the SDEIMPORT, then switched back to Protected after that.