Re: db file sequential read

(and do those inherit foreign key fields as part of the primary key from other tables)...or do the tables use sequences for a mock primary key? Also, does INVENTORY_LOCATION have any child tables that have a foreign key reference to it? Jeffery Stevenson Chief Databeast Slayer Medical Present Value

Re: Is nothing sacred? (Oracle vs The Experts)

that in DBA 101)? Jeffery Stevenson Chief Databeast Slayer Medical Present Value, Inc. Austin, TX - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 11, 2002 10:58 AM So, there I am, on 8.1.7.2 (and .4) on HP/UX 11.0, with a process

RE: Index not being used .... why?

aren't getting any data returned). Anyways, just a thought. Jeffery Stevenson Databeast Slayer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Tuesday, November 20, 2001 1:45 PM To: Multiple recipients of list ORACLE-L Returns null or no rows? If it is null then something

RE: sequence of numbers

containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeffery Stevenson INET: [EMAIL PROTECTED] Fat City Network

RE: Another Oracle DBA gets The Bullet WAS: Help!: Job Descrip

...and I agree it's a great place to live. Guvm'nt jobs? Eep! Yeah Scott, I noticed that SA had about 4 times as many Oracle/DBA positions listed than Austin when I scouting the market for a friend who's looking at this area. That scared me... Jeffery Stevenson Databeast Slayer Medical Present Value

RE: good workaround for a ORA-2016?

key in (select same datatype from another table b,c,d(several other tables) connect by prior etc., hierarchy ...and then from the other system you'd call: select * from call_this_from_somewhere_else@remote_db; Jeffery Stevenson Databeast Slayer Medical Present Value, Inc

RE: ORA-00600

from an IOT via a secondary index Jeffery Stevenson Chief Databeast Tamer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Tuesday, September 18, 2001 1:25 AM To: Multiple recipients of list ORACLE-L Hi I get this error ORA-00600 when i try to execute a stored

RE: !! Keeping the list alive

'they' are 'cause I've seen you mention frustration with them in some of your posts). :) Okay, now back to lurking... Jeffery Stevenson Chief Databeast Tamer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Thursday, August 30, 2001 10:27 AM To: Multiple recipients of list ORACLE-L

RE: ORA-00600 on Production DB - Need advice/Still Searching

frenzy. Anyways, I hope some of this can help... Wow...I haven't posted on this list in a long time... Jeffery Stevenson Chief Databeast Tamer Medical Present Value, Inc. Austin, TX -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 2:56 PM To: Multiple

RE: DB Link Between Prod and Test?

could probably deter that potential hazard by setting up a nice little resource restrictive profile for that account)... Jeffery Stevenson Chief Databeast Tamer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Tuesday, May 15, 2001 1:26 PM To: Multiple recipients of list

RE: How to break into DBA/Systems work without going broke doing

you and might give you a call to see if you're interested. Despite appearances sometimes, we're mostly a friendly lot. :) Jeffery Stevenson Chief Database Geek Medical Present Value, Inc. Austin, TX -Original Message- Sent: Thursday, March 29, 2001 10:31 AM To: Multiple recipients

RE: NLS_DATE_FORMAT not effective..help!

rent users to different default schemas (so that the applications were no longer logging into the schema that owned all the objects and the developers didn't have to change any of their code to qualify all the tables, views, and sequences). Jeffery Stevenson Chief Databeast Tamer Medical Present Value, I

RE: DBMS_OUTPUT.PUT_LINE

Won't that continuously print: Inserted 1 rows. Inserted 1 rows. ... (well, as long as you don't get a primary/foreign key exception) :) Jeffery Stevenson Chief Databeast Tamer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Tuesday, March 20, 2001 10:11 AM

RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

Now that's a waste...you're supposed to boil the ants and then roll them up in chocolate. Then you can add sugar to the water you boiled them in and be able to serve "lemonade" with the chocolate covered ants (make sure they're carpenter ants and not fire ants!). :) Jeffery Steve

RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

that's a waste...you're supposed to boil the ants and then roll them up in chocolate. Then you can add sugar to the water you boiled them in and be able to serve "lemonade" with the chocolate covered ants (make sure they're carpenter ants and not fire ants!). :) Jeffery Stevenson Chief

RE: Oracle Licensing

Title: You should be able to find it at: http://store.oracle.com Jeffery StevensonChief Databeast TamerMedical Present Value, Inc.Austin, TX -Original Message-From: Dennis Taylor [mailto:[EMAIL PROTECTED]]Sent: Monday, March 05, 2001 6:01 PMTo: Multiple recipients of

RE: Thanks and another book request

Houston/Beaumont area? That area's larger than some states! :) Jeffery Stevenson Chief Databeast Tamer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Friday, February 02, 2001 5:36 AM To: Multiple recipients of list ORACLE-L Just wanted to thank those