-
Hi
this is my ddl for a specific object. what shall i make the new storage parameters as? I will need to change that parameter by 2 days.
CREATE TABLE BUSOBJ.OBJ_X_DOCUMENTS
(
X_DOC_N_ID NUMBER(10) NOT NULL,
X_DOC_N_BLOCKID NUMBER(10) NOT NULL,
X_DOC_B_CONTENT LONG RAW NOT NULL
)
TABLESPACE BOTS
LOGGING
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
STORAGE(INITIAL 1M
NEXT 2M
MINEXTENTS 1
MAXEXTENTS 505
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT)
NOPARALLEL
NOCACHE
/
COMMENT ON TABLE BUSOBJ.OBJ_X_DOCUMENTS IS
'Document storage table'
-
Convert the "X_DOC_B_CONTENT " col from LONG RAW TO CLOB for starters ?? :)
-amar
-
Just change maxextents to unlimited and don't worry about it.
-
change next equal to initial
may be increase initrans if it's a busy table
-
Marist,
thankyou for your solution but its not good enough. I will eventually run out of extents and my tablespace will fill up quickly. I would appreciate if I can get a better solution. Also..what benefits would I have if i change from long raw to clob?
-
If you change to maxextents unlimited, you will NEVER reach max extents. Sure, you might run out of space, but that has nothing to do with the number of extents you have.
-
Jigar,
Regarding the advantages of converting from LONG RAW to BLOB please refer to the App Developers Guide - Large Objects and also Fundamentals.
-amar