Home » RDBMS Server » Server Administration » Flashback one user...
icon5.gif  Flashback one user... [message #263800] Fri, 31 August 2007 01:42 Go to next message
user82
Messages: 49
Registered: June 2006
Location: Romania
Member
Hi all, I'm using Oracle 10g Release 10.2.0.1.0 on a Linux machine, i have enabled archivelog and also flashback options...my question is how to flashback just one user's schema...I have many users and all of them use the same tablespace and the same datafile, so i can not use flashback database neither flashback tablespace
Thanks for any relevant hint...

Report message to a moderator

Re: Flashback one user... [message #263811 is a reply to message #263800] Fri, 31 August 2007 01:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.
You have to work around this.
What is the problem?

Regards
Michel

Report message to a moderator

icon9.gif  Re: Flashback one user... [message #263816 is a reply to message #263811] Fri, 31 August 2007 02:00 Go to previous messageGo to next message
user82
Messages: 49
Registered: June 2006
Location: Romania
Member
The problem is that my server is for development purposes, there are about 6 developers each of them using at least one oracle schema(user) so, sometimes they need to go to a previous state of their schema (say they are making some mistakes)...I'm using exp/imp utility but it is not so convenient for me because this utility has some gaps in time (say I'm making exp every evening so i don't have access to the states of their schema during the day changes ). So that it was easier to me if i could use flashback options...

Report message to a moderator

Re: Flashback one user... [message #263853 is a reply to message #263816] Fri, 31 August 2007 03:26 Go to previous message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Give them a procedure to allow them to export their schema when they want/need it.

Regards
Michel

Report message to a moderator

Previous Topic: Table or LOG for Procedure name param val and time of execution
Next Topic: Pid= oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 07:48:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.