<br /> User SYS is NEVER locked even if it is in status LOCKED.<br /> <br /> What is your Oracle version?<br /> <br /> ..read more

SQL> col parameter format a30 SQL> col value format a30 SQL> select * from v$option where lower(parameter) like '%audit%' order by 1; PARAMETER VALUE CON_ID ------------------------------ ------------------------------ ---------- Fine-grained Auditing TRUE 0 Unified Auditing FALSE 0 Check the last line ..read more

Hi! Unfortunately, my user "sys" is locked. Maybe you know the solution? SQL> select account_status from dba_users where username = 'SYS'; ACCOUNT_STATUS -------------------------------- LOCKED conn as sysdba Enter user-name: sys/manager@XE as sysdba ERROR: ORA-28000: The account is locked. BR ..read more

I realized that I also need to determine programmatically whether only the traditional auditing is available, traditional or unified, or unified only.<br /> Which will be a better way of doing it: by looking at whether the above views exist and which combination thereof, or by querying the version (pre-12, post-23 ..read more

CHANGE THE NAME OF GRAPH.SHOW ERROR REP-1246 DOCUMENT NOT FORM MAY BE GRAPH60_PATH PROBLEM. inside oracle_home/jlib/bigraphbeen.jar bigraphbeen.jar not availble.plsease send me bigraphbeen.jar  file.i try from google but it is not availba ..read more

@Michel Cadot: Sure. I'll make sure to submit feedback.<br /> <br /> Oracle version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 ..read more

@Michel Cadot: It worked ..read more

From your previous topic: Michel Cadot wrote on Wed, 27 December 2023 13:28 If you want to continue to get help feedback in your topics. Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it ..read more

Hi All, I'm working for a shipment company. We get voyage information. Below is requirement and I'm not able to find right solution for this. - We get Voyage detail on daily basis and we load it into a target table - There is a table called voyage master, which shows when voyage is discontinued. - Even if Voyage is discontinued, we need to create dummy record and populate it in the separate table - Later, we do UNION in the view to combine both tables to show details to users - There is also challenges that sometimes, voyages gets discontinued and later re-start. In that scenario, we need to ..read more

Hi All,<br /> <br /> I'm working for a shipment company. We get voyage information. Below is requirement and I'm not able to find right solution for this.<br /> <br /> - We get Voyage detail on daily basis and we load it into a target table<br /> - There is a table called voyage master, which shows when voyage is discontinued.<br /> - Even if Voyage is discontinued, we need to create dummy record and populate it in the separate table<br /> - Later, we do UNION in the view to combine both tables to show details to users<br /> - There is also chall ..read more