OraFAQ Forum: Server Utilities » unable to change field type

Home » RDBMS Server » Server Utilities » unable to change field type - urgent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

unable to change field type - urgent [message #69548]

Wed, 30 January 2002 10:32

riz1
Messages: 2
Registered: January 2002

Junior Member

Hi
I'm trying to upload data from TXT file, bud due to data quality I change the date field to varchar2 and it's working fine. But after successfull upload I'm unable to change VARCHAR2 to DATE. I'll appreciate if any one who can help me

Report message to a moderator

Re: unable to change field type - urgent [message #69549 is a reply to message #69548]

Wed, 30 January 2002 11:33

Mike
Messages: 417
Registered: September 1998

Senior Member

Could you be a little bit more precise about what you want to do exactly?
Do you want to replace a varchar2 column by a date column?
What do you want to change?

Report message to a moderator

Re: unable to change field type - urgent [message #69551 is a reply to message #69548]

Wed, 30 January 2002 12:28

riz1
Messages: 2
Registered: January 2002

Junior Member

Hi
I found the solution, in ERWIN. know the problem is that lots of table require changes in field and I'm unable to do this in a single job using ERWIN. do you have any experience.

Report message to a moderator

Re: unable to change field type - urgent [message #69711 is a reply to message #69548]

Sat, 23 February 2002 02:53

Manjunath
Messages: 9
Registered: July 2000

Junior Member

HI,
In case of uploading there is no need to change a date field to varachar2. For this just u update ur control file and make where ever u r having date fields as fil_date DATE 'DD-MM-YYYY HH24:MI:SS'

for eg :-
LOAD DATA
INFILE '/users2/manjudv/lst/GCTSIS_20020220.lst'
APPEND INTO TABLE GCTSIS
FIELDS TERMINATED BY '^T'
(
Field1 char(2),
Filed_dt DATE 'DD-MM-YYYY HH24:MI:SS',
Field2 char
)

Hope this may solve ur problem

Report message to a moderator

Previous Topic:	Re: Error 1053: The service did not respond to the start or control request in a timely fashion.
Next Topic:	sqlloader problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 06:34:48 CDT 2024