flashback table [message #459627] |
Mon, 07 June 2010 08:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Riyasbasha
Messages: 25 Registered: March 2010
|
Junior Member |
|
|
Hi all
"
flashback table operations are not supported for the SYS user
"
I have found the above line in one of the article.
I dont know why the SYS user can not able to flash back the table.
can any one help me plz.
|
|
|
|
Re: flashback table [message #459631 is a reply to message #459627] |
Mon, 07 June 2010 09:07 ![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 |
|
|
- SYS/SYSDBA is special
- SYS/SYSDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS/SYSDBA" and you'll see the immediate answer)
- SYS/SYSDBA does not act like any other user
- When you use SYS/SYSDBA Oracle deactivates some code path and activates others
- Whatever you do with SYS/SYSDBA will neither validate nor invalidate the same thing with any other user.
Regards
Michel
[Updated on: Mon, 07 June 2010 09:07] Report message to a moderator
|
|
|
|
|
|