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?

more ▼

asked Dec 10 '09 at 06:39 PM in Default

OraLearner gravatar image

1.3k 69 85 88

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Dec 10 '09 at 06:49 PM

dmann gravatar image

437 1 1 4

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)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 10 '09 at 06:39 PM

Seen: 2615 times

Last Updated: Dec 10 '09 at 06:39 PM