How to get table record length in bytes?

From: Harry <a_at_abc.com>
Date: Tue, 21 Oct 2003 10:54:02 GMT
Message-ID: <ef8lb.1167$4J3.11465954@news-text.cableinet.net>

I've been asked to provide metrics for an application I'm developing. I need to work out how much disk space is required for each record in the following table so I can * by no of expected records so they can create the tablespace -

CREATE TABLE HW_RESULTS
(

  RESULT_ID                  NUMBER(8)          NOT NULL,
  RESULT_YEAR                NUMBER(4)          NOT NULL,
  ARISING_REGION_ID          NUMBER(8)          NOT NULL,
  ARISING_SUBREGION_ID       NUMBER(8)          NOT NULL,
  ARISING_SUBREGION_DESCR    VARCHAR2(50)       NOT NULL,
  ARISING_DISTRICT_ID        NUMBER(8)          NOT NULL,
  ARISING_DISTRICT_DESCR     VARCHAR2(50)       NOT NULL,
  CONSIGNEE_REGION_ID        NUMBER(8)          NOT NULL,
  CONSIGNEE_SUBREGION_ID     NUMBER(8)          NOT NULL,
  CONSIGNEE_SUBREGION_DESCR  VARCHAR2(50)       NOT NULL,
  CONSIGNEE_DISTRICT_ID      NUMBER(8)          NOT NULL,
  CONSIGNEE_DISTRICT_DESCR   VARCHAR2(50)       NOT NULL,
  WASTE_CLASS                VARCHAR2(6)        NOT NULL,
  WASTE_FATE_ID              NUMBER(8)          NOT NULL,
  QUANTITY                   NUMBER(12,5)       NOT NULL

)

Is there a simple way to do this to give me say 60 bytes?

thanks

harry Received on Tue Oct 21 2003 - 05:54:02 CDT