Imp-00003 Oracle Error 6550 Encountered
Contents |
the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the imp-00003 ora-01435 selection below. Results 1 to 8 of 8 Thread: Import problem... Tweet Thread Tools Show
Imp-00003: Oracle Error 1435 Encountered
Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 11-01-03,17:35 #1 TCR09 View Profile View Forum Posts Registered User Join Date Nov 2003 Posts 5 Unanswered: Import problem... Hi, I have a production database, and a test database which is a copy of the production db. Usually, to update the test db, i do an export of each user of the prod db, then import them in the test db. And it works.... But now, it seems that my new exports can't be imported anymore. I've tried an old dump file and it's still working. But the new ones keep making errors like the following: IMP-00017: following statement failed with ORACLE error 6550: "DECLARE SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '78670A0A092221'; SR" "EC.MAXVAL := '78670A0A0C2427'; SREC.EAVS := 0; SREC.CHVALS := NULL; SREC.NO" "VALS := DBMS_STATS.NUMARRAY(2452923,35662037,2452923,48307 87); SREC.BKVALS " ":= DBMS_STATS.NUMARRAY(0,1); SREC.EPC := 2; DBMS_STATS.SET_COLUMN_STATS(NUL" "L,'AUDIT_USAGER_DEMANDE','DATEACTION',NULL,NULL,N ULL,11,,0909090909090909,0" ",srec,7,0); END;" IMP-00003: ORACLE error 6550 encountered ORA-06550: line 1, column 357: PLS-00103: Encountered the symbol "," when expecting one of the following: ( - + mod not null others
Connor McDonald � Last updated: February 11, 2016 - 2:41 am UTC Category: Database � Version: 11g Latest Followup You Asked I need to import an Oracle9i Release 9.2.0.6.0 dump in an Oracle 11g. Using the import command I have a ton of erros like this: IMP-00017: following statement failed with ORACLE error 6550: "BEGIN SYS.DBMS_EXPORT_EXTENSION.SET_IMP_SKIP_INDEXES_OFF; END;" IMP-00003: ORACLE error 6550 encountered Th command I use is: imp system/
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have https://community.oracle.com/community/developer/search.jspa?q=IMP-00017 JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it http://stackoverflow.com/questions/35312769/error-while-importing-an-oracle-9-dump-in-oracle-11g enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle oracle error 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 imp-00003 oracle error 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
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 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, just like you, helping each other. Join them; it only takes a minute: Sign up Error while importing an Oracle 9 dump in Oracle 11g up vote 1 down vote favorite I need to import an Oracle9i Release 9.2.0.6.0 dump in an Oracle 11g. Using the import command I have a ton of erros like this: IMP-00017: following statement failed with ORACLE error 6550: "BEGIN SYS.DBMS_EXPORT_EXTENSION.SET_IMP_SKIP_INDEXES_OFF; END;" IMP-00003: ORACLE error 6550 encountered Th command I use is: imp system/