Recover corrupted arcgis file
#Recover corrupted arcgis file pdf#
The last step is to run the IMPDP command again. autocad blurry pdf Select Universal Document Converter from the list of plotters. Your SDE schema should now be repaired and ready to go. Now that the SDE types are fixed, we need to recreate the spatial index type. Run these scripts as the SDE user, and supply the SDE argument: We will need to repair the SDE schema:įrom an ArcGIS Desktop installation, find the following four SQL scripts from C:\Program Files (x86)\arcgis\Desktop10.2\lib\.
Running this command will still give you the two ORA- errors, as shown above. The first run of IMPDP should only import the SDE schema, like: To work-around this issue, you will need to run the IMPDP twice. Any subsequent spatial indexes fail to create, and will show the following error in the IMPDP logfile:ĭoing a schema compare between a working Geodatabase and an imported database, there are two missing or corrupt types in the SDE schema: Running an IMPDP, receives the following error:īecause of the two highlighted error codes, the SDE.ST_SPATIAL_INDEX type doesn’t get imported. Only Oracle 12.1 is affected by this issue. Recently, SSP Innovations and Esri have discovered a bug when using Oracle’s IMPDP Data Pump tool to import a database. The DATAPUMP system has two commands: EXPDP (for exporting a database to a file), and IMPDP (for importing that file into the Oracle database). Or to provide vendors such as SSP with a copy of their Oracle database.
For example, DATAPUMP can be used to move a Production database back into a TEST/DEV instance. Oracle’s DATAPUMP system is a common way for DBAs to move databases from one instance to another.