Technical Notes

We're all on the same page!

Showing posts with label shrink. Show all posts
Showing posts with label shrink. Show all posts
Friday, 5 January 2018

e.g. tablespace move

›
Check tablespaces on database SQL> SELECT * FROM DBA_TABLESPACES WHERE CONTENTS = 'PERMANENT'; Delete all records on tables i...
Tuesday, 29 August 2017

e.g. shrink table usage

›
Steps: SQL> exec dbms_stats.gather_table_stats ('HR','EMPLOYEES'); -- Gathering table statistics SQL> SELECT own...
›
Home
View web version
Powered by Blogger.