Exp-00056 Oracle Error 12705 Encountered
Contents |
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 ora 12705 invalid or unknown nls parameter value specified or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x exp 00056 oracle error 12154 encountered 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 exp 00056 oracle error 1017 encountered only takes a minute: Sign up Oracle : Use two different versions of EXP on the same machine? up vote 1 down vote favorite i have a server (HP-UX) installed with Oracle 10g and several databases on it. I've been exp 00056 oracle error 1034 encountered asked to make dumps from these tables for a Oracle 8i database. In order to do this, i need to use the 8i version of the EXP (export) tool of Oracle. It is still installed on my server but when i want to use it, i get the following error : EXP-00056: ORACLE error 12705 encountered ORA-12705: Cannot access NLS data files or invalid environment specified I presume some files are missing or maybe one of the folder is not
Ora-12705 Cannot Access Nls Data Files
in the PATH but i can't find and i really don't want to break the 10g installation. Someone knows how to do ? Thanks oracle oracle10g dump ora-12705 share|improve this question edited Apr 9 '11 at 18:35 OMG Ponies 199k37356416 asked Aug 25 '09 at 7:42 Fredv 318619 Is your ORACLE_HOME set correctly? –cagcowboy Aug 25 '09 at 7:43 the problem is my ORACLE_HOME is set up for Oracle 10g and i don't want to change it to the 8i folder .. How could i make both working correctly at the same time ? –Fredv Aug 25 '09 at 8:09 You can't have both at the same time. You can set up a wrapper shell script that sets the Oracle 8 environment then calls exp, isql etc –Mark Aug 25 '09 at 11:14 Sorry to ask you that but have you got an example of such a script ? i'm a bit bad in shell script and oracle and i don't want to break anything :) –Fredv Aug 25 '09 at 11:37 I don't have one for Oracle. but how do you set your environment for 10g - from taht you can duplicate the variables and set them to the 10g version –Mark Aug 30 '09 at 20:57 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote Install a 10G client on anot
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
Ora-12705 Sql Developer
post a blank message. Please type your message and try again. More discussions in error while trying to retrieve text for error ora-12705 General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 Previous Next 18 Replies Latest reply on ora-12705 instant client Jun 29, 2011 5:17 PM by 866787 EXP-00091: Exporting questionable statistics.....pls help 443294 Nov 9, 2005 8:11 AM Hi everyone, recently i exported a schema using teh following command. C:\ exp ofmdba/*****@prod file=c:\ofmdba.dmp http://stackoverflow.com/questions/1326627/oracle-use-two-different-versions-of-exp-on-the-same-machine log=c:\ofmdba.log teh export was sucessful..but when i checked teh logfile.. i found this EXP-00091: Exporting questionable statistics. EXP-00091: Exporting questionable statistics. This message was found for every tables exported..Teh logfile shows that rows of all tables have been exported. i would liek to know whether teh dump file i have is a valid one.Cos i have to give this dump for teh developmentteam for testing. Kindly https://community.oracle.com/thread/341093 help. If this is an error pls tell me how to get around it. The production db is runnin on oracle 9.2.0.4.0 and solaris OS. I had invoked teh export from my remote PC which runs on windows and oracle 9.2.0.1.0 client 36183Views Tags: none (add) databseContent tagged with databse, exportContent tagged with export This content has been marked as final. Show 18 replies 1. Re: EXP-00091: Exporting questionable statistics.....pls help The Human Fly Nov 9, 2005 8:15 AM (in response to 443294) Its only a warning message and you can safely ignore this. If you want to overcome from this, either use statistics=none or statistics=safe. Jaffar Like Show 0 Likes(0) Actions 2. Re: EXP-00091: Exporting questionable statistics.....pls help 427367 Nov 9, 2005 8:15 AM (in response to 443294) This means you might have somewhat dated statistics in the db. It's not an error but you might want to gather more up-to-date stats, preferably with DBMS_STATS. Like Show 0 Likes(0) Actions 3. Re: EXP-00091: Exporting questionable statistics.....pls help 443294 Nov 12, 2005 6:09 AM (in response to 427367) Hi, I tried teh export again this time settin nls_lang env variable to that of teh charset in teh s
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have https://community.oracle.com/community/developer/search.jspa?q=ORA-00056 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 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 00056 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