Home » RDBMS Server » Backup & Recovery » Flashback archive in oracle 11g
Flashback archive in oracle 11g [message #289077] Wed, 19 December 2007 08:15 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Flashback archive in oracle 11g [message #289080 is a reply to message #289077] Wed, 19 December 2007 08:28 Go to previous messageGo to next message
prince973
Messages: 37
Registered: November 2006
Member
dear michel , how r u ?
i logged on as sys so i dont think the problem is quota or privilges problem,
regards,

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

Report message to a moderator

Re: Flashback archive in oracle 11g [message #289082 is a reply to message #289080] Wed, 19 December 2007 08:33 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Of course your users tablespace is LMT?

Regards
Michel
Previous Topic: RMAN error question from a newbie
Next Topic: Required data for specific period
Goto Forum:
  


Current Time: Mon Dec 05 10:41:45 CST 2016

Total time taken to generate the page: 0.15831 seconds