Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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