Oracle Error 6552 Encountered
be sure to check out 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 selection below. Results 1 to 8 of 8 Thread: Export Error After Change Character Set Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-28-03,02:02 #1 IvanKK View Profile View Forum Posts Registered User Join Date Oct 2003 Posts 4 Unanswered: Export Error After Change Character Set In Oracle 9.02 environment, after performing alter character set in database process(Export entire database, drop user A, alter character set[ZHT16BIG5 to ZHT16MSWIN950] , restart Oracle, create user A, import all information of user A), export using EXP command with following errors: . exporting tablespaces definitions ... .exporting PUBLIC type synonyms EXP-00008: ORACLE error 6552 encountered ORA-06552: PL/SQL: Compilation unit analysis termintated ORA-06553: PLS-553: character set name is not recognised EXP-00000: Export terminated unsuccessfully Pls reply with the cause with solution as well. Thanks! Reply With Quote 10-28-03,14:16 #2 mommydba View Profile View Forum Posts Registered User Join Date Oct 2003 Posts 3 Re: Export Error After Change Character Set Did you check to see if there were any invalid objects after reimporting the user? The error is based on a compilation of an object, not in the character set itself. It may be that there is a character defined within the object (package, procedure, etc....) that is not defined in the new character set. Reply With Quote 10-28-03,23:51 #3 IvanKK View Profile View Forum Posts Registered User Join Date Oct 2003 Posts 4 Re: Export Error After Change Character Set Originally posted by mommydba Did you check to see if there were any invalid objects after reimporting the user? The error is based on a compilation of an object, not in the character set itself. It may be that there is a character defined within the object (package, procedure, etc....) that i
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. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 5 Replies Latest reply on Nov 30, 2008 6:23 AM by 636270 "Character set name is not recognized" 670262 Nov 13, 2008 11:31 AM Hello! I changed the character http://www.dbforums.com/showthread.php?958948-Export-Error-After-Change-Character-Set set of my database with: "update sys.props$ set VALUE$="..." where NAME="NLS_CHARACTERSET" The problem is that when I try to do a backup with "exp user/pass userid=... file=..." I obtain this error: .... . exporting pre-schema procedural objects and actions . exporting foreign function library names for user COIIC . exporting PUBLIC type synonyms EXP-00008: ORACLE error 6552 encountered ORA-06552: PL/SQL: Compilation https://community.oracle.com/thread/828144 unit analysis terminated ORA-06553: PLS-553: character set name is not recognized EXP-00000: Export terminated unsuccessfully Why? Thanks. I have the same question Show 0 Likes(0) 1477Views Tags: none (add) characteerContent tagged with characteer, databaseContent tagged with database, expContent tagged with exp, exportContent tagged with export, ora-06553Content tagged with ora-06553, pls-553Content tagged with pls-553, setContent tagged with set This content has been marked as final. Show 5 replies 1. Re: "Character set name is not recognized" 153119 Nov 13, 2008 11:56 AM (in response to 670262) Your question can not be answered First of all: you followed an unsupported procedure to change the characterset. Why didn't you use the ALTER DATABASE characterset command? At least that works. Secondly: you don't specify in what you changed it (probably into something which is not in v$nls_valid_values), nor do you specify the value of your NLS_LANG environment variable nor your version nor you OS etc. One can only hope you have a valid backup. Otherwise it is time for the Marcia funebre, which was so solemnly played when Soviet-leaders were interred in
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a https://www.experts-exchange.com/questions/24544748/Error-when-trying-to-export-database-characterset-not-recognized.html Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing http://database.sarang.net/?inc=read&aid=18747&criteria=oracle&subcrit=&id=&limit=&keyword=&page= Store Headlines Experts Exchange > Questions > Error when trying to export database - characterset not recognized Want to Advertise Here? Solved Error when trying to export database - characterset oracle error not recognized Posted on 2009-07-05 Oracle Database Databases 4 Verified Solutions 6 Comments 1,742 Views Last Modified: 2013-12-19 Hello, My problem as follows: i recently changed character set from ARABIC_BAHRAIN.AR8MSWIN1252 to ARABIC_BAHRAIN.AR8MSWIN1252,, and everything went fine according to have arabic enabled on the db. But one problem occured is that whenever i try to take backup i have this error oracle error 6552 below: About to export specified users ... . exporting pre-schema procedural objects and actions . exporting foreign function library names for user testuser . exporting PUBLIC type synonyms EXP-00008: ORACLE error 6552 encountered ORA-06552: PL/SQL: Compilation unit analysis terminated ORA-06553: PLS-553: character set name is not recognized EXP-00000: Export terminated unsuccessfully I tried dropping user and re-create again ,, but same problem still appears. Thanks 0 Question by:Abu Hamdan Facebook Twitter LinkedIn Google LVL 1 Best Solution byelkhawajah The NLS_LANG of the other database that you are exporting to should have the same character set as the exporting from database.. Go to Solution 6 Comments LVL 1 Overall: Level 1 Oracle Database 1 Message Accepted Solution by:elkhawajah2009-07-05 The NLS_LANG of the other database that you are exporting to should have the same character set as the exporting from database.. 0 LVL 6 Overall: Level 6 Oracle Database 6 Databases 1 Message Assisted Solution by:Greg Clough2009-07-05 Could you please re-post the character sets that you changed from/to, as those in the question are identical. Could you a
Informix Sybase MS-SQL DB2 Cache CUBRID LDAP ALTIBASE Tibero DB 문서들 스터디 Community 공지사항 자유게시판 구인|구직 DSN 갤러리 도움주신분들 Admin 운영게시판 최근게시물 오류 요청하신 페이지의 주소가 타당치 못해서 바르게 처리하질 못했습니다.페이지 주소를 다시 한번 확인해 보시고 바르게 호출해 주십시오. All about the DATABASE... Copyleft 1999-2016 DSN, All rights reserved. 작업시간: 0.041초,