Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: export fails with invalid column name
what version of db, if on 8i u could do drop column and add it
back.
joe
>>> Harvinder.Singh_at_MetraTech.com 08/08/01 02:30PM
>>>Hi,We have a table in which one of column name and
datatype is change from 1version to next.....like earlier column name is
status number, it is changed to tx_statusraw(16).......when i try to
import this table to new version from export dump of earlierversion....i
am getting error:invalid column name .export fails.........column is
null for all rows........How can i migrate this table to new version
..without using sqlloader.......ThanksHarvinder-- Please
see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com">http://www.orafaq.com-- Author:
Harvinder Singh INET: Harvinder.Singh_at_MetraTech.comFat City
Network Services -- (858) 538-5051 FAX: (858)
538-5051San Diego, California --
Public Internet access / Mailing
Lists--------------------------------------------------------------------ToREMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Received on Wed Aug 08 2001 - 13:05:18 CDT