DBMS_PARALLEL_EXECUTE ORA-29491: invalid table for chunking
I am trying to recreate the process “CREATE_CHUNKS_BY_ROWID”
https://oracle-base.com/articles/11g/dbms_parallel_execute_11gR2#create_a_task
but failed.
I follow the following steps:
DBMS_PARALLEL_EXECUTE ORA-29491: invalid table for chunking
I am trying to recreate the process “CREATE_CHUNKS_BY_ROWID”
https://oracle-base.com/articles/11g/dbms_parallel_execute_11gR2#create_a_task
but failed.
I follow the following steps:
Unable to install Oracle Database 19.3.0 due to the error SEVERE: PRCZ-1082: Failed to add Windows user or Windows group
I’m really stressed right now. I’m writing this hoping that someone with great knowledge can give me some advice.
Application using OLEDB connection with Oracle 19.18c generating dumps
I’m facing an issue with my application that uses an OLEDB connection with Oracle 19.18c. The application is generating dumps, and so far, we haven’t been able to determine the cause.
oracle 19c user getting EXPIRED & LOCKED within several minutes when all password related settings in its profile are set to unlimited
I cannot understand why the account in Oracle 19c NON-CDB database getting locked few minutes later after creation. Audit trail is not configured.
ORA-65139: Mismatch Between XML Metadata File And Data File
i have two systems (SYS1, SYS2(stand alone)), on both is running an oracle 19c database. i want to create a plugable database from SYS1 and want to plug in the SYS2 database.
Why SQL not found in DBA_HIST_SQLTEXT that is executed yesterday only?
I have executed a sql statement yesterday to check the performance of the query but today I am not able to find the sql in dba_hist_sqtext.
Proceedure to kill session in Oracle
I have created a procedure to capture long running session and want to kill those session from procedure itself.
What is this data type T$ACTION_REL_TABLE?
could you help me with my problem. I came across a field type unfamiliar to me – T$ACTION_REAL_TABLE in the table and this table does not work through SELECT, although VIEWS related to this table work. All this happens through accessing a remote database via PL SQL Developer, Objects – Database links