| ORA-01653 error [message #55563] |
Fri, 31 January 2003 09:23  |
Carlos Olmeda
Messages: 22
Registered: January 2003
|
Junior Member |
|
|
Good morning Im currently using Oracle 7.3 server.
I just ran the catproc.sql script, I recieved the ORA-1653 error: Unable to extend table sys.IDL_SB4$ by 27 in tablespace system.
Can I recieve some help on how to correct this. I know I have to use the ALTER TABLESPACE ADD DATAFILE command but how do I actullay perform this and add the datafile.
Thank You
|
|
|
|
| Re: ORA-01653 error [message #55573 is a reply to message #55563] |
Fri, 31 January 2003 22:02  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
No need to add datafiles. You need to add disk space, and that doesn't always mean adding datafile.
First, increase the INITIAL and NEXT extents in your SYSTEM tablespace, coaleasce the tablespace and if that doesn't help add disk space to the existing datafile.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
|
|
| Re: ORA-01653 error [message #55608 is a reply to message #55598] |
Tue, 04 February 2003 00:50 |
Manish Deshmukh
Messages: 16
Registered: January 2003
|
Junior Member |
|
|
Hello
The error u got is ora 1653.This error happens when
it fails to allocate extent for the segment.The solution is u add an datafile in that particular tablespace by the following command:
alter tablespace
add datafile <path for the datafile in quotes> size <size in mb>
This will solve the problem.
Manish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
