Oracle DBA by Example. Code samples, Scripts, Reference.
Pages
(Move to ...)
Home
▼
Wednesday, May 27, 2020
Code Example: awk, bash, sqlplus, plsql. Grant Permissions from schema A to schema B from bash. Get List of exported tables
›
============================ General ============================ Scenario: There are 2 schemas. CRM and Reports. Automatically execute Gran...
Thursday, May 21, 2020
CC PL/SQL- Conditional Compilation in PL/SQL
›
============================ General ============================ Conditional Compilation in PL/SQL (aka CC PLSQL) Was added in Oracle 10.1....
Tuesday, May 5, 2020
sqloader example. Loading several files types via bash and sqloader.
›
==================== General ==================== Load via bash and sqloader to three tables. ==================== Files ==========...
Monday, April 6, 2020
GG Golden Gate Error OGG-00918 Key column is missing from map.
›
================== General ================== Golden Gate REPLICAT process is in status ABENDED The error is: OGG-00918 Key column is m...
Thursday, April 2, 2020
ORA-12154: TNS:could not resolve the connect identifier specified from db_link
›
====================== General ====================== When connecting with sqlplus a/a@connectstr the connection is OK When connecting ...
‹
›
Home
View web version