SELECT F.FLASHBACK_ARCHIVE_NAME, F.TABLESPACE_NAME,F.QUOTA_IN_MB,
(SELECT ROUND(SUM(S.BYTES)/1024/1024/1024)
FROM DBA_SEGMENTS S
WHERE S.TABLESPACE_NAME=F.TABLESPACE_NAME) "occupied"
FROM DBA_FLASHBACK_ARCHIVE_TS F;
| FLASHBACK_ARCHIVE_NAME | TABLESPACE_NAME | QUOTA_IN_MB | occupied |
|---|---|---|---|
| MY_FDA | FDA | 20480 | 19 |
If you've reached the quota, add a larger one, like this:
ALTER FLASHBACK ARCHIVE MY_FDA MODIFY TABLESPACE FDA QUOTA 20 G;
No comments:
Post a Comment