-
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'
"High Salaries = Happiness = Project Success."
-
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.
Jeff Hunter
-
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?
"High Salaries = Happiness = Project Success."
-
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.
Jeff Hunter
-
Jigar,
Regarding the advantages of converting from LONG RAW to BLOB please refer to the App Developers Guide - Large Objects and also Fundamentals.
-amar
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|