CONN SYS AS SYSDBA

CREATE TABLESPACE fbda 
   DATAFILE '/u02/app/oracle/oradata/orcl/fbda01.dbf' 
   SIZE 100M;

CREATE FLASHBACK ARCHIVE fbda 
   TABLESPACE fbda 
   RETENTION 1 YEAR;

GRANT FLASHBACK ARCHIVE ON fbda TO fbda_user;

CONN fbda_user

CREATE TABLE test AS
   SELECT object_id, object_name, status, created 
     FROM all_objects;

ALTER TABLE test FLASHBACK ARCHIVE fbda;

UPDATE test
   SET object_name = SUBSTR( object_name, 1, 29) || '-'
 WHERE MOD(object_id, 10) = 0;

COMMIT;

DROP TABLE test PURGE;

CONN SYS AS SYSDBA

ALTER TABLE fbda_user.test NO FLASHBACK ARCHIVE;

CONN fbda_user

DROP TABLE test PURGE;