| |
[Apr. 2nd, 2009|02:28 pm] |
| [ | mood |
| |  frustrated | ] |
| [ | music |
| | Handlebars, Flummery | ] |
My Oracle assignment is progressing. Very, very, slowly. In the "One step forward, two steps back" kind of way. I finally got the snippet I posted the other day working (using TRUNCs all 'round, at the suggestion of StackOverflow), and felt accomplished.
Then I moved on to the next step in my algorithm I'd planned and failed there as well. Apparently it doesn't like Exists clauses on if statements - or sub queries in sub queries in exists statements in if statements. ...Remember what I said about coding by brute force?
I kind of desperately want to get this done before the weekend, and that way I can spend the weekend doing my other assignment (since it's not like I'll have much in the way of time next week) - but if it continues at this glacial pace, I doubt I'll accomplish that. :(.
Knowing people that have already completed the assignment and swear it's easy is also not helping my stress levels. Sigh.
-Mmaster |
|
|
| |
[Apr. 2nd, 2009|11:15 pm] |
| [ | mood |
| |  working | ] |
| [ | music |
| | Make Yourself At Home, The Starting Line | ] |
Sigh.
I have some code that will do most of the DBP assignment. It doesn't have error handling, etc, as yet, but it does produce the table and stuff.
Unfortunately, it only seems to work once per session.
After that, I get an error:
Error report:
ORA-01536: space quota exceeded for tablespace 'USERS'
ORA-06512: at "MCOLVILL.POPULATEFORECAST", line 53
ORA-06512: at line 2
01536. 00000 - "space quota exceeded for tablespace '%s'"
*Cause: The space quota for the segment owner in the tablespace has
been exhausted and the operation attempted the creation of a
new segment extent in the tablespace.
*Action: Either drop unnecessary objects in the tablespace to reclaim
space or have a privileged user increase the quota on this
tablespace for the segment owner.
...Wheee....
-Mmaster |
|
|