RE: Ora 1652 (HEADLINE: purist DBA police raid remote Canadian Agency!!!)

Kristen,

It wasn't clear to me whe you said the developers are doing an "update". Do you mean the error happened when an "update" statement was being executed? Or were they upgrading the Oracle software?

re: general DBA issues, I agree with what Mladen is saying, except that assuming you are a public service agency, you are probably looking to run a system just a teeny tiny bit less expensively than eBay does. :)

And it is possible to do so. It may not be as performant, safe and secure as you would get with a high price dba team (which I'm guessing is kind of hard to put together in the far reaches of NT), but as long as it is good enough, it's well... good enough, right?

In case you don't have time to make all the major changes that Mladen is suggesting you need to make, there are some short term solutions. In my opinion, your best investment of your time is to call Oracle tech support, tell them up front if your DBA skills are not very well developed in this area (for instance, you have a data base built on top of a default install that was extended without proper planning), and ask for suggestions/documentation about how to work around the issue.

Even more short term, don't worry, the purist DBA police will not come and arrest you for adding datafiles to the system tablespace for your temp stuff. Do you *really* need to worry about 11mb, or 20mb? If not, just throw 50mb, or 100mb extra on the system tablespace so you can spend you time on something more important, like training or whatever. You *do* need to determine what risk you are exposing your database to by doing so however, and probably start planning for a redesign.

regards,
ep

> -----Original Message-----
> Sent: Wednesday, July 19, 2000 6:46 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Obviously, this error tells you that Oracle cannot extend segment. Oracle
> can fail to extend a segment only because of the lack of the necessary space
> in the tablespace. A common wisdom (and OFA, which is anything but the
> common wisdom)
> tells you to separate different object types into the different tablespaces.
> Tablespace system should be used for DICTIONARY TRANSACTIONS ONLY.

...

>
> -----Original Message-----
> Sent: Wednesday, July 19, 2000 5:06 PM
> To: Multiple recipients of list ORACLE-L
>
>
> When I checked yesterday's alert logs, I found the following error:
>
> ORA-01652 unable to extend temp segment by (num) in tablespace SYSTEM.
>
> I've forgotten what the actual number was. The recommended action is to add
> a datafile. However, when I checked the existing datafile, it is less than
> 50% full, with 20 MB remaining, and 11 MB in the next available extent.
Received on Thu Jul 20 2000 - 13:17:10 CDT