OraFAQ Forum: Server Utilities » ORA-01406: fetched column value was truncated

Home » RDBMS Server » Server Utilities » ORA-01406: fetched column value was truncated (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01406: fetched column value was truncated [message #403408]

Fri, 15 May 2009 06:54

ramoradba
Messages: 2457
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

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: ORA-01406: fetched column value was truncated [message #403829 is a reply to message #403424]

Tue, 19 May 2009 01:03

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Thanks for your kind reply.
Sriram

Report message to a moderator

Re: ORA-01406: fetched column value was truncated [message #403886 is a reply to message #403829]

Tue, 19 May 2009 06:20

ramoradba
Messages: 2457
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

Report message to a moderator

Re: ORA-01406: fetched column value was truncated [message #403944 is a reply to message #403886]

Tue, 19 May 2009 12:54

Mahesh Rajendran
Messages: 10708
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 .

Report message to a moderator

Previous Topic:	How to loading tab separated,tab delimited datafile with SQLLDR
Next Topic:	Privilege issue when running impdp with transportable tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 17:18:30 CST 2025