| Tablespace Expands abruptly!!! [message #52182] |
Mon, 08 July 2002 02:57  |
Suhail Ahmed
Messages: 2
Registered: July 2002
|
Junior Member |
|
|
Dear All,
I have a dmp file of 6 MB.
I created a fresh tablespace with autoextend option ON.
I import this small file to user linked with this tablespace. Import is successful. When I see the size of tablespace consumed by the data of this dmp file, I am shocked, that it is consuming 10 GB !!! Why is this so.? I have given next extent for tablespace/datafile as 1 MB.
|
|
|
|
|
|
| Re: Tablespace Expands abruptly!!! [message #52245 is a reply to message #52182] |
Wed, 10 July 2002 19:44  |
christopher
Messages: 25
Registered: September 2000
|
Junior Member |
|
|
you can not base the space needed on your dmp file size. If you imported 10 segments from that dmp file, there is your 10 Meg of used space. It does not mean that 10 Meg is actually being used, just means 10 meg has been assigned.
SELECT segment_name, bytes
FROM dba_segments
WHERE tablespace_name = 'YOUR TABLESPACE';
This will show how many segments exist in the tablespace as well as how much space each one has been assigned.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
