Pending dst session    datapump (x)  https://blog.oracle-ninja.com/2013/09/17/stuck-timezone-upgrades-and-smart-scans/    

 lsvg | egrep -w « backupvg|datavg » | lsvg -i | grep FREE

du -ms expdp_$ORACLE_SID_20190* | awk ‘{ total += $1 }; END { print total }’    

define TBS=’SIM_SIM_LOB01′define DFSZ=’10000M’ select ‘Alter database datafile  »’||FILE_NAME|| »’ resize ‘||’&DFSZ’||’;’ from dba_data_files where TABLESPACE_NAME like ‘&TBS’ order by FILE_NAME;

SET serveroutput ON;DECLAREordre_sql VARCHAR2(32000 CHAR);nomTable VARCHAR2(200 CHAR);nomColonne VARCHAR2(200 CHAR);nomSchema VARCHAR2(200 CHAR) := ‘JOJO’; BEGINDBMS_OUTPUT.ENABLE(1000000);FOR lob_cols IN (SELECT table_name nomTable, column_name nomColonne FROM ALL_TAB_COLSWHERE data_type LIKE ‘%LOB%’AND owner = nomSchemaAND table_name. read more…

Using utl_file, how file permissions are determined, working sample

http://www.peasland.net/2016/02/18/oracle-12c-identified-by-values/

/bin/emcli login -username=sysman 2. /bin/emcli sync 3. OMS_HOME>/bin/emcli modify_target -name= » » -type= » » -properties= »OracleHome: » -on_agent Example for Oracle database target: emcli modify_target -name= »* » -type= »oracle_database » -properties= »OracleHome:/oracle/12.2.0.1″ -on_agent Doc ID 1917895.1 Changing the Database. read more…

listdiskFS.txt