Please, help: "ORA-01652 unable to extend temp segment by 8192 in tablespace"?
Posted on 2004-04-02
Here is my problem with Oracle 9.2:
I need to create a large index for a table in a specific tablespace. Problem is I don't know too much about Oracle and neither how the tablespace is configured.
The name of the table is PADRON and schema is PADRON.
Using Oracle Enterprise Manager Console and enter as System user, I see:
+ OEA1 - SYSTEM
I have two disks C: and F: in the same PC. Oracle was installed in C:, but PADRON was created in F:
In C: I have:
In F: I have:
Problem is that I don't have enough space in C: but plenty of it in F:
I enter to Oracle Sql*Plus:
I'm trying to do:
CREATE INDEX "PADRON"."INDICE01" ON "PADRON"."PADRON" ("APEPAT", "APEMAT")
but I get this error:
"ORA-01652 unable to extend temp segment by 8192 in tablespace PADRON"
I think the tablespace of PADRON is in F:\datosora\PADRON.ORA, where I have plenty space. How can I be sure? How can I create the index? How can I change tablespace size?