| temp segment issue [message #353601] |
Tue, 14 October 2008 05:30  |
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
|
Senior Member |
|
|
hi all,
when i tried to create a index with the below syntax ,i am getting error like unable to extend temp segment by 16 in tablespace tb1. but when i changed tablespace to tb2 from tb1 tablespace , it was created.
my question is Since the problem was with temporary tablespace (which is unable to extend segment) then how the index is created with tb2 tablespace when not with tablespace tb1? could anyone please explain me this.
please find below is the syntax which i used to create index.
create unique index indx_report on concur_madrid.ct_reform(sync_mild)
logging
tablespace tb1
pctfree 10
initrans 2
maxtrans 255
storage (initial 128k
next 128k
minextents 1
maxextents unlimited
pctincrease 0 freelist 1 freelist group1
buffer pool default) noparallel.
Thanks & Regards,
Balaji
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
