OraFAQ Forum: Server Administration » EXP-00008: ORACLE error 1406 encountered ORA-01406: fetched column value was truncated EXP-00000: Ex

Home » RDBMS Server » Server Administration » EXP-00008: ORACLE error 1406 encountered ORA-01406: fetched column value was truncated EXP-00000: Ex (Oracle database 11G)

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

EXP-00008: ORACLE error 1406 encountered ORA-01406: fetched column value was truncated EXP-00000: Ex [message #646561]

Mon, 04 January 2016 08:26

oracle2013
Messages: 15
Registered: July 2013
Location: Hyderabad

Junior Member

I have Oracle 11g database. while trying to dump file for backup of oracle server getting below error .Please reply me ASAP.

EXP-00008: ORACLE error 1406 encountered
ORA-01406: fetched column value was truncated
EXP-00000: Export terminated unsuccessfully
tell them we are having this issue
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
EXP-00008: ORACLE error 1406 encountered
ORA-01406: fetched column value was truncated
EXP-00000: Export terminated unsuccessfully
you send them these lines
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
EXP-00008: ORACLE error 1406 encountered
ORA-01406: fetched column value was truncated
EXP-00000: Export terminated unsuccessfully

Thanks
Hidayath

Report message to a moderator

Re: EXP-00008: ORACLE error 1406 encountered ORA-01406: fetched column value was truncated EXP-00000: Ex [message #646562 is a reply to message #646561]

Mon, 04 January 2016 08:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

Report message to a moderator

Re: EXP-00008: ORACLE error 1406 encountered ORA-01406: fetched column value was truncated EXP-00000: Ex [message #646563 is a reply to message #646561]

Mon, 04 January 2016 08:34

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

This is supposed to be a bug with previous versions.
Your post says, you are using 11g.
Are you sure?
Probably you are using a lower/unsupported version of Oracle client against 11g database?

Report message to a moderator

Re: EXP-00008: ORACLE error 1406 encountered ORA-01406: fetched column value was truncated EXP-00000: Ex [message #646564 is a reply to message #646563]

Mon, 04 January 2016 08:36

oracle2013
Messages: 15
Registered: July 2013
Location: Hyderabad

Junior Member

Dear Mahesh,

Yes.I am using 11g database.Please give me exact solution.

Thanks
Hidayath

Report message to a moderator

Re: EXP-00008: ORACLE error 1406 encountered ORA-01406: fetched column value was truncated EXP-00000: Ex [message #646565 is a reply to message #646564]

Mon, 04 January 2016 08:39

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>tell them we are having this issue
>>you send them these lines

These are not a part of log.

Please post the command you used, complete log, along with version/characterset info from the log/relevant information.
And Please format the post.

[Updated on: Mon, 04 January 2016 08:44]

Report message to a moderator

Re: EXP-00008: ORACLE error 1406 encountered ORA-01406: fetched column value was truncated EXP-00000: Ex [message #646568 is a reply to message #646564]

Mon, 04 January 2016 08:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

oracle2013 wrote on Mon, 04 January 2016 06:36

Dear Mahesh,

Yes.I am using 11g database.Please give me exact solution.

Thanks
Hidayath

we can not know exact fix without exact command issued & without see exact & complete response from export command.

was exp or expdp issued?

Report message to a moderator

Re: EXP-00008: ORACLE error 1406 encountered ORA-01406: fetched column value was truncated EXP-00000: Ex [message #646572 is a reply to message #646564]

Mon, 04 January 2016 09:53

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post the command line and the first 10 lines of the log.
Before, Please read How to use [code] tags and make your code easier to read.

Report message to a moderator

Previous Topic:	Listener TNS-00515: Connect failed because target host or object does not exist
Next Topic:	Partitioning Tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 04 19:25:34 CST 2025