-
hi,
why shutdown transactional or shutdown immediate doesn't work when u are doing transaction againes a table owned by sys.
regards
sonia
-
Shutdown transactional will not shutdown the database untill all the active transactions are complete.
Shutdown immediate will will shutdown the database immediately by rolling back all the active transaction.
In ur case SHUTDOWN IMMEDIATE should work
regards
anandkl
anandkl
-
Sure it works, regardless of whether transactions are active in schema SYS or any other schema.
As anandkl pointed out, TRANSACTIONAL will wait untill all current transactions are closed before proceding with shutdown operations, while IMMEDIATE will simply roll back any active transactions (including those in SYS's schema) and close the database.
If you are experienceing any other behaviour you must be hitting some bug.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
doesn't work guys,
Just create an object in sys schema and update the rows....don't commit....
open another window and issue shutdown immediate......
it doesn't works
-
hm why SYS?
it works otherwise we wouldnt be able to do backup for years
-
Originally posted by Sonia
Just create an object in sys schema and update the rows....don't commit....
open another window and issue shutdown immediate......
it doesn't works
Don't know about you, but it works on my databases. I've tried it, belive me. As I said, if it doesn't work on your system it must be a bug - contact Oracle Support.
In which release are you getting this problem?
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
Shutdown Immediate will take some time ( to rollback the transaction ) . SOmetime , it takes quite long time , ( It could be a oracle problem) . But anyway , just be patient and It should shutdown after any transaction is rollbacked
1. www.dbasupport.com
2. www.dbforums.com
3. www.itpub.net
4. www.csdn.net
5. www.umlchina.com
6. www.tek-tips.com
7. www.cnforyou.com
8. fm365.federal.com.cn
9. www.programmersheaven.com
10.http://msdn.microsoft.com/library/default.asp
ligang1000@hotmail.com
-
hi all,
Yes it works....but it takes so much of time...i don't know why.....
-
Sonia try to be patient when dealing with Oracle databases.
App buht jaldi kartee hain
You cannot succeed if you fear to face challenges.
MAS
BE(CS) , OCP 8/8i.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|