Cannot directly import a feature class with a long text field (>4000) from a file geodatabase to ArcSDE for Oracle.
Last Published: August 25, 2014No Product Found
Bug ID Number
NIM033457
Submitted
March 19, 2008
Last Modified
April 2, 2025
Applies to
No Product Found
Version found
9.2
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
No Public Explanation
Workaround
1. Create an empty feature class in the ArcSDE, import the fields from the feature class in FGDB, but change the length of the text field from 4096 to 4000 (or less), then, load data from the feature class in FGDB to the empty feature class in ArcSDE.2. Copy/Paste the feature class from FGDB to PGDB, the text field with length of 4096 will become length 2147483647. Use ArcCatalog/GP tools to transfer the feature class from PGDB to ArcSDE, the text field will be converted to NCLOB.