Oracle Error 24801 Encountered
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 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 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
using normal export, Which has throwed me the following error. I have googled to find the solution but end up with no solution. Finally i tried export the table using datapump.My issue got resolved. Error: EXP-00056: ORACLE error 24801 encountered ORA-24801: illegal parameter value in OCI lob function EXP-00222: Solution: The only soution is Use datapump to export. Posted by Antony Ankrose J at 7:11 AM No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Pages Home About Me Antony Ankrose J All that I know is that I know nothing. View my complete profile Search This Blog https://community.oracle.com/community/developer/search.jspa?q=ORA-24801 Loading... Blog Archive ► 2015 (6) ► August (3) ► Aug 30 (2) ► Aug 18 (1) ► July (3) ► Jul 10 (1) ► Jul 03 (2) ► 2014 (3) ► March (3) ► Mar 29 (1) ► Mar 25 (1) ► Mar 03 (1) ► 2013 (3) ► June (1) ► Jun 29 (1) ► April (2) ► Apr 18 (1) ► Apr 11 (1) ► 2012 (14) http://ankrose.blogspot.com/2011/12/ora-24801-illegal-parameter-value-in.html ► November (1) ► Nov 08 (1) ► October (1) ► Oct 20 (1) ► September (5) ► Sep 04 (3) ► Sep 01 (2) ► August (3) ► Aug 30 (2) ► Aug 20 (1) ► July (2) ► Jul 25 (2) ► February (1) ► Feb 14 (1) ► January (1) ► Jan 03 (1) ▼ 2011 (24) ▼ December (6) ► Dec 28 (2) ► Dec 20 (1) ▼ Dec 19 (1) ORA-24801: illegal parameter value in OCI lob func... ► Dec 13 (2) ► November (4) ► Nov 11 (1) ► Nov 10 (2) ► Nov 01 (1) ► October (2) ► Oct 27 (1) ► Oct 24 (1) ► September (7) ► Sep 29 (1) ► Sep 27 (1) ► Sep 23 (1) ► Sep 22 (1) ► Sep 08 (2) ► Sep 07 (1) ► August (2) ► Aug 30 (1) ► Aug 28 (1) ► July (3) ► Jul 18 (1) ► Jul 16 (2) ► 2010 (20) ► November (1) ► Nov 09 (1) ► September (1) ► Sep 29 (1) ► June (5) ► Jun 11 (1) ► Jun 10 (1) ► Jun 07 (1) ► Jun 02 (2) ► May (1) ► May 05 (1) ► April (1) υ
to friend problem with export illegal parameter value in OCI lob function [message #490207] Fri, 21 January 2011 16:38 miroconnect@yahoo.com Messages: 202Registered: April 2006 Senior Member We are http://www.orafaq.com/forum/t/165079/ trying to export our production data . We got this error . http://oracledba.bigresource.com/Server-Utilities-export-illegal-parameter-value-in-OCI-lob-function--UsAa9fQxs.html . exporting table EA_BLOB EXP-00056: ORACLE error 24801 encountered ORA-24801: illegal parameter value in OCI lob function please tell me how to overcome this error ? Report message to a moderator Re: problem with export illegal parameter value in OCI lob function [message #490210 is a reply oracle error to message #490207] Fri, 21 January 2011 17:02 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member >please tell me how to overcome this error ? file a Service Request with Oracle Support. Report message to a moderator Re: problem with export illegal parameter value in OCI lob function [message #490221 is a reply to message #490207] Sat, 22 oracle error 24801 January 2011 00:27 Michel Cadot Messages: 63911Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator ORA-24801: illegal parameter value in OCI lob function *Cause: One of the parameter values in the OCI lob function is illegal. *Action: Check every parameter in the OCI Lob function call to make sure they are correct. Offsets should be greater than or equal to one. As Blackswan said, this smells a bug. Regards Michel Report message to a moderator Previous Topic: Pre-requisite For Oracle Critical Patch Updates Next Topic: imp Issue Goto Forum: - SQL & PL/SQLSQL & PL/SQLClient Tools- RDBMS ServerServer AdministrationBackup & RecoveryPerformance TuningSecurityNetworking and GatewaysEnterprise ManagerServer Utilities- Server OptionsRAC & FailsafeData GuardReplicationStreams & AQSpatialText & interMedia- Developer & ProgrammerApplication Express, ORDS & MOD_PLSQLFormsReports & DiscovererDesignerJDeveloper, Java & XMLWarehouse BuilderPrecompilers, OCI & OCCI- Fusion Middleware & Colab SuiteWeblogic & Application ServerBusiness IntelligenceWebCenter Suite & PortalCollaboration & Content ManagementSOA Suite, BPEL and OWSM- ApplicationsOracle Fusion Apps & E-Business SuitePeopleSoft, JD Edwards & SiebelPrimaveraOther Application Suites- InfrastructureHardwareUnixLinuxWindowsOther Operating Systems- Open SourceProgramming InterfacesMySQL- OtherGeneralTraining & CertificationMarketplaceCommunity HangoutSuggestions & FeedbackTest- Non-English ForumsArabicDutchFrenchGermanJapanesePortugueseRussianSpanish -=] Ba
error 24801 encountered ORA-24801: illegal parameter value in OCI lob function how to overcome this error ? View 2 Replies Similar Messages: Server Utilities :: Query Parameter - Export Subset Of Table Using RowID Server Utilities :: Export Procedure Views Function And Packages In Database Oracle 11g Client / ORA-12533 Illegal ADDRESS Parameter Server Utilities :: How To Create Parameter Files Server Utilities :: Import With Buffer Parameter Export/Import/SQL Loader :: Expdp Command To Export Table By Specifying Query Parameter Server Utilities :: Exporting Schema Using Consistent Parameter Server Utilities :: ROWS Command Line Parameter Server Utilities :: Exporting Schema Using Filesize Parameter? Export/Import/SQL Loader :: Export Consistent Parameter Server Utilities :: Syntax Error In Using Query Parameter In Expdp Server Utilities :: Export Schemas From 10g To 11g? Server Utilities :: Export Error? Export/Import/SQL Loader :: How To Filter Some Illegal Rows When Import Data Server Utilities :: Export Sequence Using Expdp Server Utilities :: Export / Import Errors? Server Utilities :: Export Data From Excel To 10g? Server Utilities :: Import / Export Log File Server Utilities :: How To Monitor Export And Import Job Server Utilities :: Conflicting In Parameters Of Export Server Utilities :: Export Multiple Tables Only? Server Utilities :: Export XML Object Using Datapump Server Utilities :: Export From Sql And Import Into Oracle 9i Server Utilities :: Export Schema Error? Server Utilities :: Export / Import Backup Server Utilities :: Snapshot Error During Export Server Utilities :: Time Taken In Export And Import? Server Utilities :: Export Dump File Server Utilities :: Export And Import From 10g To 9i Server? ADVERTISEMENT Server Utilities :: Query Parameter - Export Subset Of Table Using RowID Aug 15, 2012 I am exporting using query parameter. I am trying to export subset of table using rowid.SQL> select rowid , name from tab1;ROWID NAME------------------ ---------------AAAM0rAAEAAAAGMAAA samAAAM0rAAEAAAAGMAAB sonaAAAM0rAAEAAAAGMAAC roseAAAM0rAAEAAAAGMAAD chrisAAAM0rAAEAAAAGMAAE san.................. ...................... ....command given as exp sam/sam tables=tab1 file=exprwid.dmp query="where ROWID='AAAM0rAAEAAAAGMAAA'" log=log1.logExport done in US7ASCII character set and AL16UTF16 NCHAR character setserver uses WE8ISO8859P1 character set (possible charset conversion)About to export specified tables via Conventional Path .... .