J
johnlhr
Unregistered / Unconfirmed
GUEST, unregistred user!
各位大儼:
我在前台為delphi5,後台為oracle8.1.7 sever,我有一table欄欄位為long raw型
用於存放圖片,圖片是可以存放進去,但因我是用三層結構,用socket sever 通過ip找到此數據
但其在 client端找開此 table時就死機,因時間太長我不知是死機還是未執行完,當此字
段內各記錄均為空時,又是正常的,我想是不是因其在client中打開此 table時是要將所有記
錄內容下載所造成的,請各位大俠幫忙.
CREATE TABLE DOOR_OUTCARD_DESC (
ORG_ID NUMBER (15) NOT NULL,
CARD_NO NUMBER (10) NOT NULL,
OUT_MAN_PIC LONG RAW,
OUT_MAN_NAME VARCHAR2 (100) NOT NULL,
OUT_MAN_SEX NUMBER (1),
OUT_MAN_INDENTITY VARCHAR2 (20))
TABLESPACE DOOR
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 10485760
NEXT 10485760
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 505
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;
ALTER TABLE DOOR_OUTCARD_DESC ADD CONSTRAINT DOOR_OUTCARD_ORG_CAR
FOREIGN KEY (ORG_ID, CARD_NO)
REFERENCES DOOR.DOOR_CARD (ORG_ID, CARD_NO) ;
CREATE UNIQUE INDEX DOOR_OUTCARD_DESC_U1 ON
"DOOR".DOOR_OUTCARD_DESC(ORG_ID, CARD_NO, OUT_MAN_NAME)
TABLESPACE DOOR PCTFREE 10 STORAGE(INITIAL 40960 NEXT 40960 PCTINCREASE 50 )
;
我在前台為delphi5,後台為oracle8.1.7 sever,我有一table欄欄位為long raw型
用於存放圖片,圖片是可以存放進去,但因我是用三層結構,用socket sever 通過ip找到此數據
但其在 client端找開此 table時就死機,因時間太長我不知是死機還是未執行完,當此字
段內各記錄均為空時,又是正常的,我想是不是因其在client中打開此 table時是要將所有記
錄內容下載所造成的,請各位大俠幫忙.
CREATE TABLE DOOR_OUTCARD_DESC (
ORG_ID NUMBER (15) NOT NULL,
CARD_NO NUMBER (10) NOT NULL,
OUT_MAN_PIC LONG RAW,
OUT_MAN_NAME VARCHAR2 (100) NOT NULL,
OUT_MAN_SEX NUMBER (1),
OUT_MAN_INDENTITY VARCHAR2 (20))
TABLESPACE DOOR
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 10485760
NEXT 10485760
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 505
FREELISTS 1 FREELIST GROUPS 1 )
NOCACHE;
ALTER TABLE DOOR_OUTCARD_DESC ADD CONSTRAINT DOOR_OUTCARD_ORG_CAR
FOREIGN KEY (ORG_ID, CARD_NO)
REFERENCES DOOR.DOOR_CARD (ORG_ID, CARD_NO) ;
CREATE UNIQUE INDEX DOOR_OUTCARD_DESC_U1 ON
"DOOR".DOOR_OUTCARD_DESC(ORG_ID, CARD_NO, OUT_MAN_NAME)
TABLESPACE DOOR PCTFREE 10 STORAGE(INITIAL 40960 NEXT 40960 PCTINCREASE 50 )
;