exp-00008 oracle error 6552 East Arlington Vermont

Address 4991 Vt Route 313 W, Arlington, VT 05250
Phone (802) 375-6497
Website Link
Hours

exp-00008 oracle error 6552 East Arlington, Vermont

SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION; SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0; SQL> update sys.props$ set VALUE$='US7ASCII' where NAME='NLS_CHARACTERSET' SQL> SHUTDOWN; SQL> STARTUP; SQL> SELECT * FROM NLS_DATABASE_PARAMETERS; SQL> select Checking or Converting phrase did not finish successfully No database (national) character set will be altered CSALTER finished unsuccessfully. All rights reserved. > > Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.1.0 - Production > I have been working with PeopleSoft (HRMS/HCM 5, 7, 7.x and 8.9, 9.x), Oracle RDBMS (7.3 - 11gR2) on various Unix and MS-Windows platforms, and some Oracle Application Server (9i -

It basically does the same job, but is the supported tool of choice. Please ensure you have a full backup before initiating this procedure. But one problem occured is that whenever i try to take backup i have this error below: About to export specified users ... . The error is based on a compilation of an object, not in the character set itself.

exporting pre-schema procedural objects and actions > . With the info you provided...I can give you see the below... Creating Individual Exception Report... Now when we are trying to take the backup of a user using exp utility, we are getting stuck up with the below error message.

Report message to a moderator Re: ORA-06553: PLS-553: character set name is not recognized [message #462183 is a reply to message #462173] Wed, 23 June 2010 02:17 Michel Ran the csscan utility. 2. Februar 2004 04:26 schrieb : > Hi > > hello! > > I am export DB and get error : > > $expO dbuser/[email protected] > Export: Release 9.2.0.1.0 - Production on Restarted the database with restrict option. 3.

But when use export again I meet the error below: Code: $ exp \'sys/[email protected] as sysdba\' Export: Release 9.2.0.1.0 - Production on Mon Nov 17 13:25:58 2003 Copyright (c) 1982, 2002, 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 Invision Power Board © 2001-2016 Invision Power Services, Inc. Senior MemberAccount Moderator Quote:SQL> update sys.props$ set VALUE$='US7ASCII' where NAME='NLS_CHARACTERSET' This is the error, now your database is screwed.

exporting foreign function library names for user TA_WEB . Thanks, Adam -- To unsubscribe, email: [email protected] For additional commands, email: [email protected] Please see http://www.suse.com/oracle/ before posting -- To unsubscribe, email: [email protected] For additional commands, email: [email protected] Please see http://www.suse.com/oracle/ before Show 5 replies 1. exporting table BOW_REGISTER_MST EXP-00008: ORACLE error 6552 encountered ORA-06552: PL/SQL: Compilation unit analysis terminated ORA-06553: PLS-553: character set name is not recognized Export terminated successfully with warnings.

Would you like to proceed (Y/N)?y old 6: if (UPPER('&conf') <> 'Y') then new 6: if (UPPER('y') <> 'Y') then Checking data validity... At least that works. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Export done in US7ASCII character set and AL16UTF16 Thanks.

Covered by US Patent. Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use. After change it and also I can run the .bash_profile correctly. exporting foreign function library names for user COIIC .

Regards Michel Report message to a moderator Re: ORA-06553: PLS-553: character set name is not recognized [message #462246 is a reply to message #462198] Wed, 23 June 2010 Do you have a backup from before you updated the data dictionary that you can restore? It may be that there is a character defined within the object (package, procedure, etc....) that is not defined in the new character set. All rights reserved.Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - ProductionEnter array fetch buffer size: 4096 >Export file: expdat.dmp

and why asd how? Maybe this will be the reason I get those errors. I am using Oracle 10.2.0 I am playing "Marcia funebre" :( Thanks! Thanks, Adam -- To unsubscribe, email: [email protected] For additional commands, email: [email protected] Please see http://www.suse.com/oracle/ before posting Next Message by Thread: Re: Using exp and get error"EXP-00008: ORACLE error 6552 encountered"

Senior Member Quote:EXP-00091 Exporting questionable statistics Cause: Export was able to export statistics, but the statistics may not be useable. AnswerHi Shinilkr, The problem appears to be a difference of the database language character set. exporting context namespaces . Today, my PC remotely logs in to the network with Oracle 9.0.1.0.1 client using character set ZHT16MSWIN950 and start export(utility EXP).

As you a soft doctor you should know what are the consequences of your code sriram [Updated on: Wed, 23 June 2010 05:41]Report message to a moderator Re: Regards, Soft_Doctor Report message to a moderator Re: ORA-06553: PLS-553: character set name is not recognized [message #462260 is a reply to message #462246] Wed, 23 June 2010 aussie_dba Oct 11 2007, 03:30 PM It looks like bug 2057772:http://metalink.oracle.com This is a "lo-fi" version of our main content. Code: Export done in US7ASCII character set and AL16UTF16 NCHAR character set server uses UTF8 character set (possible charset conversion) About to export the entire database ... .

Try a bigger buffer size! All rights reserved. Please help Like Show 0 Likes(0) Actions Go to original post Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout Scanner terminated successfully.

Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud To view the full version with more information, formatting and images, please click here. Check metalink. 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

Any ideas what I need to do to the environment so that the installer won't hang? Reply With Quote 11-16-03,23:32 #5 IvanKK View Profile View Forum Posts Registered User Join Date Oct 2003 Posts 4 I still investigate the problem. About UsTell FriendsHow to AskHow to VolunteerFAQTech SupportTop ExpertsExpert LoginBrowse Answers:By CategoryAlphabeticallyFind expert answers to:Find This site uses cookies. 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

exporting pre-schema procedural objects and actions. Senior Member Doctor should know what is 'c' section, before going to do that.