Foxpro Memo field type and Oracle8i...

[dejanj]

Hi All,

Can anybody tell me how to upsize this 2 tables in Oracle8i from Visual Foxpro 6.
They both uses Memo fields. What field type should i use in Oracle8i?


FUNCTION MakeTable_SGCCELOG
***** Table setup for SGCCELOG *****
CREATE TABLE 'SGCCELOG.DBF' NAME 'SGCCELOG' (USER C(10) NOT NULL, ;
PREFIX C(3) NOT NULL, ;
ERR_DATE T NOT NULL, ;
ERR_NO N(4, 0) NOT NULL, ;
ERR_MESS M NOT NULL, ;
CUR_PROG M NOT NULL, ;
LINE_NO N(6, 0) NOT NULL, ;
LINE_CODE M NOT NULL, ;
TOP_WINDOW M NOT NULL, ;
GET_FIELD C(10) NOT NULL, ;
LAST_KEY N(4, 0) NOT NULL, ;
CUR_MEMORY M NOT NULL, ;
CUR_STATUS M NOT NULL)

***** Create each index for SGCCELOG *****
SET COLLATE TO 'MACHINE'
INDEX ON TTOC(ERR_DATE,1)+USER+PREFIX TAG DATE_ASC
INDEX ON STR(100000000000000-VAL(TTOC(ERR_DATE,1)),14)+USER+PREFIX TAG DATE_DESC

***** Change properties for SGCCELOG *****
ENDFUNC

FUNCTION MakeTable_SGCCSUSR
***** Table setup for SGCCSUSR *****
CREATE TABLE 'SGCCSUSR.DBF' NAME 'SGCCSUSR' (ENCRYPTED C(132) NOT NULL, ;
PW_PRIOR M NOT NULL, ;
LANG_ID C(3) NOT NULL, ;
L_USERSEL M NOT NULL)

***** Create each index for SGCCSUSR *****
SET COLLATE TO 'MACHINE'
INDEX ON SUBSTR(ENCRYPTED,15,10) TAG USER_ID
INDEX ON SUBSTR(ENCRYPTED,5,10) TAG USER_NO
INDEX ON LANG_ID TAG LANG_ID

***** Change properties for SGCCSUSR *****
ENDFUNC

Help is very much appreciated.

Thanks

Dejan Jocic