Schema Refresh

Learnomate Technologies > Schema Refresh
Schema Refresh
06
Dec

Oracle Database schema Refresh Activity ?   Solution: No. Description Command / Screenshot 1 Find the size of the schema . oraenv → BATCH46 sqlplus / as sysdba To find the size of the schema, execute the following:   COL OWNER FORMAT A15 SELECT owner, tablespace_name, round(Sum(bytes)/1024/1024,2) AS SIZE_in_MB FROM dba_segments WHERE owner like Upper(‘&User_Name’) […]

Posted in: Oracle DBA ,
Tags: Schema Refresh ,