Imp-00017 Following Statement Failed With Oracle Error 6550
Delete all board cookies • All times are UTC - 3 hours Powered by phpBB © 2016 phpBB Group | Anuncie neste Site
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle http://en.glufke.net/oracle/viewtopic.php?f=43&t=5437 VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace https://community.oracle.com/community/developer/search.jspa?q=IMP-00017 depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles Manage Cases Request Case Start http://support.esri.com/technical-article/000005525 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 http://oradbastuff.blogspot.com/2012/05/pls-00201-identifier.html 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 ORACLE error 29855 encountered ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-13249: internal error in Spatial index: [mdidxrbd] 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 imp-00017 following statement 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 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 usi
Error PLS-201 Identifier SYS.DBMS_EXPORT_EXTENSION Must Be Declared [ID 445135.] Symptoms Schema import fails with errors: IMP-00058: ORACLE error 6550 encounteredORA-06550: line 1, column 7:PLS-00201: identifier 'SYS.DBMS_EXPORT_EXTENSION' must be declaredORA-06550: line 1, column 7:PL/SQL: Statement ignoredIMP-00017: following statement failed with ORACLE error 6550:"BEGIN SYS.DBMS_EXPORT_EXTENSION.SET_IMP_SKIP_INDEXES_OFF; END;"IMP-00003: ORACLE error 6550 encounteredORA-06550: line 1, column 8:PLS-00201: identifier 'SYS.DBMS_EXPORT_EXTENSION' must be declaredORA-06550: line 1, column 8:PL/SQL: Statement ignoredIMP-00017: following statement failed with ORACLE error 6550:"BEGIN SYS.DBMS_EXPORT_EXTENSION.SET_IMP_SKIP_INDEXES_OFF; END;" Cause Import uses DBMS_EXPORT_EXTENSION package and you need to grant execute on DBMS_EXPORT_EXTENSIONto theschema user being imported into. Solution The main issue here is lack of privileges. There are 2 possible solutions:1. Grant execute on DBMS_EXPORT_EXTENSION to public.Or:2. Grant execute on DBMS_EXPORT_EXTENSION to the user/schema you are importing into (not the user who is running the import). For example, if you are importing into schema CDM_DB0 then grant execute to that user.. Publicat de Alexandru Garbia la 5/21/2012 Reacții: Niciun comentariu: Trimiteți un comentariu Postare mai nouă Postare mai veche Pagina de pornire Abonați-vă la: Postare comentarii (Atom) Tags Bug Oracle RDBMS (7) Linux/UNIX (7) Tips and tricks (5) Oracle RMAN tool backup (2) Oracle Books (1) Oracle Optimizer (1) Standby Oracle RDBMS (1) primul post pe blogul Sfaturi Oracle (1) Arhivă blog ► 2016 (38) ► octombrie (4) ► septembrie (11) ► august (4) ► iulie (2) ► iunie (6) ► mai (2) ► aprilie (3) ► martie (1) ► februarie (3) ► ianuarie (2) ► 2015 (68) ► decembrie (8) ► noiembrie (8) ► octombrie (7) ► septembrie (1) ► iulie (4) ► iunie (6) ► mai (3) ► aprilie (9) ► martie (6) ► februarie (6) ► ianuarie (10) ► 2014 (117) ► decembrie (13) ► noiembrie (12) ► octombrie (10) ► septembrie (2) ► august (6) ► i