Search results for query: *

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"?

...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 #1 SMP Wed Jan 5 19:30:39 EST 2005...

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...

...4 end loop; 5 end; 6 / for x in (select status_flag from submissions@mss) loop * ERROR at line 2: ORA-06550: line 2, column 21: PL/SQL: ORA-00904: "STATUS_FLAG": invalid identifier ORA-06550: line 2, column 14: PL/SQL: SQL Statement ignored ORA-06550: line...

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...

...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: ORA-01031: insufficient privilegesWhy, if I have the CREATE ANY TABLE privilege, will it not allow me to create a table in the...

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.

You MAI-ers did a remarkable job helping MiniMufasa name her business (thread1256-1128199 ; Winner: KenCunningham's "Proof Positive Inventory" entry, with great honorable mentions from many other MAI-ers). I, too, am eager to benefit from your individual and collective creativity in the naming...

If what Mufsa and Taupirho did what you wanted, then it is customary to give them a purple star...click [Thank <them> for this valuable post]

Sorry, I must protest: I say Cajun's answers and explanations are always the perfect-lier-est of all!...Donit just roll off the tongue?

Seyfert, Yes, Mufasa has been extremly helpful to me too, and similar to Ebay there is a way to leave positive feedback. I always remember to give Mufasa (and other helpful Tek-tipsters) a Purple Star...it sounds like you would like to give him one too. The way you do that is by clicking the...

I'm bumping this thread to the top of the forum since my need is becoming more urgent, and I'm hoping someone has guidance or a suggestion for me. I'm rather surprised that no one has responded yet since I would have thought that this is an "easy" question. (In no way am I being negative or...