Recent content by DeepDiverMom

Ooooh, good one, Santa! That is star quality.

John, I believe what Ken is suggesting is that when we are grateful for the efforts or suggestions of others here on Tek-Tips, the method of expressing that gratitude is both by cordial acknowledgements such as yours and by clicking the [Thank <poster_screen_name> for this valuable post!] link...

I should have been more explicit about my operating system (besides relying upon the direction of my path slashes..."/"...to signify my using a *nix environment). All of the suggestions, above, are very clever methods of defining the default path for SQL*Plus to use. As a result, please accept...

If the current path that SQL*Plus checks, as a default, to resolve scripts (as in "@<script>") is path "/x/y/z", what change can I make, for my SQL*Plus session only, to use as my new default path, "/a/b/c"?

DrD, Thanks for your response...I'll try out your suggestions in a few minutes after I put out another brush fire. [banghead] In short answer to your earlier questions: Yes, we have SQL*Plus (in which I'll try your code). Here are the results of an o/s "uname -a":Linux <domain> 2.6.9-5.ELsmp...

When I run "top" in *nix, there are about a dozen processes that are running between 80%-100% CPU utilization on an 8-CPU box. They are all processes logged in as Oracle. Customers are starting to complain. We are not presently running Oracle Enterprise Manager. What queries can I run (as a...

This is the second time in as many weeks that I have encountered problems with database-link references within a PL/SQL block, while the problem does not exist at the SQL prompt. Note, below, the successful DESCRIBE of the "submissions" table via the database link, "mss":SQL> desc...

Hello all you amazing contributors. I apologize for my tardiness and delay in getting back to you. I have been traveling and had my finger in several pots that took me away from Tek-Tips for a while. However the results are in and I have established the corporate identity of.... drum roll...

sxschech, First, let me ask about the intermediate and final totals: Those rows seem to be in your data already rather than calculated...is that correct? If so, do you want the query to do the correct sub- and final-totaling calculations without the bogus sub and final total rows?

Your intuition, Santa, is hitting on all cylinders. I would not place anything in the SYSTEM tablespace following the install. Since Oracle is deprecating the SYSTEM user, and since I did not want to contrive another user for administrative tasks, and since what I wanted to do was audit/track...

Here are facts about my situation. 1) I am logged into Oracle 10g as the SYSTEM user. 2) SYSTEM user is (as usual) a member of the DBA role, which I have confirmed possesses the CREATE ANY TABLE privilege. I attempt to issue this command:CREATE TABLE SYS.X (Y NUMBER); * ERROR at Line 1...

You all are AMAZING! I'd have to say the front runners thus far are: Surreal Estates Inc., That Really Nice Agent, Inc., and PIF Investments, Inc. How about Pay It Forward Principal Investments, Inc. (with a play on the word principal vs principle). Keep em coming. I have to have my decision...

My neighbor's name was Fillmore Crank. His full name Fillmore Pajeau Crank IV - all by himself!

Thanks for asking. I don't want it associated with my IT business. It will end in Inc. rather than Ltd. and I consider myself a bit of a Rebel - after all I'm a gray haired 48 year old Scuba Diving mom.

I attended high school with a fellow by the name of Harry Tongue IV - to think there were 4 generations of the same name.