00017 Error
Contents |
Topic Backup and recovery Database Admin View All Cloud infrastructure Availability Database design Export, import and migration Installation, upgrades and patches Oracle performance problems
Imp-00017: Following Statement Failed With Oracle Error 959
and tuning Oracle security Oracle DBA tools Error messages imp-00003: oracle error 959 encountered MySQL database Real Application Clusters (RAC) Applications View All Enterprise and business performance ora-00959 tablespace does not exist management Implementing and upgrading Oracle apps E-Business Suite Fusion applications Hyperion JD Edwards (JDE) PeopleSoft Siebel and Oracle CRM Data Mgmt View All BI (business intelligence) Data quality Data warehousing Metadata Database Admin View All Cloud infrastructure Availability Backup and recovery Database design Export, import and migration Installation, upgrades and patches Oracle performance problems and tuning Oracle security Oracle DBA tools Error messages MySQL database Real Application Clusters (RAC) Development View All BPEL in Oracle Open Source SQL Java / J2EE Stored procedures XML PL/SQL Fusion View All Oracle and BEA Application Server Data and application integration SOA (service-oriented architecture) Infrastructure View All Cloud computing infrastructure Exadata and Exalogic Grid computing Oracle on Linux Operating system Oracle hardware decisions Virtual machine Oracle management View All certification Oracle acquisitions Business process management Market analysis DBA jobs training and certification Small businesses Regulatory compliance Outsourcing Oracle on demand and SaaS Oracle strategy and product roadmap Oracle support services Oracle vs. SAP Oracle Web 2.0 Sun-Oracle infrastructure View All Oracle cloud computing Oracle OS Oracle virtualization Topics Archive View All Oracle DBA jobs Oracle Resources Training and certification Tutorials, tips and FAQs Please select a category Applications Data Mgmt Database Admin Development Fusion I
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles Manage Cases Request Case Start Chat Back to results Print Share Is This Content Helpful? Search on GeoNet Submit to ArcGIS Ideas Bug: IMP-00017: following statement failed with ORACLE error 29855 Description IMP-00017: following statement failed with ORACLE error 29855: "CREATE INDEX "A197_IX1" ON "USACAPITALS" ("FEATURE" ) INDEXTYPE IS "MDSYS"" "."SPATIAL_INDEX" PARAMETERS ('SDO_COMMIT_INTERVAL = 1000')" IMP-00003: ORACLE error 29855 encountered ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-13249: internal error in Spatial index: [mdidxrbd] http://searchoracle.techtarget.com/answer/IMP-00017-error-message-with-Oracle-import ORA-13249: Error in Spatial index: index build failed ORA-13249: Error in spatial index: [mdrcrtxfergm] ORA-13365: Layer SRID does not match geometry SRID ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 7 ORA-06512: at line 1 Cause Importing Oracle 8.1.7 dump files into Oracle 9i may fail if they contain Oracle Spatial feature classes loaded using shp2sde prior to ArcSDE 8.2 Patch 1. This error occurs http://support.esri.com/technical-article/000005525 when trying to build the Oracle Spatial spatial index. As mentioned in the error message, the SRID in the layer does not match the SRID in the one or more geometries, or more precisely, the SRID in the entry in USER_SDO_GEOM_METADATA for the table does not match MDSYS.SDO_GEOMETRY.SDO_SRID in one or more rows in the table. Prior to ArcSDE 8.2 Patch 1, ArcSDE did not check whether the Oracle Spatial SRID in USER_SDO_GEOM_METADATA for a table matched the SDO_GEOMETRY.SDO_SRID in each row of the table. In Oracle 8i, this was not required. It is now required in Oracle 9i, and ArcSDE was changed to meet this new requirement in ArcSDE 8.2 Patch 1. Now, importing a shapefile into an Oracle Spatial table using ArcCatalog sets the Oracle Spatial SRID to NULL in each feature's record and in USER_SDO_GEOM_METADATA. Workaround After loading Oracle Spatial data using an earlier version of shp2sde, each row in the new table can be updated to have an SRID that matches the one found in USER_SDO_GEOM_METADATA, and then rebuild the spatial index. 2-D R-Tree spatial indexes shoul
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company http://stackoverflow.com/questions/10892847/oracle-import-error Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, http://siebel.ittoolbox.com/groups/technical-functional/siebel-admin-l/sblsvr00017-error-5146177 just like you, helping each other. Join them; it only takes a minute: Sign up oracle import error up vote 2 down vote favorite While importing a dump file into oracle 11gr2 i am getting this error oracle error please suggest a way to resolve this *Warning: the objects were exported by D7IDMP, not by you import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses WE8ISO8859P1 character set (possible charset conversion) . importing D7IDMP's objects into MIGRATE . . importing table "TXALLTXTS" 245628 rows imported . . importing table "TXAUTH" 377 rows imported . . importing table "TXBAIMERT" 244 rows imported . . importing table "TXBARESC" 178 rows oracle error 959 imported . . importing table "TXBOILER" 458940 rows imported . . importing table "TXCLASSES" 980 rows imported . . importing table "TXCLOSEDPERIODS" 1 rows imported . . importing table "TXCOMPANIES" 1 rows imported . . importing table "TXCONCLAUSES" 187 rows imported IMP-00017: following statement failed with ORACLE error 959: "CREATE TABLE "TXCONFIGSETTINGS" ("CFS_CODE" VARCHAR2(20), "CFS_RCODE" VARCHAR2(2" "0)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 16384 FR" "EELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "MP5TEXT" LOGGI" "NG NOCOMPRESS LOB ("CFS_XMLCONFIG") STORE AS (TABLESPACE "MP5TEXT" ENABLE " "STORAGE IN ROW CHUNK 8192 PCTVERSION 10 NOCACHE STORAGE(INITIAL 65536 FREE" "LISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))" IMP-00003: ORACLE error 959 encountered ORA-00959: tablespace 'MP5TEXT' does not exist* As per alex comments i tried with other attributes of imp but it resulted someother error The command which i run is imp fromuser=d7idmp touser=&&from_user file=test.dmp log= test.log ignore=y transport_tablespace = y tablespaces = MP5TEXT the error is import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set export client uses WE8ISO8859P1 character set (possible charset conversion) IMP-00053: Import mode incompatible with Export dump file IMP-00000: Import terminated unsuccessfully oracle import oracle11g share|improve this question edited Jun 5 '12 at 10:49 asked Jun 5 '12 at 6:47 Maddy 1,65442544 I don't think you are using transportable tablespaces - they don't
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant MarkDeVries DACREE Inside-ERP MacProTX VoIP_News Inside-CRM I_am_the_dragon PCMag maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker JoeTorre bracke Richard Locutus DukeGanote Ramnath.Awate Dennis Stevenson Craig Borysowich Nikki Klein AbhaiTripathi bluesguyAZ59 iudithm knowscognosdoi Clinton Jones mircea_luca Iqbalyk COMPANIES VAI SendGrid Apperian Panaya Inc. View All Topics View All Members View All Companies Toolbox for IT Topics Siebel Groups Ask a New Question Siebel - General Discussions The Siebel – General Discussion group is a forum where peers share technical expertise, solve problems, and discuss issues related to Siebel. Home | Invite Peers | More Siebel Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. SBL-SVR-00017 Error JorgeThelaw asked Mar 26, 2013 | Replies (2) I try to send a job in AdminServer-Jobs with these parameters: UCMSearchSpec="[Contact.UCM Type Code] = 'Batch017'" UCMSurvivorshipEngineFlag=False UCMPubSubFlag=False UCMCDMMatchFlag=True UCMBatchObjectType=Contact but i get this error: SBL-SVR-00017: Cannot convert parameter value. I don't find which is the error, can you help me please? Join this group Popular White Paper On This Topic Big Data and the CMO: An Introduction to the Challenge and the Opportunity 2Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... johan.song replied Mar 26, 2013 Hello, Why don't you try setting the Boolean values within "" (double quotes)? Example: UCMSurvivorshipEngineFlag="false" UCMPubSubFlag="false" and so on.. Kind regards, Johan Song Top Best Answer 0 Mark this reply as