Tags » 11g

SYS_OP_C2C internal function, implicit data type converstion

Our database is heavily loaded. In addition, developers are writing codes that make even Exadata to hang :)  They are the best hackers ever :):) 273 more words

12c

Mozilla Firefox 52 ESR for extended NPAPI-support

Interesting post from my colleagues from the US regarding Oracle Forms & Firefox 52:

As of March 7, 2017, Mozilla has released the newest release of Firefox, version 52.

300 more words
Oracle Forms

dbca does hard coding

Creating Additional Data Dictionary Structures

catoctk.sql: Oracle Cryptographic Toolkit package

owminst.plb: Workspace Manager

Workspace Manager is installed by default in the seed database and in all databases created by the Database Configuration Assistant (DBCA). 894 more words

Oracle

Archive Logs in $ORACLE_HOME/dbs

This has been happening over the years but I couldn’t figure out why….finally found this article on My Oracle Support (MOS):  Setup Local archiving on standby to Prevent Logs sent to $ORACLE_HOME/dbs (on both GRID and SQLPLUS) (Doc ID 1271095.1) 204 more words

Data Pump or Data Pain Part03 – user/db object

You might be thinking, why is it necessary to specify schemas versus perform full import or why create SQL file?

$ cat impdp_full02_user.par

directory=DATA_PUMP_DIR
userid="/ as sysdba"
metrics=Y
dumpfile=full.dmp
logfile=impdp_full_user.log
schemas=GGS_ADMIN,DEMO
include=USER
sqlfile=user.sql
…
1,192 more words
11g

Data Pump or Data Pain Part02 - tablespace/user

This is still all WIP and if you stay with me, I will provide all the sequences for export and import.

Too much info put in one post. 776 more words

11g