New answers tagged

0

If you wish to release the lock on locked object, then kill the corresponding session. -- Query to Get List of all locked objects SELECT B.Owner, B.Object_Name, A.Oracle_Username, A.OS_User_Name FROM V$Locked_Object A, All_Objects B WHERE A.Object_ID = B.Object_ID ; -- and A.OS_USER_NAME = 'mahendar' -- Query to Get List of locked sessions ...


1

A child table may be exported at some point of time, let's say 12:00. Then as expdp goes on, the parent table may be exported minutes later, let's say at 12:05. Your dump file contains the content of those tables from different points of times. Yes, if those tables were changing during that 5 minutes, their relation may become inconsistent and you will get ...


0

This is based on Balazs Papp's answer and help: select "ID", max("Relevant") as "Relevant", "LongDescription", max("A") as "A", max("B") as "B", max("C") as "C", listagg("Comment", ' // ') within group (order by null) as "Comment", listagg("FurtherDetails", ' // ') within group (order by null) as "FD", count(*) as "RowCount" from dummyTable2 group by "ID", ...


2

select "ID", max("Relevant") as "Relevant", "LongDescription", max("A") as "A", max("B") as "B", max("C") as "C", listagg("Comment", ' // ') within group (order by null) as "Comment" from dummyTable group by "ID", "LongDescription" order by "ID"; http://www.sqlfiddle.com/#!4/af6db4/15


0

ALTER DATABASE set_time_zone_clause::= set_time_zone_clause This clause has the same semantics in CREATE DATABASE and ALTER DATABASE statements. When used in with ALTER DATABASE, this clause resets the time zone of the database. To determine the time zone of the database, query the built-in function DBTIMEZONE. After setting or changing the ...


Top 50 recent answers are included