ORA-01653: unable to extend table SYS.SOURCE$ by 64 in tablespace SYSTEM

Question

question

OraLearner asked Dec 10, '09

ORA-01653: unable to extend table SYS.SOURCE$ by 64 in tablespace SYSTEM

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?

plsql tablespace

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2009-12-10T18:49:49Z

dmann answered Dec 10, '09

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.

3

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

dmann commented · Dec 11, 2009 at 11:25 AM

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.

2 ·

OraLearner commented · Dec 10, 2009 at 07:02 PM

Auto extend means.. by default when the space is over, will it extend? Can you please share the syntax with us?

0 ·

OraLearner commented · Dec 11, 2009 at 06:33 PM

Thanks dmann! I am able to alter my tablespace.

0 ·

question