Re: TableSpaces and Datafiles
Originally posted by peruvachira
I am met with the following error while importing data. I want to overcome this by creating my on TableSpace and Data Files. But I am not sure of how to proceeed. Can any of you provide me with a detailed answer to this problem
Thanking you in advance,
IMP-00017: following statement failed with ORACLE error 1652:
"CREATE INDEX "IDX_ALL_EST_CHROM_START_END" ON "ALL_EST" ("CHROM" , "CHROM_S"
"TART" , "CHROM_END" ) PCTFREE 5 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 14"
"8480000 NEXT 5120000 MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 0 FREELISTS 1 "
"FREELIST GROUPS 1 BUFFER_POOL DEFAULT) LOGGING"
IMP-00003: ORACLE error 1652 encountered
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
This error means that you have not enough space in the TEMP tablespace to create the temporary informations, that oracle db engines needs meanwhile is computing the index.
try this :
ALTER DATABASE TEMPFILE '/...../temp.....dbf' RESIZE 50M;
or this depending on the release and you TEMP configuration:
ALTER DATABASE DATA FILE '/...../temp.....dbf' RESIZE 50M;
If the actual size is bigger than 50M try doubling it, but the problem you are faceing is not due to the create index statement but likely depends on the load.
greetings from italy.
9i OCP DBA, Performance Engineer