Tablespace def and Table def on storage
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Tablespace def and Table def on storage

  1. #1
    Join Date
    Oct 2000
    Posts
    449

    Tablespace def and Table def on storage

    Hello :

    I am creating a table with 20 partitions to store data and approx size of the table is about 20GB worth of data. One of the TS definition and table storage clause is listed below.

    create tablespace y02p01 datafile '/u01/dbs/OD/y02p01a.dbf' size 500M
    autoextend on next 100M extent management local uniform size 100M;

    Create table xyz (columns) and with
    PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
    STORAGE (initial 10M next 10M pctincrease 0 maxextents unlimited);

    In that tablespace y02p01 only one table partition will exist.

    How will my extents be, when I start pumping in data?

    Thanks, ST2000

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    extents will be 100MB each

    this kind of things are proved easily, try it and see and you will learn more than you learn by asking someone else

Posting Permissions

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



Click Here to Expand Forum to Full Width