Home » RDBMS Server » Server Administration » temp segment issue (Oracle 9i,windows)
temp segment issue [message #353601] Tue, 14 October 2008 05:30 Go to next message
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
Re: temp segment issue [message #353603 is a reply to message #353601] Tue, 14 October 2008 05:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
During creation the index segment is flagged as a temporary segment. When the creation is completed this temp segment becomes the index segment.
This is this temp/index segment that does not find space to be built: not enough space in tb1, enough in tb2.

Regards
Michel
Re: temp segment issue [message #353613 is a reply to message #353603] Tue, 14 October 2008 05:52 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

thanks a lot for your quick and clear response michel.

Regards,
Balaji
Previous Topic: A row of table is in which tablespace?
Next Topic: Install Oracle 10g on AIX LPAR with different oracle os users good or bad !
Goto Forum:
  


Current Time: Fri Dec 02 20:32:01 CST 2016

Total time taken to generate the page: 0.08807 seconds