Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jee

  1. jee

    Oracle8i installation

    I am going to guess that you have a Pentium IV computer. There is a known bug associated with the Oracle install and Pentium IVs that has the symptom you describe. There are several work-arounds. See faq186-1124 in this forum for more information.
  2. jee

    Help with run-away process count

    We saw this problem with an earlier version (somewhere around 8.0.5 or 8.1.6). If you had a task that kept repeatedly trying to connect to Oracle and failing (perhaps because of using a bad password or reaching the limit on the number of sessions or something), processes were created and never...
  3. jee

    Refreshing read only Materialized Views

    Just some random thoughts here... You mentioned the job_queue_processes parameter being set to 5. What about the job_queue_interval parameter (controls how often jobs are checked to see if any are due to run)? I suspect if this is set to zero, it never happens. I think it defaults to 60 seconds...
  4. jee

    UTL_FILE invalid path error

    Well you just need to get the parameter into your spfile (or setup to use a pfile - you can still do that in Oracle 9). To update your spfile, you first export it to a flat file, then edit it to add the UTL_FILE_DIR parameter, then import it back. Instructions are in the Oracle Administrator's...
  5. jee

    find a column or table in a stored procedure or function

    If what you want to do is search your procedures/triggers for references to certain tables and or columns (not sure I understand what you want)... If you happen to have access to the TOAD tool, you can search all procedures/functions/packages and/or triggers for specified strings - so you could...
  6. jee

    last login

    No such view - options: 1) Usie auditing as suggested above. 2) Write a "Login" trigger to record logins to your own table. 3) Read/parse the listener.log file - only works if all database accesses going through SQL*NET/NET80.
  7. jee

    Active Directory - Full User Name Using trigger

    Unfortunately what I told you was the full extent of my knowledge on the subject, as I have never written an external procedure. Here is a link to the manual I mentioned in my previous post: http://download-west.oracle.com/docs/cd/A87860_01/doc/appdev.817/a76939/toc.htm The information is in...
  8. jee

    counting and comparing a split string

    Sorry jad - I failed to notice the reference to 8.0.5 in your first message. You are correct - temporary tables first appeared sometime after 8.0.5 (a reason to upgrade??) As a suggestion for doing the thing with dynamic SQL... Try building something like this: SELECT COUNT (p.piece_id) FROM...
  9. jee

    counting and comparing a split string

    Sounds like what you want is what Oracle calls a temporary table. You set this up like any other table, only use this syntax: CREATE GLOBAL TEMPORARY TABLE current_inventory This creates a table that has the following characteristics: 1) Data stored is only accessible by the...
  10. jee

    Active Directory - Full User Name Using trigger

    If you want the full user name as stored in Active Directory (first name, middle name/initial, last name) you will need to write an "External Procedure" (Procedure written in C or JAVA that is callable by PL/SQL code). You can read more about this in the Oracle Applcation Developer's...
  11. jee

    interval datatype

    The resulting number from date arithemtic is a number of days - so to convert to seconds, simply multiply by the number of seconds in a day, 86400.
  12. jee

    Where to find the last login time for an oracle user ver. 8.1.7

    Starting somewhere in Oracle 8i, the concept of "System Triggers" were introduced - and you can write a system logon trigger (has to be created by a DBA) - something like this: CREATE OR REPLACE TRIGGER logontrig AFTER LOGON ON DATABASE BEGIN INSERT INTO last_login (user_name...
  13. jee

    Task Scheduling automatic exp's

    Yes - you could write a batch file and do this. Quite simple actually: Put something like this in your file: rem Perform a full database export exp user/password parfile=dailyexport.fil You can fancy it up with error handling, etc. Then use the job scheduler to specify when the job...
  14. jee

    Where to find the last login time for an oracle user ver. 8.1.7

    I think you have two options: 1) You can turn on auditing and audit logons - then the data is in the audit trail. 2) You can write a trigger that fires on logon and store the date/time in your own table. I don't think the last logon date/time for a user is available anywhere else in Oracle
  15. jee

    Multiple row updates

    I am having a hard time seeing just what you are trying to do. It looks like you are setting a status flag in the same row(s) to two different values (same where clause for each), which is, of course, not possible. If there is a typo in your example and what you are wanting to do is set the...
See more

Part and Inventory Search

Back
Top