| regarding clusters [message #54185] |
Fri, 01 November 2002 23:27  |
Venu
Messages: 44
Registered: September 1999
|
Member |
|
|
when i am creating tables , it is giving the following error
error occurred at recursive SQL level 1
unable to extend cluster SYS.C_COBJ# by 62 in tablespace SYSTEM.
can any one let me know abt this.
Thanks in advance
|
|
|
|
|
|
| Re: regarding clusters [message #54197 is a reply to message #54185] |
Mon, 04 November 2002 10:35  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Your SQL statement could not find contiguous 62 bytes of free disk space in SYSTEM tablespace. Always make your datafiles for the SYSTEM tablespace autoextent and setup the MAXEXTENT=UNLIMITED. This tablespace doesn't grow beyond 2Gb, so no worries there.
To make it grow UNLIMITED:
ALTER DATABASE DATAFILE '/path/system01.dbf' AUTOEXTEND ON NEXT 128K MAXSIZE UNLIMITED
/
or add another datafile to it:
ALTER TABLESPACE SYSTEM ADD DATAFILE 'path/system02.dbf' SIZE 1024K AUTOEXTEND ON NEXT 128K MAXSIZE 2097152K
/
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
|
|
| Re: regarding clusters [message #54247 is a reply to message #54185] |
Wed, 06 November 2002 12:35 |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
|
You should only use the SYSTEM tablespace for system objects. It is recommended you create a USER tablespace and create your objects there.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
