Home » RDBMS Server » Server Utilities » ORA-01406: fetched column value was truncated (Oracle 10g)
ORA-01406: fetched column value was truncated [message #403408] Fri, 15 May 2009 06:54 Go to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Hi,All while taking Full export the following Error occured.

. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
EXP-00008: ORACLE error 1406 encountered
ORA-01406: fetched column value was truncated
EXP-00000: Export terminated unsuccessfully


I googled the Error and the solution is like "expand the column buffer area " But how?

Quote:
ORA-01406: fetched column value was truncated
Cause: In a host language program, a FETCH operation was forced to truncate a character string. The program buffer area for this column was not large enough to contain the entire string. The cursor return code from the fetch was +3.
Action: Increase the column buffer area to hold the largest column value or perform other appropriate processing.


Please let me know how to do this....And At my DB Audit_TRAIL=DB_EXTENDED.Is this because of audit_trail=DB_Extended option enabled?

Thanks & Regards
Sriram

[Updated on: Fri, 15 May 2009 07:07]

Report message to a moderator

Re: ORA-01406: fetched column value was truncated [message #403424 is a reply to message #403408] Fri, 15 May 2009 09:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Bug 4693439.
Check metalink.
If you cannot afford to patch, there is workaround posted in metalink.
Re: ORA-01406: fetched column value was truncated [message #403829 is a reply to message #403424] Tue, 19 May 2009 01:03 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Thanks for your kind reply.
Sriram
Re: ORA-01406: fetched column value was truncated [message #403886 is a reply to message #403829] Tue, 19 May 2009 06:20 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
Mahesh Rajendran

Bug 4693439.
Check metalink.
If you cannot afford to patch, there is workaround posted in metalink.




Quote:
Workaround:
Generate and run the script in
Note 287436.1 SCRIPT Generate AUDIT and NOAUDIT Statements for Current Audit Settings
prior to running export. Revert back to previous audit settings after the export run."



Now my audit settings are set to none(before value).
noaudit all

& i ran noaud.sql script also.

But still getting the same error.

Thanks
Sriram
Re: ORA-01406: fetched column value was truncated [message #403944 is a reply to message #403886] Tue, 19 May 2009 12:54 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Talk to Oracle. Say that the "workaround" is not really working its way around Wink.
I cannot reproduce the case. May be it is worth applying the patch and try your luck again .
Previous Topic: How to loading tab separated,tab delimited datafile with SQLLDR
Next Topic: Privilege issue when running impdp with transportable tablespace
Goto Forum:
  


Current Time: Sun Dec 11 05:58:06 CST 2016

Total time taken to generate the page: 0.07910 seconds