Results 1 to 2 of 2

Thread: extent question

  1. #1
    Join Date
    Mar 2008
    Posts
    1

    Unanswered: extent question

    Hi all,
    I use a pdm application with oracle db and I need understand why oracle has worked in a strange manner.

    environment oracle 9.2.07 on sun solaris

    this is my creation table:
    CREATE TABLE "INFO_LF" ("CUR_ACC_MET" CHAR(8) NOT NULL ENABLE, "CUR_ACC_MET_DATA" RAW(254) NOT NULL ENABLE, "TS" DATE NOT NULL ENABLE, "LF_ID" CHAR(16) NOT NULL ENABLE, "PAGE_CODE" NUMBER(*,0), "FLOAT_CODE" NUMBER(*,0), "ENDIANS_CODE" NUMBER(*,0), "CONTENT" CHAR(8)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE CDMCOR" LOGGING NOCOMPRESS

    what I need understand is why 0 to 15 extents are done with size(block) 8 and subsequent extent has been done with size(block) 128


    Can anyone explane me this strange work?
    thank in advance

  2. #2
    Join Date
    Sep 2002
    Location
    Ohio
    Posts
    204
    What are the storage characteristics of the tablespace?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •