|
-
If a table has both varchar2 and LOB, then allocate one tablespace for varchar2 and number data types and another tablespace for LOB columns.
Example:
-- CR_TAB_LOB.SQL
--
-- Author Tamil
-- Date - Jan 20, 2001
-- Example for CREATE TABLE Statement that contains LOB col
--
-- CHUNK is the number of bytes to be allocated for LOB Manipulation
-- The max value is 32768 (32K) which is the largest Oracle Block Size
-- Note that CHUNK can not be changed after creating the table
CREATE TABLE TEST_LOB (ID NUMBER , TEST_CLOB CLOB)
TABLESPACE TS_DVL_USER1 STORAGE (INITIAL 256K NEXT 256K PCTINCREASE 0)
LOB(TEST_CLOB) STORE AS (TABLESPACE TS_DVL_USER2
STORAGE (INITIAL 2M NEXT 2M )
CHUNK 16K PCTVERSION 20 NOCACHE LOGGING)
;
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
|