New answers tagged oracle-10g
I've had the same issue you are facing. solution was: mkdir -p /u01/app/oraInventory chown -R oracle:oinstall /u01/app/oraInventory chmod -R 775 /u01/app/oraInventory I hope it works for you.
Why exactly do you want to track down errors regarding ORA-01461? ORA-01461 is known to be related to various bugs, So depending on the problem you're facing, I would first raise a SR with Oracle. If you have MOSC access, take a look at Doc ID 456462.1.
Above setting doesn't necessarily mean tracing, sometimes just enabling/disabling features if that is implemented. As far as I know, 1461 is not a diagnostic event, they are mostly in the 10000-11000 or higher regions, so I wouldn't expect anything from the above. If you want trace files to be created on specific errors, enable the ERRORSTACK trace: alter ...
The index that will give you the most benefit is one on fldB, fldC, fldA desc or on fldC, fldB, fldA desc depending on your data. You'll need to check your data and keys to determine which column should go first. The last column of the index is the column for which the maximum value is being computed. By including it in the index you will avoid table ...
As only fldC & fldB are in the filter criteria, an index with these two columns on the left side will be right. Try to index on (fldC, fldB, fldA), this should do the trick mostly.
Is it possible? Sure. Is there likely to be an improvement in performance? No. If there is a change in performance (barring cases where you discover that a join is missing or otherwise fix a query), it'm more likely that the old implicit join syntax will be more efficient. But that's pretty unlikely. Behind the scenes, when you have a query using the ...
If you want to find the people "under" CDLEADER = 21, then why do use START WITH US.CDLEADER IS NULL in your CONNECT BY? Just simply use START WITH US.CDLEADER = 21: WITH ADRECURSIVEUSERLEADER AS ( SELECT US.CDLEADER AS CDLEADER ,US.CDUSER AS CDUSER ,US.NMUSER ,US.FGUSERENABLED FROM ADUSER US START WITH ...
Top 50 recent answers are included