Oracle 18c enable dbhome readonly Tips
Oracle 18c Private Temporary Table Tips
Private Temporary Table is Available from Oracle 18c. A temporary table holds data that exists only for the duration of a transaction or session. Also we cannot create a PTT as SYS and possibly with other privileged accounts.
Private temporary tables are useful for dynamic reporting applications. Memory-based temporary table that is dropped at the end of the session or transaction depending on the setup.
The document is PRIVATE TEMPORARY TABLE
Oracle 12c Dataguard Error RMAN-05609 Tips
Oracle 18c RPM install Tips
Oracle dbca create database in DB18c Tips
DBCA sample command line:
dbca -silent \
-createDatabase \
-templateName General_Purpose.dbc \
-gdbName ORCLCDB.us.oracle.com \
-sid ORCLCDB \
-createAsContainerDatabase true \
-numberOfPdbs 1 \
-pdbName pdb1 \
-pdbadminUsername pdba \
-pdbadminPassword welcome \
-SysPassword welcome \
-SystemPassword welcome \
-emConfiguration NONE \
-databaseType MULTIPURPOSE \
-characterSet "JA16SJISTILDE" \
-nationalCharacterSet "AL16UTF16" \
-enableArchive false \
-recoveryAreaDestination "NONE" \
-redoLogFileSize 300
also use dbca createdatabase -help to confirm with the options…
Oracle Setting up the Star Schema Benchmark (SSB) with Import Tips
Oracle EM13c 02 - EMCC Install Tips