| 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: 68653
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 |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
