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