Page 1 of 1
Error Code
Posted: Fri Feb 25, 2005 3:32 am
by 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
Posted: Fri Feb 25, 2005 3:39 am
by 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.
Posted: Fri Feb 25, 2005 3:33 pm
by 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);