Search code examples
oracle-databaseoracle-sqldeveloperimport-table

SQL: Invalid column names

I am trying to upload a table, and it is giving me the error message: "The following new table has invalid names: ". It did not point out which one is invalid. All my column names are words. Not sure what rules can I possibly violate. Below is a screenshot.

enter image description here

DMS NOTDMS engine arsenic sediment cartilage articular bone freight solutions neutrino heart stripe plasma indoor calcium power fixture eye chloride tellurium alloys egg corrosion market antenna metal ice quantum invasibility interrupt ventilation ammonia pollen syringae text auxin editing compression copper dpp clock enduring taxes blue kinase dolomite meristem isoprene proteins halo context information type detector oxygen invariants aequorin attractors ribosome actin cellulose tubulin binding site disulfide midgut alternative oxidase fischeri agreement snow cements excluded attitudes law nucleotide music homotopy periplasmic translocation stomatal phosphoprotein flagellar late motors operons replication sigma recombination streamflow fluidity police muscle blood heme replicative kelps estrogen elderly witnesses fire splicing scaffolding subunits erosion reef climate abnormal operator holographic braided seeding kidney cortical photonic functor homology river alluvial sand inlet import nitrogenase aleurone maturation guard light inositol membrane clay lightning recycling amoebae dyneins thioredoxin coat 3-manifolds mercury diving sludge sources fluorine conductivity hydraulic glucose designs condensate amorphous treeline

Solution

  • Short version:

    • column names are not the problem
    • title of error messages may indicate that not every record has the datatype you want them to be

    I imported a flat-file (csv) with the same column-names you provided above using microsoft sql server 2008 R2 Express. The import worked fine; every column names was imported. Could it be that your column names have some non-visible characters that are causing the trouble?

    If you provide more information we can help better.

    • which version of sql server are you using
    • provide the source of your file
    • provide additional error information and the way you are importing the file

    My answer is that the column names are not the problem - at least not with sql server 2008 R2 express.