| Problem during an upgrade from 8.1.7.4 to 9.2.0.4 [message #178681] |
Thu, 22 June 2006 03:34  |
eedstla
Messages: 1
Registered: June 2006
|
Junior Member |
|
|
Hello,
i have a problem during an upgrade from oracle 8.1.7.4 to 9.2.0.4. with exp/imp.
I have a database 8i with som tablespaces. The size of all tablespaces are 200MB.
The occupied space was about 50%.
First I've made an full export from 8i. Then I have installed the database 9i with dbca with all tablespace which
i've needed.(all 200MB). Then I was try to import this export. During import I get the message:
ORA-01652 Unable to extend temp segment in tablespace DTDS001. The Problem was: The tablespace was
already 100% full. How is it possible ? My workarount was to change the tablespace to ''autoextent on" and try it again. The result at the end:
TablespaceName | Size[MB] | FreeSize[MB] | Full[%] |
DTDS001 | 523 | 0 | 100
How is it possible ? The Size is now 523MB. The occupied space before was about 100MB.
regards stefan
|
|
|
|
| Re: Problem during an upgrade from 8.1.7.4 to 9.2.0.4 [message #178687 is a reply to message #178681] |
Thu, 22 June 2006 03:43  |
aciolac
Messages: 242
Registered: February 2006
|
Senior Member |
|
|
|
This can occur because of differences in space managment in databases. Look at the tablespace definitions. One of the posibilites of growing size is in the difference in inital segments of segements(table, index etc.). If You have 10 tables, which has inital segemnt in old database 10MB, and in new database 20, this mean that they will occupy at last 200MB(also without any data into them).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
