Skip to main content
Home
Dave's Software and Hardware Projects

Search form

  • home
  • blog
  • notebooks
  • software projects
  • hardware projects
  • recent
  • presentations
  • about
  • !

type conversion

ORA-01440 trying to convert FLOATs to NUMBERs

Submitted by dave on Wed, 04/27/2016 - 12:24

I recently came across a legacy database that was using Oracle FLOAT datatype for Primary and Foreign Keys. As the database needed some attention I was asked to get data types in order and get rid of the FLOATs in favor of NUMBER data types.

Tags: 
type conversion
export
import
  • Read more about ORA-01440 trying to convert FLOATs to NUMBERs
  • dave's blog
  • Add new comment
Subscribe to type conversion

Popular Content

Today's:

  • Pointing a private database link at another database without knowing the password...sorta...
  • Connection encryption is killing my performance! Help!
  • The dreaded ORA-29024: Certificate validation failure... how to approach...
  • oracle.sysman.emSDK.emd.comm.OperationException: could not write to targets.xml.bak file
  • Golden Gate Info
  • "There was a problem creating a SQL tuning task. ORA-13780: SQL statement does not exist. ORA-06512"
  • Archived Log Switch Heat Map for SQL Developer...

Management

  • Comment Approval
  • Top Referrers

User Login

  • Request new password
CAPTCHA
Are you a humanoid?

Content Copyright 2006-2022. Links are copyright of respective owners.