Home » RDBMS Server » Server Administration » Re: blob fields tablespace
Re: blob fields tablespace [message #369154] Thu, 30 March 2000 05:52
jayashree s
Messages: 2
Registered: March 2000
Junior Member
When defining LOBs in a table, you can explicitly indicate the tablespace and storage characteristics for each internal LOB.
Example:
CREATE TABLE lob_tab(col1 BLOB, col2 CLOB)
STORAGE (INITIAL 512 NEXT 256)
LOB (col1, col2) STORE AS
(TABLESPACE lob_seg_ts
INDEX TABLESPACE lob_index_ts);

Report message to a moderator

Previous Topic: Re: database link
Next Topic: How can I insert a MS word doc into a LOB and read it from VB?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 09 04:28:27 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.