| table space problem.Increasing rapidly [message #356687] |
Sat, 01 November 2008 01:08  |
nadiahq
Messages: 16
Registered: March 2008
Location: KSA
|
Junior Member |
|
|
Hi all,
My two .DBF file increase rapidly.I don't know why.
1.system01.dbf=20 GB (approx)
2.temp01=16.7 GB (approx)
Where as i don't have that much data.My dmp file was 8.1 GB.
After import from dump file there was no more trunsaction happend here.so why its occupied that much space.
Pls help me.
Regards
NadiaHq
[Updated on: Sat, 01 November 2008 02:43] Report message to a moderator |
|
|
|
| Re: table space problem.Increasing rapidly [message #356724 is a reply to message #356687] |
Sat, 01 November 2008 07:35  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
Well, system is used for Oracle's data dictionary and temp is basically sort space. Pity you've imported your data into system, as a result there is no way you can see how much your data contributes to the total space.
Anyway, data within the database always takes up more space as Oracle spreads it out for better performance. Also remember that the dump file doesn't contain indexes and materialized views, which can take up significant volumes of space as well.
Best regards.
Frank
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
