ORA-12034 materialized view log on younger than last refresh
Hi all, if you encounter ORA-12034 error. It means, a complete refresh is required before the next fast refresh. So, I run the code below in order to […]
More DetailsRegular Expression
You can use the following character classes for your regex pattern. Character Class Description [:alnum:] Alphanumeric characters [:alpha:] Alphabetic characters [:blank:] Blank Space Characters [:cntrl:] Control characters (nonprinting) […]
More DetailsHow to update user’s password with the same password
If you don’t know the user’s password that had been saved in TOAD or SQL DEVELOPER and will expire soon. You can update as it is. In Oracle […]
More DetailsJOB_QUEUE_PROCESSES parameter
In our company we came across duplicative jobs that have been executed by the system. After an investigation, we find out that, these jobs were run from our […]
More DetailsOracle TRANSLATE function
Oracle TRANSLATE(expression, from_string, to_string) function can replace all characters from from_string to to_string by its corresponding character. Also, the important thing is replacement is done by the order […]
More Details