Skip to content

Instantly share code, notes, and snippets.

@dincosman

dincosman/alter_fda_remove_quota.sql

Created January 11, 2023 21:04
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dincosman/6c256f1a84408d9978b3dbfb1e84336c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dincosman/6c256f1a84408d9978b3dbfb1e84336c to your computer and use it in GitHub Desktop.
Download ZIP
Remove quota clause from flashback data archive
Raw
alter_fda_remove_quota.sql
-- REMOVE QUOTA FROM FLASHBACK DATA ARCHIVE WITH SPECIFYING NO QUOTA CLAUSE
SQL> ALTER FLASHBACK ARCHIVE FDA_TEST MODIFY TABLESPACE USERS_TEST ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment