topic ERROR installing ArcSDE 10 Ora 11G- XML -create Index in Data Management Questions https://community.esri.com/t5/data-management-questions/error-installing-arcsde-10-ora-11g-xml-create/m-p/207079#M11867 <HTML><HEAD></HEAD><BODY><SPAN>I have a BD ORACLE 11G and AGServer 10 in windows server 2008 R2 .</SPAN><BR /><SPAN>I used the setup option for creating the repository manually changing the parameters of dbtune,</SPAN><BR /><SPAN>for it had created&nbsp; user "sde" and tablespace "sde"&nbsp; and "sde_movegdba" and for versioning</SPAN><BR /><SPAN>In the dbtune only change the parameters to DATADICTIONARY</SPAN><BR /><SPAN>dbtune.sde :</SPAN><BR /><SPAN>##DATA_DICTIONARY</SPAN><BR /><SPAN>ATTRIBUTE_BINARY&nbsp; "BLOB"</SPAN><BR /><SPAN>B_STORAGE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "PCTFREE 0 INITRANS 4 </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 40K)"</SPAN><BR /><SPAN>B_INDEX_ROWID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "PCTFREE 0 INITRANS 4</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 40K) NOLOGGING"</SPAN><BR /><SPAN>B_INDEX_USER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "PCTFREE 0 INITRANS 4 </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 40K) NOLOGGING"</SPAN><BR /><SPAN>STATES_TABLE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "INITRANS 4</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde_movegdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 1M)"</SPAN><BR /><SPAN>STATES_INDEX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "INITRANS 5</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde_movegdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 128K) NOLOGGING"</SPAN><BR /><SPAN>STATE_LINEAGES_TABLE&nbsp;&nbsp;&nbsp; "PCTFREE 0 INITRANS 4</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde_movegdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 7M)"</SPAN><BR /><SPAN>STATE_LINEAGES_INDEX&nbsp;&nbsp;&nbsp; "PCTFREE 0 INITRANS 4</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde_movegdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 5M) NOLOGGING"</SPAN><BR /><SPAN>VERSIONS_TABLE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "INITRANS 4</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde_movegdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 256K)"</SPAN><BR /><SPAN>VERSIONS_INDEX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "INITRANS 4</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde_movegdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 128K) NOLOGGING"</SPAN><BR /><SPAN>MVTABLES_MODIFIED_TABLE "INITRANS 4</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde_movegdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 2M)"</SPAN><BR /><SPAN>MVTABLES_MODIFIED_INDEX "INITRANS 4 </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde_movegdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL&nbsp; 2M) NOLOGGING"</SPAN><BR /><SPAN>XML_INDEX_TAGS_TABLE&nbsp;&nbsp;&nbsp; "INITRANS 4</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 1M)"</SPAN><BR /><SPAN>XML_INDEX_TAGS_INDEX&nbsp;&nbsp;&nbsp; "INITRANS 5</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 1M)"</SPAN><BR /><SPAN>END</SPAN><BR /><BR /><BR /><SPAN>But try I get the message</SPAN><BR /><BR /><SPAN>VERSION table created...</SPAN><BR /><SPAN> SPATIAL_REFERENCES table being created...</SPAN><BR /><SPAN> SPATIAL_REFERENCES table created...</SPAN><BR /><SPAN> GEOMETRY_COLUMNS table being created...</SPAN><BR /><SPAN> GEOMETRY_COLUMNS table created...</SPAN><BR /><SPAN> LAYERS table being created...</SPAN><BR /><SPAN> LAYERS table created...</SPAN><BR /><SPAN>METADATA table being created...</SPAN><BR /><SPAN> METADATA table created...</SPAN><BR /><SPAN> RASTER_COLUMNS table being created...</SPAN><BR /><SPAN> RASTER_COLUMNS table created...</SPAN><BR /><SPAN> TABLE_REGISTRY table being created...</SPAN><BR /><SPAN> TABLE_REGISTRY table created...</SPAN><BR /><SPAN> COLUMN_REGISTRY table being created...</SPAN><BR /><SPAN> COLUMN_REGISTRY table created...</SPAN><BR /><SPAN> STATES table being created...</SPAN><BR /><SPAN> STATES table created...</SPAN><BR /><SPAN> VERSIONS table being created...</SPAN><BR /><SPAN> VERSIONS table created...</SPAN><BR /><SPAN> MVTABLES_MODIFIED table being created...</SPAN><BR /><SPAN> MVTABLES_MODIFIED table created...</SPAN><BR /><SPAN> STATE_LINEAGES table being created...</SPAN><BR /><SPAN> S_instance_add_lineage_id_index:Error creating index (2158)Error: &lt;&lt; ORA-02158: opción CREATE INDEX no válida</SPAN><BR /><BR /><SPAN> DB_instance_lineages_table_exists:Error creating STATE_LINEAGE(lineage_id) index (2158)</SPAN><BR /><SPAN> ERROR in creating STATE_LINEAGES table.</SPAN><BR /><SPAN>Error: 2158</SPAN><BR /><SPAN>DBMS error code: 2158</SPAN><BR /><SPAN>ORA-02158: opción CREATE INDEX no válida</SPAN><BR /><SPAN> SDE schema object install not completed.</SPAN><BR /><SPAN> ERROR installing/upgrading ArcSDE, Error = -1</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>It is an error in reading the xml oracle or bad is that I have set the parameters of DBTUNE ????</SPAN></BODY></HTML> Sat, 23 Jul 2011 22:48:11 GMT Arturo_FranciscoAcosta_Bazán 2011-07-23T22:48:11Z ERROR installing ArcSDE 10 Ora 11G- XML -create Index https://community.esri.com/t5/data-management-questions/error-installing-arcsde-10-ora-11g-xml-create/m-p/207079#M11867 <HTML><HEAD></HEAD><BODY><SPAN>I have a BD ORACLE 11G and AGServer 10 in windows server 2008 R2 .</SPAN><BR /><SPAN>I used the setup option for creating the repository manually changing the parameters of dbtune,</SPAN><BR /><SPAN>for it had created&nbsp; user "sde" and tablespace "sde"&nbsp; and "sde_movegdba" and for versioning</SPAN><BR /><SPAN>In the dbtune only change the parameters to DATADICTIONARY</SPAN><BR /><SPAN>dbtune.sde :</SPAN><BR /><SPAN>##DATA_DICTIONARY</SPAN><BR /><SPAN>ATTRIBUTE_BINARY&nbsp; "BLOB"</SPAN><BR /><SPAN>B_STORAGE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "PCTFREE 0 INITRANS 4 </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 40K)"</SPAN><BR /><SPAN>B_INDEX_ROWID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "PCTFREE 0 INITRANS 4</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 40K) NOLOGGING"</SPAN><BR /><SPAN>B_INDEX_USER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "PCTFREE 0 INITRANS 4 </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 40K) NOLOGGING"</SPAN><BR /><SPAN>STATES_TABLE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "INITRANS 4</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde_movegdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 1M)"</SPAN><BR /><SPAN>STATES_INDEX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "INITRANS 5</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde_movegdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 128K) NOLOGGING"</SPAN><BR /><SPAN>STATE_LINEAGES_TABLE&nbsp;&nbsp;&nbsp; "PCTFREE 0 INITRANS 4</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde_movegdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 7M)"</SPAN><BR /><SPAN>STATE_LINEAGES_INDEX&nbsp;&nbsp;&nbsp; "PCTFREE 0 INITRANS 4</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde_movegdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 5M) NOLOGGING"</SPAN><BR /><SPAN>VERSIONS_TABLE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "INITRANS 4</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde_movegdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 256K)"</SPAN><BR /><SPAN>VERSIONS_INDEX&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "INITRANS 4</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde_movegdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 128K) NOLOGGING"</SPAN><BR /><SPAN>MVTABLES_MODIFIED_TABLE "INITRANS 4</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde_movegdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 2M)"</SPAN><BR /><SPAN>MVTABLES_MODIFIED_INDEX "INITRANS 4 </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde_movegdba</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL&nbsp; 2M) NOLOGGING"</SPAN><BR /><SPAN>XML_INDEX_TAGS_TABLE&nbsp;&nbsp;&nbsp; "INITRANS 4</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 1M)"</SPAN><BR /><SPAN>XML_INDEX_TAGS_INDEX&nbsp;&nbsp;&nbsp; "INITRANS 5</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TABLESPACE sde</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; STORAGE (INITIAL 1M)"</SPAN><BR /><SPAN>END</SPAN><BR /><BR /><BR /><SPAN>But try I get the message</SPAN><BR /><BR /><SPAN>VERSION table created...</SPAN><BR /><SPAN> SPATIAL_REFERENCES table being created...</SPAN><BR /><SPAN> SPATIAL_REFERENCES table created...</SPAN><BR /><SPAN> GEOMETRY_COLUMNS table being created...</SPAN><BR /><SPAN> GEOMETRY_COLUMNS table created...</SPAN><BR /><SPAN> LAYERS table being created...</SPAN><BR /><SPAN> LAYERS table created...</SPAN><BR /><SPAN>METADATA table being created...</SPAN><BR /><SPAN> METADATA table created...</SPAN><BR /><SPAN> RASTER_COLUMNS table being created...</SPAN><BR /><SPAN> RASTER_COLUMNS table created...</SPAN><BR /><SPAN> TABLE_REGISTRY table being created...</SPAN><BR /><SPAN> TABLE_REGISTRY table created...</SPAN><BR /><SPAN> COLUMN_REGISTRY table being created...</SPAN><BR /><SPAN> COLUMN_REGISTRY table created...</SPAN><BR /><SPAN> STATES table being created...</SPAN><BR /><SPAN> STATES table created...</SPAN><BR /><SPAN> VERSIONS table being created...</SPAN><BR /><SPAN> VERSIONS table created...</SPAN><BR /><SPAN> MVTABLES_MODIFIED table being created...</SPAN><BR /><SPAN> MVTABLES_MODIFIED table created...</SPAN><BR /><SPAN> STATE_LINEAGES table being created...</SPAN><BR /><SPAN> S_instance_add_lineage_id_index:Error creating index (2158)Error: &lt;&lt; ORA-02158: opción CREATE INDEX no válida</SPAN><BR /><BR /><SPAN> DB_instance_lineages_table_exists:Error creating STATE_LINEAGE(lineage_id) index (2158)</SPAN><BR /><SPAN> ERROR in creating STATE_LINEAGES table.</SPAN><BR /><SPAN>Error: 2158</SPAN><BR /><SPAN>DBMS error code: 2158</SPAN><BR /><SPAN>ORA-02158: opción CREATE INDEX no válida</SPAN><BR /><SPAN> SDE schema object install not completed.</SPAN><BR /><SPAN> ERROR installing/upgrading ArcSDE, Error = -1</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>It is an error in reading the xml oracle or bad is that I have set the parameters of DBTUNE ????</SPAN></BODY></HTML> Sat, 23 Jul 2011 22:48:11 GMT https://community.esri.com/t5/data-management-questions/error-installing-arcsde-10-ora-11g-xml-create/m-p/207079#M11867 Arturo_FranciscoAcosta_Bazán 2011-07-23T22:48:11Z Re: ERROR installing ArcSDE 10 Ora 11G- XML -create Index https://community.esri.com/t5/data-management-questions/error-installing-arcsde-10-ora-11g-xml-create/m-p/207080#M11868 <HTML><HEAD></HEAD><BODY><SPAN>The main problem with editing the dbtune.sde file before initial setup is the possibility of</SPAN><BR /><SPAN>corrupting the file so that you can't install.&nbsp;&nbsp; Try dropping the SDE user and starting over </SPAN><BR /><SPAN>with an original DBTUNE file.&nbsp; If setup fails again, then your Oracle instance doesn't have </SPAN><BR /><SPAN>the correct configuration for XML support; if it doesn't fail, pay closer attention to the</SPAN><BR /><SPAN>changes you are making to the initial dbtune.sde.</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>- V</SPAN></BODY></HTML> Sun, 24 Jul 2011 12:10:33 GMT https://community.esri.com/t5/data-management-questions/error-installing-arcsde-10-ora-11g-xml-create/m-p/207080#M11868 VinceAngelo 2011-07-24T12:10:33Z Re: ERROR installing ArcSDE 10 Ora 11G- XML -create Index https://community.esri.com/t5/data-management-questions/error-installing-arcsde-10-ora-11g-xml-create/m-p/207081#M11869 <HTML><HEAD></HEAD><BODY><SPAN>The mistake is that the configuration of dbtune use WORDPAD&nbsp; when it should have opened the file with NOTEPAD. Now it works, this error is incredible !!</SPAN></BODY></HTML> Tue, 26 Jul 2011 21:30:53 GMT https://community.esri.com/t5/data-management-questions/error-installing-arcsde-10-ora-11g-xml-create/m-p/207081#M11869 Arturo_FranciscoAcosta_Bazán 2011-07-26T21:30:53Z