OS= Win NT
Oracle ver= 8.1.6.1.0

Howdy boys and girls. I have a weird error when trying to do an import from the same database. I exported the data and changed the table column names, not the types but the names and now I am getting this error. The .DMP file came from the same tables.
Basically I added a few columns and changed the QTY to QY on some column names. I did this by dropping and re-creating the table.
Suggestions??

BEFORE
Name Null? Type
------------------------------- -------- ----
MARKET_ID NOT NULL NUMBER(10)
PQS_SEG_START_DATE DATE
PQ_ID NOT NULL VARCHAR2(10)
PQS_ID NOT NULL VARCHAR2(8)
PROD_GRP_TYPE_CD NOT NULL CHAR(4)
PQS_SEG_ID NOT NULL CHAR(2)
MKT_SEG_CD NOT NULL CHAR(3)
BASIS_TYPE_CD NOT NULL CHAR(1)
PERIOD_TYPE_CD NOT NULL CHAR(3)
PRICE_DRV_MIN_QTY NOT NULL NUMBER(18,4)
PROD_ID NOT NULL NUMBER(10)
MKT_SEG_EFF_DATE NOT NULL DATE
PROD_OFFER_EFF_DATE NOT NULL DATE
ZONE NOT NULL CHAR(3)
BILLING_OPTION_TYPE_CD NOT NULL CHAR(2)
ACCESSORY_IR NOT NULL CHAR(1)
PROD_CD CHAR(4)
PROD_ATTR_1_ID NUMBER(10)
PROD_ATTR_2_ID NUMBER(10)
PROD_ATTR_3_ID NUMBER(10)
PROD_ATTR_4_ID NUMBER(10)
PROD_ATTR_5_ID NUMBER(10)
PROD_ATTR_6_ID NUMBER(10)
PRICE_DRV_MAX_QTY NUMBER(18,4)
MEASURE_UNIT_CD CHAR(2)
CURRENCY_CD CHAR(3)
AMOUNT NUMBER(15,2)
PRICE_TYPE_CD CHAR(1)
PRICE_MEASURE_UNIT_CD CHAR(2)
AMOUNT_FLOOR NUMBER(15,2)
AMOUNT_CEILING NUMBER(15,2)
PG_PLAN_ID VARCHAR2(40)
AMOUNT_APPROVED NUMBER(15,2)
AMOUNT_REQ NUMBER(15,2)
AMOUNT_EQUIV NUMBER(15,2)
PQS_TIER_ID NUMBER(9)
REIMB_MTH_TYP_CD CHAR(1)
ACT_ROLLUP_IR CHAR(1)
ROLLUP_PRD_QY NUMBER(5)
WK_AVG_INCL_CURR_WK_IR CHAR(1)
USE_HIST_IR CHAR(1)
TIER_TYP_CD CHAR(1)
PG_PLAN_TYPE_CD CHAR(1)
AMOUNT_REC NUMBER(15,2)
AMOUNT_MAX NUMBER(15,2)
AMOUNT_1 NUMBER(18,4)
AMOUNT_2 NUMBER(18,4)
AMOUNT_3 NUMBER(18,4)
PRICE_PLAN_ID NUMBER(10)
AMOUNT_EQUIV_APPROVED NUMBER(15,2)
LNE_NR NOT NULL VARCHAR2(10)
NCV_MIN_RPP_HIN_CD NOT NULL CHAR(2)


AFTER...

Name Null? Type
------------------------------- -------- ----
MARKET_ID NOT NULL NUMBER(10)
PQS_SEG_START_DATE DATE
PQ_ID NOT NULL VARCHAR2(10)
PQS_ID NOT NULL VARCHAR2(8)
PROD_GRP_TYPE_CD NOT NULL CHAR(4)
PQS_SEG_ID NOT NULL CHAR(2)
MKT_SEG_CD NOT NULL CHAR(3)
BASIS_TYPE_CD NOT NULL CHAR(1)
PERIOD_TYPE_CD NOT NULL CHAR(3)
PRICE_DRV_MIN_QY NOT NULL NUMBER(18,4)
PROD_ID NOT NULL NUMBER(10)
MKT_SEG_EFF_DATE NOT NULL DATE
PROD_OFFER_EFF_DATE NOT NULL DATE
ZONE NOT NULL CHAR(3)
BILLING_OPTION_TYPE_CD NOT NULL CHAR(2)
ACCESSORY_IR NOT NULL CHAR(1)
PROD_CD CHAR(4)
PROD_ATTR_1_ID NUMBER(10)
PROD_ATTR_2_ID NUMBER(10)
PROD_ATTR_3_ID NUMBER(10)
PROD_ATTR_4_ID NUMBER(10)
PROD_ATTR_5_ID NUMBER(10)
PROD_ATTR_6_ID NUMBER(10)
PRICE_DRV_MAX_QY NUMBER(18,4)
MEASURE_UNIT_CD CHAR(2)
CURRENCY_CD CHAR(3)
AMOUNT NUMBER(15,2)
PRICE_TYPE_CD CHAR(1)
PRICE_MEASURE_UNIT_CD CHAR(2)
AMOUNT_FLOOR NUMBER(15,2)
AMOUNT_CEILING NUMBER(15,2)
PG_PLAN_ID VARCHAR2(40)
AMOUNT_APPROVED NUMBER(15,2)
AMOUNT_REQ NUMBER(15,2)
AMOUNT_EQUIV NUMBER(15,2)
PQS_TIER_ID NUMBER(9)
REIMB_MTH_TYP_CD CHAR(1)
ACT_ROLLUP_IR CHAR(1)
ROLLUP_PRD_QY NUMBER(5)
WK_AVG_INCL_CURR_WK_IR CHAR(1)
USE_HIST_IR CHAR(1)
TIER_TYP_CD CHAR(1)
PG_PLAN_TYPE_CD CHAR(1)
AMOUNT_REC NUMBER(15,2)
AMOUNT_MAX NUMBER(15,2)
AMOUNT_1 NUMBER(18,4)
AMOUNT_2 NUMBER(18,4)
AMOUNT_3 NUMBER(18,4)
PRICE_PLAN_ID NUMBER(10)
AMOUNT_EQUIV_APPROVED NUMBER(15,2)
LNE_NR NOT NULL VARCHAR2(10)
NCV_MIN_RPP_HIN_CD NOT NULL CHAR(2)
NCV_MAX_APV_DCT_PR NUMBER(15,2)
NCV_MAX_APE_DCT_PR NUMBER(15,2)




ORA-00904 invalid column name
Sorry the table is so long, is this a known bug?

Thanks in advance again,

MH