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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Livia8

    Alternative to "locate" command

    Hi, I'm trying to find out in which directory a tmp file created today is. I usually use the "locate" command followed by the file name (with asterisks, if needs be), but that only works on files older than today. Could someone please suggest an alternative that would work for new items? I've...
  2. Livia8

    How to forcibly logout users

    @carp - thanks, I'll look more into that - sorry, I've only just seen your post.
  3. Livia8

    How to forcibly logout users

    ....like a fire drill? How would your DBA do it?
  4. Livia8

    How to forcibly logout users

    Unfortunately, Windows does in our place... Ok, it gives us more than 30 seconds, I was exaggerating, but we don't even have the chance to snooze the notification. And no, it's not our side of the house that mangages that. There is an application where I work. Whoever designed and wrote it...
  5. Livia8

    How to forcibly logout users

    Thank you both. @Andy: I can't put the database in restricted mode because Accounts have to use the same "parts" of the application as the other users would (aside from the fact that I've no idea how to do it! I know very little about DBA so I'm trying to pick up bits and pieces wherever I can...
  6. Livia8

    How to forcibly logout users

    If someone had told me to stay out, I couldn't really complain if the bouncers got involved once I tried to get in. 😁😁 9 times out of 10, when we do get hold of them, they tell us "Sorry I forgot", and 8 out of those 9 don't log out cleanly. Also, being able to remotely log someone out would...
  7. Livia8

    How to forcibly logout users

    These are processes that need to be checked by humans, so automating them is not an option (e.g. there are some parts that need to be signed off before they can be completed). I don't work in Accounts myself, so I don't have the full details of all the steps that need to be taken or I'd give you...
  8. Livia8

    How to forcibly logout users

    Hi Andy, The month-end process consist in processing pay runs, carrying out journal entries, reconciling accounts, etc. It's not too bad if users log in to run reports (but may use up resources that may be needed by Accounts and end up delaying them), but often people go in and continue to...
  9. Livia8

    How to forcibly logout users

    Another day, another question! While the month-end processes are being carried out, we normally ask users to refrain from logging into Oracle. We then monitor who accesses it by runnning this query: select last_connect, usr.user_name, resp.responsibility_key, function_type, icx.* from...
  10. Livia8

    SQL SELECT - where date is null or greater than

    Thanks, Andy. This seems to have worked: SELECT USER_ID, USER_NAME, START_DATE, END_DATE, LAST_LOGON_DATE, DESCRIPTION, EMAIL_ADDRESS FROM FND_USER WHERE USER_NAME NOT IN ('GUEST', 'TEST') and email_address is not null AND (end_date IS NULL OR END_DATE >= ('05-JUL-2022')) ORDER BY END_DATE...
  11. Livia8

    SQL SELECT - where date is null or greater than

    @Andy, Thanks, that almost works, it's picking up users with no end date, but no users with end date greater than the 1st of July (in non-crazy format [wink]). I've tried changing the order of day and month, also MM with MMM, and YYYY with RRRR, no joy... @Carp, I've tried with a number of...
  12. Livia8

    SQL SELECT - where date is null or greater than

    Hi again, I'm back with another basic question I'm afraid... (This forum is great for training, I must say!) I'm trying to select a list of user names, with start date, end date, last user date, etc. The problems start when I try to add a filter by date - I'm trying to get a list of all...
  13. Livia8

    Question re: SELECT DISTINCT

    Thank you very much, Andy, much appreciated, I'll try that script. I'm afraid my version of TOAD is ancient (7.6.0.11) and doesn't seem to have a query builder function - not that I can see, anyway. This thread is the result of my not having had any formal training in this and having to pick...
  14. Livia8

    Question re: SELECT DISTINCT

    Hi, I know very little about sql and Toad, so this will most likely sound like another stupid question. I'm trying to run the following query: SELECT * FROM FA_CATEGORIES_VL, FA_CATEGORY_BOOKS WHERE ENABLED_FLAG <> 'N' My problem is that the FA_CATEGORIES_VL table has one column called...
  15. Livia8

    Can deleted files/ directories (rm -r) be retrieved again?

    Thanks, everyone. I did take backups all right, but we normally keep eight days' worth of archivelogs and delete anything older, so my accidental deletion left me with only one day's worth of files. It's not a major thing as it's not the production environment, but it would have been nice to...
  16. Livia8

    Can deleted files/ directories (rm -r) be retrieved again?

    Thanks Carp - so, that would be a no to both of my questions, then? There's no magic "undo" command, is there?
  17. Livia8

    Can deleted files/ directories (rm -r) be retrieved again?

    Hi, While I was making some room by deleting old archivelogs through asmcmd, I accidentally managed to delete the whole archivelogs directory and its contents. I'm not even sure how I did it, but I presume it was by adding an extra space after the rm -r command and the first slash (e.g. rm...
  18. Livia8

    Excel - How to save custom table styles

    If I'm not mistaken, the programme launches the "standard" format. However, if you go to File --> Open, you should see the option to open a new file on the basis of the template.
  19. Livia8

    Find Quantities in Excel sheet

    You could use the SUMIFS function, but you'd need to have a separate list of "Description". Otherwise you could create a pivot table.
  20. Livia8

    SQL script to find number of characters allowed in &quot;Description&quot; column of &quot;AP_INVOIC

    Thank you both, Carp and Andy, both your solutions worked like a charm. Have a good weekend.

Part and Inventory Search

Back
Top