473,387 Members | 1,535 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

EXPORT ERROR encountered

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.
Aug 29 '07 #1
4 14236
debasisdas
8,127 Expert 4TB
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
.
Aug 29 '07 #2
amitpatel66
2,367 Expert 2GB
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
Aug 29 '07 #3
debasisdas
8,127 Expert 4TB
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.
Aug 29 '07 #4
amitpatel66
2,367 Expert 2GB
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
Aug 29 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Tim Jones | last post by:
Hey all, I am trying to try get a crytal report running properly. A "Hello World" report that does not add criteria to the record selection formula of the report (either in the development tool,...
0
by: CS | last post by:
I am having a problem cataloging a Linux server from WinXP Control Center. Can add the system, however do not see any available instances and the following shows up in the db2diag.log: ...
0
by: Leonard Danao | last post by:
Anyone have any ideas as to why this is happenning. There are no other versions of Crystal installed aside from the one that came with vs2003 enterprise. the error happens when the...
1
by: Punker | last post by:
Hi guys, I am trying to create export specifications for one of my queries. Now when I run the query on its own, it works perfectly. However when I try to export the data I get back the error...
1
by: KoolAidGrrl | last post by:
Hello, Currently have a Window Services program in ASP.Net and C#. It automatically runs a procedure to export a XML file and I gave been receiving this error every time it runs ...
0
by: Jim Coyne | last post by:
Is there a way to have the data controls re-populated with the previous data if an error was encountered during an insert? I currently have the following code to display the error message, but...
1
by: bharathreddy | last post by:
hai all, I would like to share a small but yet valuable information about FAXCOM.dll to send fax. We can send FAX using either through modem or using mailserver. I have used modem to send...
0
by: tmcgurg | last post by:
I'm attempting to run this sql through WinSql. export to orders.del of del select * from session.temp_emp ; The session.temp_emp is a temporary table. I'm trying to extract the records out...
5
by: lunie | last post by:
Hello, anyone please help me. I have an oralce database and using forms6i to upload the data in SAP 560 system. But i always encountered this message. Just wonder because i dont encountered any error...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.