flashback database [message #293319] |
Fri, 11 January 2008 12:17 |
rsreddy28
Messages: 295 Registered: May 2007
|
Senior Member |
|
|
Hello All,
I've dropped a user u1 and I'm trying to flashing back using Oracle's feature Flashback Database. I'm getting the prompt as Flashback complete but after that I'm getting error like this:
SYS> flashback database to timestamp to_timestamp('2008-01-11:23:20:38','yyyy-mm-dd:hh24:mi:ss');
Flashback complete.
SYS> alter database open read only;
Then when next I connect as the user u1 and doing transactions , I'm getting this error:
SYS >conn u1/u1
Connected.
U1 >insert into dept select * from dept;
insert into dept select * from dept
*
ERROR at line 1:
ORA-01552: cannot use system rollback segment for non-system tablespace 'TS'
please help me out.
Regards,
Raj
|
|
|
|
Re: flashback database [message #293323 is a reply to message #293321] |
Fri, 11 January 2008 12:29 |
rsreddy28
Messages: 295 Registered: May 2007
|
Senior Member |
|
|
Yes Michel,
After that I just logged into the database , because when I gave
alter database open, it was saying an instance was already being opened whereas it was just in read only mode .
How to come out of this.
|
|
|
|
Re: flashback database [message #293325 is a reply to message #293323] |
Fri, 11 January 2008 12:46 |
|
Michel Cadot
Messages: 68728 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Sorry, answered too fast.
After a "flashback database" you can either open in read only mode or open in read write mode but with a reset log.
Regards
Michel
|
|
|