Thanks for your interest to resolve the issue .
Finally WE ca say that RETURNING Clause will not give the support for INSERT SELECT...
Thanks for your interest to resolve the issues.
Count MV is calculating the counts from the one more MV.
ABC MV -...
We have one materialized view (ABC) which was configured to be refreshed on DEMAND.This ABC will be refreshed at the end of the day by using...
I want to capture the some back ground activity when one insertion is going on with the help of insert select statement with the help...
Our project DBA Team is planning to migrate Oracle DB from version 126.96.36.199 to 188.8.131.52.
Could you please let mw know what the ares...
I want to execute the different files at the run time in the SQL PLUS
Ex: I have two different files like ABC.SQL, XYZ.SQL,
After setting the following commands in the linux machine
Thank you very much for your...
Thank you very for interest to resolve the issue .
We are linux environment .
We tried by...
I have DMLStatements which contains some polish characters for POLAND country.
When i am executing that DML through the QL Developer i...
Thanks for your in puts .As per your comments in this scenario also (LOW Cardinality) we can't say that existing NORMAL INDEX are...
I got a list of the INDEXES from DBA Team which are non value added to the Database with the following conditions
Thanks for interest to solve the issue .But there are No Errors & i am not using any DB Links .
I am executing one package from Linux shell script.This will invoke JAVA application, from that Database procedure will gets executed....
Hi Sergey Krasnoslobodtsev ,
Thanks for interest to resolve my issue .
Some of the new columns are having the default value . Some of the...
We had requirement that we need to alter table which contains huge data nearly 25 millions records.
Its range partitioned table...
Thank you very much .Its satisfying my requirement .
Thanks for interest to solve our issue .
We are using the following version :
Oracle Database 11g Enterprise Edition Release...
I want to form the string by concatenating some of the columns in the tables which contains so many records. After concatenation...
Thank you very much for your valuable information David .
Indexes are valid .But I am making it as UNUSABLE when I am performing all...