The below statement will give CREATE VIEW command to respective view names that you provide:
set long 20000;
set pagesize 0 ;
set linesize 1000;
set feedback off ;
set verify off ;
set trimspool on;
column text for a1000;
SELECT text
FROM dba_views
WHERE view_name = '&VIEW_NAME';
It is very common that as a DBA you will encounter ‘ORA-1652: unable to extend temp segment’. Handling temporary tablespace is different than permanent tablespaces inside Oracle. On a high level, temp
Sometimes application team will ask DBA to enable flashback for x number of days. In such case, a DBA needs to estimate the flashback space required for x number of days in order to store the flashbac
When you want to shrink a datafile, you must always check the single datafile utilization. In case if you shrink datafile more than the used size, it will fail. Below query gives the datafile utilizat