EXPORT ERROR encountered

[muzu1232004]

i got the following
Error message occurred while exporting:


EXP-00008: ORACLE error 1455 encountered

ORA-01455: converting column overflows integer datatype

EXP-00056: ORACLE error 1403 encountered

ORA-01403: no data found

EXP-00000: Export terminated unsuccessfully

Please let me know if any one has encountered it before and how to solve the same.

[debasisdas]

ORA-01455: converting column overflows integer datatype
Cause: The converted form of the specified expression was too large for the specified datatype.
Action: Define a larger datatype or correct the data.

Please find about
ORA-01403 no data found.

[amitpatel66]

Hi,

When I try querying a data from v$session table, I get the same error

ORA-01455: converting column overflows integer datatype

But when I limit the rows to 6, it gives me the output of 6 records but I am not able to query for the whole table.

How we would go about solving this error?
Where do I need to increase the size of the data type??

Thanks
Amit

[debasisdas]

Hi,
When I try querying a data from v$session table, I get the same error
ORA-01455: converting column overflows integer datatype

can u kindly post your query / program for my feference.

[amitpatel66]

Hi,

In TOAD, I execute the below simple Query:

select * from v$session

It throws the below error:

ORA-01455: converting column overflows integer datatype

But when I execute:

select * from v$session where rownum < 5

It gives me 4 records. This is the maximum limit. If i say rownum < 6, it does not work and throws same error.

Thanks
Amit