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...
I have partitioned table with local index. We are renaming the existing partition name with new name .
But after renaming the...
Thank s David for providing the information.
Its worked fine with the following alter script also .Before merging the partitions i am applying...
Thanks for your help. its working fine .
I have procedure which have cursor and this cursor is loading the data into some collection variables.
When I am executing this...