<b></b>Team,let us consider our normal scott schema for this concern.Let us consider emp table.REM INSERTING into empSET DEFINE OFF;Insert into emp(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) values (7369,'SMITH','CLERK',7902,to_date('17-12-80 00:00:00','DD-

I tried to install Oracle XE 18c,but it keeps rolling back. On trace log, it said no valid ip address return for the host. I'm using windows 10 pro. What should i do to fix this problem?

Hi Tom,Is that we can changed the unified audit log tablespace from SYSAUX to standalone tablespace(example: TBS_AUDIT) online without restart the database? If yes, is that will be any impact by doing so?

Team,This is is continuation with the below link :https://asktom.oracle.com/pls/apex/f?p=100:12::::RP:P12_QUESTION_ID,P12_PREV_PAGE:9543884800346428497,11I could not continue on that link , so sorry to raise a new request.The solution provided there works wel

Dear Tom,I'm wondering about how a 'cancel' in Oracle works.For example, I have a long running query and I define a timeout on application level.Once the timeout is reached, the application sends a 'cancel'.What i observed is, that the cancel does not seem to