Tablespace error [message #389378] |
Sun, 01 March 2009 12:43 |
AviatoR
Messages: 43 Registered: February 2009
|
Member |
|
|
hi,
i've a disk containing 500mb of free space, when i'm creating a tablespace of juz 100mb itz is showing error like
unable to allocate space to this tablespace? since there r 500mb free space in the disk how can this happen?
what r the reasons for this to happen?
|
|
|
|
Re: Tablespace error [message #389381 is a reply to message #389378] |
Sun, 01 March 2009 12:53 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
Always post your Oracle versions to 4 digits and OS versions.
Post what you did. Copy and paste the code and errors within CODE tags.
Explaining what you did helps us very little.
And do not use IM speak. Most of the folks here are non-native English speakers and it irritates a lot.
>>since there r 500mb free space in the disk how can this happen?
Prove it.
Post the sql statement,your error and disk usage.
>>what r the reasons for this to happen?
With the information presented, we have no idea. Just like you.
|
|
|