Upsize to Oracle 8i

[dejanj]

Hi All,

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

I am using VFP7.

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 much appreciated.

Thanks

Dejan Jocic

 

[jimoo]

If you don't get the answer in this forum, try the Forum, "Oracle ERP Solutions"

Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[jimoo]

I found this site, which may assist. I did not dig to far into it, but it looks like a lot of PDF files on Oracle.

http://www.db.cs.ucdavis.edu

Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[dejanj]

Hi Jim,

Thanks for help. It is appreciated. I posted my Q. on Oracle ERP Solutions forum but no luck. I 've found that i can use LONG data type in ORACLE for Foxpro's Memo. Oracle8i states that you can have only 1 LONG per table. I have created table

CREATE TABLE "GCC"."SGCCELOG"("USER" VARCHAR2(10) NOT NULL,
"PREFIX" VARCHAR2(3) NOT NULL, "ERR_DATE" DATE NOT NULL,
"ERR_NO" NUMBER(4) NOT NULL, "ERR_MESS" VARCHAR2(4000) NOT NULL,
"CUR_PROG" VARCHAR2(4000) NOT NULL, "LINE_NO" NUMBER(6) NOT NULL,
"LINE_CODE" VARCHAR2(4000) NOT NULL, "TOP_WINDOW" VARCHAR2(4000)
NOT NULL, "GET_FIELD" VARCHAR2(10) NOT NULL, "LAST_KEY" NUMBER(
4) NOT NULL, "CUR_MEMORY" LONG NOT NULL, "CUR_STATUS" VARCHAR2(
4000) NOT NULL)

in Oracle. Looking at my data in Foxpro CUR_MEMORY field can easy get over 4000 char so that is OK. Problem is CUR_STATUS which is usually 3000.

Do you know if i can use BLOB or CLOB or LONG RAW for another long field in my table?

Thanks

Dejan Jocic
Sydney