Pages

▼
Wednesday, June 28, 2017

"ORA-00900: invalid SQL statement" and "ORA-02064 Distributed operation not supported" Errors When calling to Remote PL/SQL Procedure

›
================================ General ================================ A. When calling to a remote PL/SQL procedure from sqlplus - all...
Tuesday, June 27, 2017

DBMS_STATS.GATHER_FIXED_OBJECTS_STATS, DBMS_STATS.GATHER_DICTIONARY_STATS and DBMS_STATS.GATHER_SYSTEM_STATS

›
====================================== General  ====================================== DBMS_STATS.GATHER_FIXED_OBJECTS_STATS DBMS_STATS.G...
Monday, June 19, 2017

delete_old_trace_files.sh. Linux script to delete Oracle log files

›
=========================== General =========================== This a script that cleans up log file for Oracle listener and server....
Thursday, June 8, 2017

Compare Regular Cursor vs Bulk Collect

›
===================================== General ===================================== Overview:  There is a table, which is source table. ...
Tuesday, May 16, 2017

Linux Code Example. Reading from file and then sed+awk+egrep.

›
============================== General ============================== Code example. Reading from file sed+awk+egrep If result is wron...
Thursday, May 4, 2017

Create new user from scratch, including Datafiles, Tablespace, Permissions, etc.

›
--Create IX and TB tablespaces CREATE TABLESPACE MY_USER_TBS_TB_01 DATAFILE '/oracle_db/db1/db_orainst/MY_USER_TBS_TB_01.dbf' SIZE...