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);
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:
  


Current Time: Thu Mar 28 16:16:17 CDT 2024