|
I am creating a PL/SQL pacakge. While creating this package, followin error returned. ORA-01653: unable to extend table SYS.SOURCE$ by 64 in tablespace SYSTEM Why this error is coming for creation of pacakge? What could be the issue. How can we solve this problem?
(comments are locked)
|
|
When you create new PL/SQL code in the database it is stored in the SYSTEM tablespace. Your system tablespace has probably reached its limit. Increase the size of one or more datafiles that are assigned to that tablespace or turn on AutoExtend. Auto extend means.. by default when the space is over, will it extend? Can you please share the syntax with us?
Dec 10 '09 at 07:02 PM
OraLearner
Documentation of the ALTER TABLESPACE command is here for 10g: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_3002.htm#SQLRF01002 Not sure if you are using Oracle Managed Files or not, so syntax would depend on how your tablespaces are set up. If you have a tool like Toad just hit the Administrate->Tablespaces screen, it is a lot easier to see the 'lay of the land' when it comes to your space usage - and make adjustments appropriately.
Dec 11 '09 at 11:25 AM
dmann
Thanks dmann! I am able to alter my tablespace.
Dec 11 '09 at 06:33 PM
OraLearner
(comments are locked)
|
