Export/Import issues

I am attempting to export a table,change a couple of data types the import the table. I am getting variuos errors (on the import) Oracle 1401,ORACLE 2298. What I think I need to do is export the data,drop the table, run script to recreate the table with the changes to the data type then import the data only. What setting in IMPORT allows you to only imort the data?

Try:

IGNORE=Y
;)

and if you are using impdp then ...

table_exists_action=ignore

also need to double check the data type changes. if you reduce the value for ex. varchar2(20) to varchar2(10) import will fail.

Thanks,

I have that in the import script already.
imp adbase/adbase@alan file=110909.dmp ignore=y fromuser=adbase commit=y constraints=n destroy=n buffer=10240000 log=ADBASE_IMP_AOADORD.log

I am changing the data type from FLOAT(126) to VARCHAR(20) would that cause a problem?

what is the max length or the column with float data type?

Thanks,

Not sure how to determine that

select length from ;

Thanks,

Quote:

---

select length (float_data_type_column_name) from table_name;

---

Thanks,

Looks like 15

If the max length of that column is 15 then there will be no issues converting it to varchar2(20).

Thanks,