| ora-01652: unable to extend temp segment by 128 in tablespace TEMP [message #228786] |
Wed, 04 April 2007 03:18  |
fares15_5
Messages: 1
Registered: April 2007
|
Junior Member |
|
|
hi,
I'm in trouble guys could u please help me to solve it....
problem:
first of all, i have a DB called "wpsbp" V.: 9.2.0.4 and it has
user called "EAPPTMT".
I've ran an import to EAPPTMT schema(using fromuser...touser )but while the import utility is importing and creating a unique index
on HL7messages table (one of the tables is being imported) , an
ora-01652: unable to extend temp segment by 128 in tablespace TEMP shows up.
These are the errors:
IMP-00017: following statement failed with ORACLE error 1652:
---------------------------------------------------------------
CREATE UNIQUE INDEX "HL_MESSAGE_UN" ON
"HL7MESSAGES" ("HL7_MESSAGE" )
TABLESPACE "EAPPTMT_INDEX_TSPACE" LOGGING
IMP-00003: ORACLE error 1652 encountered
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
---------------------------------------------------------------and and then import utility completed the importing other tables and terminated successfully with warnings.
So, wt i did is that , i created a new temporary tablespace called 'temp02' and i added new datafile with size 500M bigger than the old temporary tablespace 'temp' that has DF with size 200M and i made it to be the default temporary TS and then i dropped the old one.
The command for creating the new temporary TS is:
CREATE
TEMPORARY TABLESPACE "TEMP02" TEMPFILE
'E:\ORACLE\ORA92\WEBPLAY\TEMP02.ora' SIZE 500M EXTENT
MANAGEMENT LOCAL UNIFORM SIZE 1024K;
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE "TEMP02";
and then i ran the create unique index
command again but i had the same error again which is
ora-01652
is there any way to git rid of this
could u please help me in that.
In the attachment u will see the log file for that import.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
