about system table space [message #50248] |
Thu, 07 March 2002 03:35 |
Henry
Messages: 14 Registered: November 2000
|
Junior Member |
|
|
hi,
I have a problem while I insert records into my table.
it display error message in alert file:
"ORA-1653: Unable to extend tablespace system"
Please give some suggestion..and Thx
Best Regards,
Henry
|
|
|
Re: about system table space [message #50249 is a reply to message #50248] |
Thu, 07 March 2002 05:22 |
shiva
Messages: 38 Registered: March 2001
|
Member |
|
|
Your messg shows that you have your tables created in the system tablespace. It is always better for the user to have objects created in a non-system tablespace so as to not disturb oracle server and its system objects unnecessarily.
Anyway, to proceed you may
1. Resize the existing sys datafile to a higher value.
or
2. Add another datafile to the system tablespace.
|
|
|
|