OraFAQ Forum: Backup & Recovery » Flashback archive in oracle 11g

Home » RDBMS Server » Backup & Recovery » Flashback archive in oracle 11g

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Flashback archive in oracle 11g [message #289077]

Wed, 19 December 2007 08:15

prince973
Messages: 37
Registered: November 2006

Member

dear all,
i am trying to make flashback archive using tablespace users

create flashback archive ftst tablespace users retention 5 year;

oracle returns error
ora-55603 invalid flashback archive command
and when i try to make the same thing using newly created tablespace things go fine,

what are the things in users tablespace that prevent the flashback archive to be done here?

another thing , any one knows if the 11g new feature can be done using enterprise manager or not?
thx for reading,

[Updated on: Wed, 19 December 2007 08:17]

Report message to a moderator

Re: Flashback archive in oracle 11g [message #289078 is a reply to message #289077]

Wed, 19 December 2007 08:23

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

are the prerequisites fit?

Quote:

You must have the FLASHBACK ARCHIVE ADMINISTER system privilege to create a flashback data archive. In addition, you must have the CREATE TABLESPACE system privilege to create a flashback data archive, as well as sufficient quota on the tablespace in which the historical information will reside. To designate a flashback data archive as the system default flashback data archive, you must be logged in as SYSDBA.

Regards
Michel

Report message to a moderator