DDL Not working [message #579793] |
Fri, 15 March 2013 07:22 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/7dd1014c083eaac046dfee45d698435c?s=64&d=mm&r=g) |
shahidjee7
Messages: 11 Registered: December 2010 Location: Pakistan
|
Junior Member |
|
|
dear all,
DDL command not working and there is no error in alert logfile. when i compile any object session hanged and never come back. Is there any other object status invalid in sys schema? The only thing i did was i clicked on the compile depandencies of a package.
|
|
|
|
|
Re: DDL Not working [message #579798 is a reply to message #579795] |
Fri, 15 March 2013 08:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Which DDL command?
Quote:Is there any other object status invalid in sys schema?
Check it.
Quote:The only thing i did was i clicked on the compile depandencies of a package.
Use SQL*Plus; are you sure this is not your tool that "hangs"?
Regards
Michel
[Updated on: Fri, 15 March 2013 08:17] Report message to a moderator
|
|
|
Re: DDL Not working [message #579799 is a reply to message #579795] |
Fri, 15 March 2013 08:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
Do it in sqlplus, not some gui that hide all helpful information.
do the command in one session and then in another session if it is still hung, check for locks, etc.
Here is a sample small piece of code I use sometimes.
SELECT (SELECT username
FROM v$session
WHERE SID = a.SID) blocker, a.SID, ' is blocking ',
(SELECT username
FROM v$session
WHERE SID = b.SID) blockee, b.SID
FROM v$lock a, v$lock b
WHERE a.BLOCK = 1 AND b.request > 0 AND a.id1 = b.id1 AND a.id2 = b.id2
/
|
|
|
|
|
|