Home » RDBMS Server » Server Administration » EXP-00008: ORACLE error 1406 encountered ORA-01406: fetched column value was truncated EXP-00000: Ex (Oracle database 11G)
EXP-00008: ORACLE error 1406 encountered ORA-01406: fetched column value was truncated EXP-00000: Ex [message #646561] Mon, 04 January 2016 08:26 Go to next message
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 25849
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
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10681
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?
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10681
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 Go to previous messageGo to next message
BlackSwan
Messages: 25849
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?
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 Go to previous message
Michel Cadot
Messages: 65380
Registered: March 2007
Location: Nanterre, France, http://...
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.

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


Current Time: Sun Feb 18 18:17:23 CST 2018

Total time taken to generate the page: 0.03625 seconds