flashback table [message #459627] |
Mon, 07 June 2010 08:42 |
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 |
|
Michel Cadot
Messages: 68731 Registered: March 2007 Location: Saint-Maur, France, https...
|
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
|
|
|
|
|
|