| Unable to extend table [message #56832] |
Tue, 29 April 2003 13:15  |
JUAN
Messages: 23
Registered: November 2000
|
Junior Member |
|
|
Hi,
I was creating a procedure and the following error ocurred:
ORA-00604: error occurred at recursive SQL level 1
ORA-01653: unable to extend table SYS.IDL_CHAR$ by 27 in tablespace SYSTEM
then I try to increase the size of system tablespace and the following error ocurred:
ORA-01237: cannot extend datafile 3
ORA-01110: data file : '/der1/dbs/data/der_default.dbf'
ORA-09971: sfsfs: write error, unable to write header block.Additional information: 783360
Can somebody help?
|
|
|
|
|
|
| Re: Unable to extend table [message #56840 is a reply to message #56832] |
Wed, 30 April 2003 01:56  |
John Anker Corneliussen
Messages: 5
Registered: February 2002
|
Junior Member |
|
|
extend the tablespace with another datafile ...
using dbastudio - or sql using ...
Adding a Datafile Example
The following statement adds a datafile to the tablespace and changes the default logging attribute to NOLOGGING. When more space is needed, new extents of size 10 kilobytes will be added up to a maximum of 100 kilobytes:
ALTER TABLESPACE accounting NOLOGGING
ADD DATAFILE 'disk3:pay3.dbf'
SIZE 50K
AUTOEXTEND ON
NEXT 10K
MAXSIZE 100K;
Altering a tablespace logging attribute has no affect on the logging attributes of the existing schema objects within the tablespace. The tablespace-level logging attribute can be overridden by logging specifications at the table, index, and partition levels.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
