Error Code

[asvictor]

Hi,

I am getting this error msg whenever I run a Job.

"
LoadDWItem..Trn_Process_Data: ORA-01653: unable to extend table FXDW.DW_ITEM by 8 in tablespace DWD "

Is it something related to the Database size or something else??

Cheers,

Victore

[Sainath.Srinivasan]

The message is from your Oracle db for the table DW_ITEM cannot extend (increase) in size because of the design constraints. It can be due to anything like MAXEXTENTS, PCTINCREASE etc either given to your table or to the db in general.

Your Oracle DBA can answer better.

[ray.wurlod]

When an Oracle table is created, it is created in a table space (an allocation of disk space). This can be made static, or auto-extending. The default is static, which means you can fill the allocated space. Once it's full, an attempt made to extend it will result in the error you reported.

Your Oracle DBA can extend the tablespace, but may be unwilling (for reasons of managing disk resources) to make it auto-extending.

Ask your Oracle DBA about the STORAGE clause in a CREATE TABLE statement. Here's an Oracle CREATE TABLE statement; go and learn what all the pieces do. It's always a good idea to have your DBA on side, even if this involves having the DBA create all tables.

Code: Select all

CREATE TABLE MYTABLE
(
    COLUMN_01      NUMBER,
    COLUMN_02      NUMBER,
    COLUMN_03      NUMBER,
    COLUMN_04      NUMBER,
    COLUMN_05      NUMBER
)
TABLESPACE MY_TABLESPACE
PCTUSED     40
PCTFREE     10
INITRANS    1
MAXTRANS    255
STORAGE    (
            INITIAL             512K
            NEXT                1M
            MINEXTENTS          1
            MAXEXTENTS          2147483645
            PCTINCREASE         0
            FREELIST            1
            FREELIST GROUPS     1
            BUFFER POOL         DEFAULT
           )
LOGGING
NOCACHE
NOPARALLEL;

ALTER TABLE MYTABLE ADD (
  CHECK ("COLUMN_01" IS NOT NULL) ENABLE,
  CHECK ("COLUMN_02" IS NOT NULL) ENABLE,
  CONSTRAINT MYTABLE_PKC PRIMARY KEY (COLUMN_01, COLUMN_02) ENABLE);