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
FREELIST GROUPS 1
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 ?? :)
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
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.
Regarding the advantages of converting from LONG RAW to BLOB please refer to the App Developers Guide - Large Objects and also Fundamentals.