Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
ORA-01460: unimplemented or unreasonable conversion requested

ORA-01460: unimplemented or unreasonable conversion requested

2004-09-13       - By Koivu, Lisa

Reply:     1     2  

Hi Sami,=20

What is the statement? I 've seen this before when the statement
included a number conversion to a format that wasn 't valid.=20

Lisa Koivu
Database Monkey
Orlando, FL, USA


-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Sami Seerangan
Sent: Monday, September 13, 2004 10:15 AM
To: Oracle Discussion List
Subject: ORA-01460 (See ORA-01460.ora-code.com): unimplemented or unreasonable conversion requested

Hi All,

If we try to perform any operation on a particular table, we are keep
getting "ORA-01460 (See ORA-01460.ora-code.com): unimplemented or unreasonable conversion
requested "

What could be wrong here? If it is related to data block corruption
how to identify the block which got corrupted.

Thanks in advance
--=20
Sami Seerangan
Oracle DBA
--
To unsubscribe -
mailto:oracle-l-request@(protected)&subject=3Dunsubscribe=20
To search the archives - http://www.freelists.org/archives/oracle-l/

"The sender believes that this E-Mail and any attachments were free of an=
y virus, worm, Trojan horse, and/or malicious code when sent. This messag=
e and its attachments could have been infected during transmission. By r=
eading the message and opening any attachments, the recipient accepts ful=
l responsibility for taking proactive and remedial action about viruses a=
nd other defects. The sender 's business entity is not liable for any loss=
=20or damage arising in any way from this message or its attachments. "
--
To unsubscribe - mailto:oracle-l-request@(protected)&subject=unsubscribe
To search the archives - http://www.freelists.org/archives/oracle-l/