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
Error Code
Moderators: chulett, rschirm, roy
Error Code
Victor Auxilium
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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);
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.