New answers tagged oracle-11g-r2
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
