| Tabelspace enhancement problem ?! [message #55180] |
Thu, 09 January 2003 05:27  |
Steven Schmidt
Messages: 2
Registered: January 2003
|
Junior Member |
|
|
Hello,
our system which is running on novell with oracle 7.xx
now displays a message everytime i try to add or change data records. the following message appears:
ORA-01547: failed to allocate extent of size 27310 in tablespace "RQMDB"
how can i enhance the tablespace so that i can add further records or is there another problem?
i'm really a newbie to oracle so every help would be really great...
kind regards
steven
|
|
|
|
| Re: Tabelspace enhancement problem ?! [message #55189 is a reply to message #55180] |
Thu, 09 January 2003 11:19  |
N.A. Jam
Messages: 23
Registered: January 2003
|
Junior Member |
|
|
You can resize the datafile of the tablespace via:
ALTER DATABASE DATAFILE '{/existing/file/spec/for/tablespace/here}' RESIZE 50 M;
To know which file name to use:
SELECT FILE_NAME FROM DBA_DATA_FILES WHERE TABLESPACE = 'RQMDB';
Pick a file, any file. Just as long as you have enough disk space.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
