Oracle | Database

Oracle Database Version 19.3

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose The "Database" commands are those that literally create, alter, and drop a database. Separate library pages, linked at page bottom, go into the specifics of entities created as part of database creation such as Control Files, Data Files, PDBs, Redo Logs, Tablespaces, Tablespace Groups, and Temp Files.

System Privileges

ALTER DATABASE	AUDIT SYSTEM	CREATE PLUGGABLE DATABASE
ALTER SYSTEM

Create Database

Create 12c Pluggable Database CREATE DATABASE <database_name> USER SYS IDENTIFIED BY <password> USER SYSTEM IDENTIFIED BY <password> CONTROLFILE REUSE MAXDATAFILES <integer> MAXINSTANCES <integer> CHARACTER SET <character_set_name> NATIONAL CHARACTER SET <character_set_name> SET DEFAULT <BIGFILE | SMALLFILE> TABLESPACE LOGFILE [GROUP <integer> <file_specification>,] [GROUP <integer> <file_specification>,] [GROUP <integer> <file_specification>] MAXLOGFILES <integer> MAXLOGMEMBERS <integer> MAXLOGHISTORY <integer> <ARCHIVELOG | NOARCHIVELOG> [FORCE] LOGGING EXTENT MANAGEMENT LOCAL DATAFILE <system_file_specification> SYSAUX DATAFILE <file_specification> DEFAULT TABLESPACE <tablespace_name> EXTENT MANAGEMENT LOCAL UNIFORM SIZE <integer><M | G | T | P | E> <BIGFILE | SMALLFILE>DEFAULT TEMPORARY TABLESPACE <tablespace_name> TEMPFILE <file_specification> [SIZE <integer><M | G | T | P | E>] AUTOEXTEND <OFF | ON> NEXT [SIZE <integer><M | G | T | P | E>]>] MAXSIZE [SIZE <integer><M | G | T | P | E>]>] [<AUTOALLOCATE | UNIFORM [SIZE <integer><M | G | T | P | E>]>] <BIGFILE | SMALLFILE> UNDO TABLESPACE <tablespace_name> DATAFILE <file_specification> [SIZE <integer><M | G | T | P | E>] AUTOEXTEND <OFF | ON> NEXT [SIZE <integer><M | G | T | P | E>]>] MAXSIZE [SIZE <integer><M | G | T | P | E>]>] EXTENT MANAGEMENT LOCAL AUTOALLOCATE SET TIME_ZONE = <time_zone_region> ENABLE PLUGGABLE DATABASE SEED <seed_tablespace_clause>;

CREATE DATABASE oratest

      USER SYS IDENTIFIED BY oracle1

      USER SYSTEM IDENTIFIED BY oracle2

      CONTROLFILE REUSE

      MAXDATAFILES 1024

      MAXINSTANCES 2

      CHARACTER SET AL32UTF8

      NATIONAL CHARACTER SET AL16UTF16

      SET DEFAULT  BIGFILE TABLESPACE

      LOGFILE

        GROUP 1 ('/app/oracle/oradata/orabase/redo1a.log',

       '/app/oracle/fast_recovery_area/redo1b.log') SIZE 512M,

        GROUP 2 ('/app/oracle/oradata/orabase/redo2a.log',

       '/app/oracle/fast_recovery_area/redo2b.log') SIZE 512M,

        GROUP 3 ('', '')  SIZE 512M

      ('/app/oracle/oradata/orabase/redo2a.log',

       '/app/oracle/fast_recovery_area/redo2b.log')

      SIZE 512M

      MAXLOGFILES 24

      MAXLOGMEMBERS 4

      MAXLOGHISTORY 1

      ARCHIVELOG

      FORCE LOGGING

      EXTENT MANAGEMENT LOCAL

      DATAFILE '/app/oracle/oradata/orabase/cdbsystem.dbf' SIZE 700M

        AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED

      SYSAUX DATAFILE '/app/oracle/oradata/orabase/cdbsysaux.dbf' SIZE 5G

      AUTOEXTEND ON NEXT 1M MAXSIZE 1G

      EXTENT MANAGEMENT LOCAL AUTOALLOCATE

      BIGFILE
      DEFAULT TEMPORARY TABLESPACE default_temp

        TEMPFILE '/app/oracle/oradata/orabase/deftemp.dbf' SIZE 250M

        AUTOEXTEND ON NEXT 64K MAXSIZE 1G

        EXTENT MANAGEMENT LOCAL UNIFORM SIZE AUTOALLOCATE

      BIGFILE UNDO TABLESPACE undotbs1

        DATAFILE '/app/oracle/oradata/orabase/undotbs.dbf' SIZE 1G

        AUTOEXTEND ON NEXT 256K MAXSIZE 5G

        EXTENT MANAGEMENT LOCAL AUTOALLOCATE

      SET TIME_ZONE = ''+00:00'

      ENABLE PLUGGABLE DATABASE SEED

      FILE_NAME_CONVERT = ('/app/oracle/oradata/orabase/', '/app/oracle/oradata/orabase/pdbseed/')

      SYSTEM DATAFILES SIZE 250M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED

      SYSAUX DATAFILES SIZE 600M AUTOEXTEND ON NEXT 10M MAXSIZE 1G;

      

      --  run postcreation scripts:

      a. Set the session with a new parameter:

          alter session set "_oracle_script"=true;

      b. Close and open the seed PDB:

          alter pluggable database pdb$seed close;

          alter pluggable database pdb$seed open;

      c. Execute catalog.sql and other postcreation scripts:

          @?/rdbms/admin/catalog.sql

          @?/rdbms/admin/catblock.sql

          @?/rdbms/admin/catproc.sql

          @?/rdbms/admin/catoctk.sql

          @?/rdbms/admin/owminst.plb

          @?/sqlplus/admin/pupbld.sql

      

      Note: To get the full list of scripts executed and the sequence of execution to follow, run DBCA to create CDB and in the last step, generate the scripts only.
      The scripts are created in the $ORACLE_BASE/admin/<cdb_name>/scripts directory. The shell script <cdb_name>.sh is the first script to read.

Typical Create 11g Database On Linux / UNIX $ cd /app/oracle/product $ mkdir -p admin/orabase/adump $ cd admin/orabase $ mkdir dpdump $ mkdir pfile $ mkdir wallet $ cd /app/oracle/product $ mkdir -p fast_recovery_area/ORABASE/ARCHIVELOG $ cd fast_recovery_area/ORABASE $ mkdir FLASHBACK $ mkdir ONLINELOG $ cd /app/oracle/product $ mkdir -p oradata/orabase $ touch /app/oracle/product/admin/orabase/pfile/initorabase.ora $ cd /app/oracle/product/admin/orabase/pfile $ vi initorabase.ora ------------------------------------------------------ ########################################### # Cache and I/O ########################################### db_block_size=8192 ########################################### # Cursors and Library Cache ########################################### open_cursors=300 ########################################### # Database Identification ########################################### db_domain="" db_name=orabase ########################################### # File Configuration ########################################### control_files=( "/app/oracle/product/oradata/orabase/control01.ctl", "/app/oracle/product/oradata/orabase/control02.ctl", "/app/oracle/product/oradata/orabase/control03.ctl") db_recovery_file_dest=/app/oracle/product/fast_recovery_area db_recovery_file_dest_size=10737418240 ########################################### # Miscellaneous ########################################### compatible=11.2.0.1.0 diagnostic_dest=/app/oracle/product memory_target=854589440 ########################################### # Security and Auditing ########################################### audit_file_dest=/app/oracle/product/admin/orabase/adump audit_trail=DB remote_login_passwordfile=EXCLUSIVE ########################################### # Processes and Sessions ########################################### processes=150 ########################################### # Shared Server ########################################### dispatchers="(PROTOCOL=TCP) (SERVICE=orabaseXDB)" ########################################### # System Managed Undo and Rollback Segments ########################################### undo_tablespace=UNDOTBS1 ------------------------------------------------------ -- save the file and exit vi $ cp initorabase.ora $ORACLE_HOME/dbs/initorabase.ora $ cd $HOME $ sqlplus / as sysdba SQL> spool $HOME/CreateDB.log SQL> create spfile from pfile; SQL> startup nomount SQL> define _editor=vi SQL> commit; SQL> ed -- paste the following into the editor, save, and exit CREATE DATABASE orabase MAXINSTANCES 8 MAXLOGHISTORY 292 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE '/app/oracle/product/oradata/orabase/system01.dbf' SIZE 750M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/app/oracle/product/oradata/orabase/sysaux01.dbf' SIZE 1G REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/app/oracle/product/oradata/orabase/temp01.dbf' SIZE 125M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED UNDO TABLESPACE "UNDOTBS1" DATAFILE '/app/oracle/product/oradata/orabase/undotbs01.dbf' SIZE 500M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16 LOGFILE GROUP 1 ( '/home/oracle/redo01a.log', '/home/oracle/redo01b.log', '/home/oracle/redo01c.log') SIZE 100M, GROUP 2 ( '/app/oracle/product/oradata/orabase/redo02a.log', '/app/oracle/product/oradata/orabase/redo02b.log', '/app/oracle/product/oradata/orabase/redo02c.log') SIZE 100M, GROUP 3 ( '/app/oracle/product/redo03a.log', '/app/oracle/product/redo03b.log', '/app/oracle/product/redo03c.log') SIZE 100M SET TIME_ZONE = '+08:00' USER sys IDENTIFIED BY "&&sysPassword" USER system IDENTIFIED BY "&&systemPassword" -- during CREATE DATABASE the following scripts are run. Do not run them a second time. $ORACLE_HOME/rdbms/admin/dcore.bsq $ORACLE_HOME/rdbms/admin/dsqlddl.bsq $ORACLE_HOME/rdbms/admin/dmanage.bsq $ORACLE_HOME/rdbms/admin/dplsql.bsq $ORACLE_HOME/rdbms/admin/dtxnspc.bsq $ORACLE_HOME/rdbms/admin/dfmap.bsq $ORACLE_HOME/rdbms/admin/denv.bsq $ORACLE_HOME/rdbms/admin/drac.bsq $ORACLE_HOME/rdbms/admin/dsec.bsq $ORACLE_HOME/rdbms/admin/doptim.bsq $ORACLE_HOME/rdbms/admin/dobj.bsq $ORACLE_HOME/rdbms/admin/djava.bsq $ORACLE_HOME/rdbms/admin/dpart.bsq $ORACLE_HOME/rdbms/admin/drep.bsq $ORACLE_HOME/rdbms/admin/daw.bsq $ORACLE_HOME/rdbms/admin/dsummgt.bsq $ORACLE_HOME/rdbms/admin/dtools.bsq $ORACLE_HOME/rdbms/admin/dexttab.bsq $ORACLE_HOME/rdbms/admin/ddm.bsq $ORACLE_HOME/rdbms/admin/dlmnr.bsq $ORACLE_HOME/rdbms/admin/daw.bsq -- verify things look good so far SQL> desc obj$ SQL> desc tab$ -- continue by creating the data dictionary views SQL> @?/rdbms/admin/catalog.sql SQL> @?/rdbms/admin/catproc.sql SQL> @?/rdbms/admin/catactx.sql SQL> @?/rdbms/admin/catadvtb.sql -- verify the following SQL> @?/rdbms/admin/catptabs.sql SQL> @?/rdbms/admin/catprc.sql SQL> @?/rdbms/admin/catexp.sql SQL> @?/rdbms/admin/catdbsyn.sql SQL> @?/rdbms/admin/cataudit.sql SQL> @?/rdbms/admin/catodm.sql SQL> @?/rdbms/admin/catost.sql SQL> @?/rdbms/admin/catadv.sql SQL> @?/rdbms/admin/catsnap.sql SQL> @?/rdbms/admin/catmgrsv.sql SQL> @?/rdbms/admin/catxdbv.sql SQL> @?/rdbms/admin/cdcore.sql SQL> @?/rdbms/admin/cdpart.sql SQL> @?/rdbms/admin/dbmsrman.sql SQL> @?/rdbms/admin/c1101000.sql -- patching? GRANT select ON gv_$reserved_words TO PUBLIC; REVOKE execute ON dbms_lob FROM public; REVOKE execute ON utl_file FROM public; REVOKE execute ON utl_http FROM public; REVOKE execute ON utl_inaddr FROM public; REVOKE execute ON utl_mail FROM public; REVOKE execute ON utl_smtp FROM public; -- you will want to add many more to this list SELECT table_name FROM all_tab_privs_made WHERE privilege = 'EXECUTE' AND grantee = 'PUBLIC' AND (table_name LIKE 'DBMS%' OR table_name LIKE 'UTL%') ORDER BY 1; spool off

Database Creation For UNIX Used By Older Versions of Oracle's E-Business Suite Applications.

An excellent example of how not to do it in the current millennium. spool $HOME/CreateDB.log CREATE DATABASE ctl1102A maxdatafiles 1022 maxlogmembers 4 character set "WE8ISO8859P1" DATAFILE '/u03/oradata/ctl1102A/system01.dbf' SIZE 1G AUTOEXTEND ON NEXT 25M MAXSIZE 1G LOGFILE GROUP 1 ('/u05/oradata/redo01a.log','/u06/oradata/redo01b.log') SIZE 500M, GROUP 2 ('/u05/oradata/redo02a.log','/u06/oradata/redo02b.log') SIZE 500M, GROUP 3 ('/u05/oradata/redo03a.log','/u06/oradata/redo03b.log') SIZE 500M; CREATE TABLESPACE USERS DATAFILE '/u03/oradata/ctl1102A/users01.dbf' SIZE 5M AUTOEXTEND ON NEXT 5 MAXSIZE 2G; CREATE TABLESPACE RBS DATAFILE '/u07/oradata/ctl1102A/rbs01.dbf' SIZE 1G AUTOEXTEND ON NEXT 5 MAXSIZE 2G; CREATE TABLESPACE TOOLS DATAFILE '/u03/oradata/ctl1102A/tools01.dbf' SIZE 50M AUTOEXTEND ON NEXT 5 MAXSIZE 2G; CREATE TABLESPACE CTXD DATAFILE '/u13/oradata/ctl1102A/ctxd01.dbf' SIZE 50M AUTOEXTEND ON NEXT 5 MAXSIZE 2G; CREATE TABLESPACE TEMP DATAFILE '/u04/oradata/ctl1102A/temp01.dbf' SIZE 100M AUTOEXTEND ON NEXT 5 MAXSIZE 2G; CREATE TABLESPACE AKD DATAFILE '/u13/oradata/ctl1102A/akd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE AKX DATAFILE '/u14/oradata/ctl1102A/akx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE ALRD DATAFILE '/u16/oradata/ctl1102A/alrd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE ALRX DATAFILE '/u15/oradata/ctl1102A/alrx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE APD DATAFILE '/u13/oradata/ctl1102A/apd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE APX DATAFILE '/u14/oradata/ctl1102A/apx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE ARD DATAFILE '/u16/oradata/ctl1102A/ard01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE ARX DATAFILE '/u15/oradata/ctl1102A/arx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE ASD DATAFILE '/u13/oradata/ctl1102A/asd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE ASX DATAFILE '/u14/oradata/ctl1102A/asx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE AXD DATAFILE '/u16/oradata/ctl1102A/axd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE AXX DATAFILE '/u15/oradata/ctl1102A/axx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE AZD DATAFILE '/u13/oradata/ctl1102A/azd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE AZX DATAFILE '/u14/oradata/ctl1102A/azx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE BOMD DATAFILE '/u16/oradata/ctl1102A/bomd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE BOMX DATAFILE '/u15/oradata/ctl1102A/bomx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE CED DATAFILE '/u13/oradata/ctl1102A/ced01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE CEX DATAFILE '/u14/oradata/ctl1102A/cex01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE CHVD DATAFILE '/u16/oradata/ctl1102A/chvd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE CHVX DATAFILE '/u15/oradata/ctl1102A/chvx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE CND DATAFILE '/u13/oradata/ctl1102A/cnd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE CNX DATAFILE '/u14/oradata/ctl1102A/cnx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE CRPD DATAFILE '/u16/oradata/ctl1102A/crpd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE CRPX DATAFILE '/u15/oradata/ctl1102A/crpx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE CSD DATAFILE '/u13/oradata/ctl1102A/csd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE CSX DATAFILE '/u14/oradata/ctl1102A/csx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE CZD DATAFILE '/u13/oradata/ctl1102A/czd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE CZX DATAFILE '/u14/oradata/ctl1102A/czx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE ECD DATAFILE '/u16/oradata/ctl1102A/ecd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE ECX DATAFILE '/u15/oradata/ctl1102A/ecx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE ENGD DATAFILE '/u13/oradata/ctl1102A/engd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE ENGX DATAFILE '/u14/oradata/ctl1102A/engx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE FAD DATAFILE '/u16/oradata/ctl1102A/fad01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE FAX DATAFILE '/u15/oradata/ctl1102A/fax01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE FLMD DATAFILE '/u13/oradata/ctl1102A/flmd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE FLMX DATAFILE '/u14/oradata/ctl1102A/flmx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE FNDD DATAFILE '/u16/oradata/ctl1102A/fndd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE FNDX DATAFILE '/u15/oradata/ctl1102A/fndx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE GLD DATAFILE '/u13/oradata/ctl1102A/gld01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE GLX DATAFILE '/u14/oradata/ctl1102A/glx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE HRD DATAFILE '/u13/oradata/ctl1102A/hrd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE HRX DATAFILE '/u14/oradata/ctl1102A/hrx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE HXTD DATAFILE '/u16/oradata/ctl1102A/hxtd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE HXTX DATAFILE '/u15/oradata/ctl1102A/hxtx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE ICXD DATAFILE '/u13/oradata/ctl1102A/icxd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE ICXX DATAFILE '/u14/oradata/ctl1102A/icxx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE INVD DATAFILE '/u16/oradata/ctl1102A/invd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE INVX DATAFILE '/u15/oradata/ctl1102A/invx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE JAD DATAFILE '/u13/oradata/ctl1102A/jad01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE JAX DATAFILE '/u14/oradata/ctl1102A/jax01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE JED DATAFILE '/u16/oradata/ctl1102A/jed01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE JEX DATAFILE '/u15/oradata/ctl1102A/jex01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE JGD DATAFILE '/u13/oradata/ctl1102A/jgd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE JGX DATAFILE '/u14/oradata/ctl1102A/jgx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE JLD DATAFILE '/u16/oradata/ctl1102A/jld01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE JLX DATAFILE '/u15/oradata/ctl1102A/jlx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE MFGD DATAFILE '/u13/oradata/ctl1102A/mfgd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE MFGX DATAFILE '/u14/oradata/ctl1102A/mfgx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE MRPD DATAFILE '/u13/oradata/ctl1102A/mrpd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE MRPX DATAFILE '/u14/oradata/ctl1102A/mrpx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE MSCD DATAFILE '/u13/oradata/ctl1102A/mscd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE MSCX DATAFILE '/u14/oradata/ctl1102A/mscx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE OED DATAFILE '/u16/oradata/ctl1102A/oed01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE OEX DATAFILE '/u15/oradata/ctl1102A/oex01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE OSMD DATAFILE '/u16/oradata/ctl1102A/osmd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE OSMX DATAFILE '/u15/oradata/ctl1102A/osmx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE OTAD DATAFILE '/u13/oradata/ctl1102A/otad01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE OTAX DATAFILE '/u14/oradata/ctl1102A/otax01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE PAD DATAFILE '/u16/oradata/ctl1102A/pad01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE PAX DATAFILE '/u15/oradata/ctl1102A/pax01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE PJMD DATAFILE '/u16/oradata/ctl1102A/pjmd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE PJMX DATAFILE '/u15/oradata/ctl1102A/pjmx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE POD DATAFILE '/u13/oradata/ctl1102A/pod01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE POX DATAFILE '/u14/oradata/ctl1102A/pox01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE QAD DATAFILE '/u16/oradata/ctl1102A/qad01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE QAX DATAFILE '/u15/oradata/ctl1102A/qax01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE RGD DATAFILE '/u13/oradata/ctl1102A/rgd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE RGX DATAFILE '/u14/oradata/ctl1102A/rgx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE RLAD DATAFILE '/u16/oradata/ctl1102A/rlad01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE RLAX DATAFILE '/u15/oradata/ctl1102A/rlax01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE SSPD DATAFILE '/u13/oradata/ctl1102A/sspd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE SSPX DATAFILE '/u14/oradata/ctl1102A/sspx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE VEHD DATAFILE '/u16/oradata/ctl1102A/vehd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE VEHX DATAFILE '/u15/oradata/ctl1102A/vehx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE WIPD DATAFILE '/u13/oradata/ctl1102A/wipd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE WIPX DATAFILE '/u14/oradata/ctl1102A/wipx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE WHD DATAFILE '/u16/oradata/ctl1102A/whd01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; CREATE TABLESPACE WHX DATAFILE '/u15/oradata/ctl1102A/whx01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1 MAXSIZE 2G; spool off

Alter Database Control File Clauses

Control File Management See the Control Files page in the library: Link below

Alter Database Default Settings Clauses

Set Default Tablespace Type ALTER DATABASE SET DEFAULT <BIGFILE | SMALLFILE> TABLESPACE;

ALTER DATABASE SET DEFAULT smallfile TABLESPACE;

Set Default Tablespace ALTER DATABASE SET DEFAULT TABLESPACE <tablespace_name>;

ALTER DATABASE SET DEFAULT TABLESPACE uwdata;

Set Default Temporary Tablespace ALTER DATABASE DEFAULT TEMPORARY TABLESPACE <group_name>;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE app_grp;

Set Default Temporary Tablespace Group ALTER DATABASE DEFAULT TEMPORARY TABLESPACE <tablespace_group_name>;

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp_grp;

Change Global Name ALTER DATABASE RENAME GLOBAL_NAME TO <new_name>;

-- verify global name

      SELECT value$

      FROM props$

      WHERE name = 'GLOBAL_DB_NAME';

      

      VALUE$

      ---------

      ORABASEXX

      

      SELECT *

      FROM global_name;

      

      GLOBAL_NAME

      -----------

      ORABASEXX

      

      -- backup controlfile

      ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

      

      -- change the trace file CREATE CONTROLFILE command to

      CREATE CONTROLFILE REUSE  SET DATABASE "NEW_SID_NAME" RESETLOGS;

      

      SHUTDOWN IMMEDIATE;

      

      -- modify the db_name parameter in the initSID.ora

      conn / as sysdba

      

      CREATE spfile FROM pfile='initSID.ora';

      

      STARTUP NOMOUNT

      

      -- execute the create controlfile command

      

      -- recover database USING BACKUP CONTROLFILE until cancel

      

      CANCEL

      

      -- open resetlogs the database and

      ALTER DATABASE RENAME GLOBAL_NAME TO new_sid_name;

Disable Block Change Tracking ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;

ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;

Enable Block Change Tracking ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '<file_name>' REUSE;

ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

      USING FILE ' '/app/oracle/fast_recovery_area/bct.log'  REUSE;

Flashback Mode ALTER DATABASE FLASHBACK <ON | OFF>;

ALTER DATABASE FLASHBACK ON;

Set Time Zone By Delta ALTER DATABASE SET TIME_ZONE <+ | -> HH:MI;

ALTER DATABASE SET TIME_ZONE '-5:0';

Set Time Zone By Name ALTER DATABASE SET TIME_ZONE <time_zone_region>;

ALTER DATABASE SET TIME_ZONE 'US/Eastern';

Alter Database Log File Clauses

Section Note See the Log Files page in the library: Link below

Clear A Log File ALTER DATABASE CLEAR [UNARCHIVED] LOGFILE <logfile_path_and_name> [UNRECOVERABLE DATAFILE];

ALTER DATABASE CLEAR LOGFILE '/u01/orabase19/oradata/ORABASEXIX/redo5c.log';

Stop Force Logging ALTER DATABASE NO FORCE LOGGING;

SELECT force_logging FROM v$database;

      

      ALTER DATABASE NO FORCE LOGGING;

      

      SELECT force_logging FROM v$database;

Start Archive Logging ALTER DATABASE ARCHIVELOG MANUAL;

SELECT log_mode FROM v$database;

      

      ALTER DATABASE ARCHIVELOG MANUAL;

      

      SELECT log_mode FROM v$database;

Stop Archive Logging ALTER DATABASE NOARCHIVELOG;

SELECT log_mode FROM v$database;

      

      ALTER DATABASE NOARCHIVELOG;

      

      SELECT log_mode FROM v$database;

Supplemental DB Logging ALTER DATABASE <ADD | DROP> SUPPLEMENTAL LOG DATA [(ALL | PRIMARY KEY | UNIQUE | FOREIGN KEY) COLUMNS];

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (UNIQUE) COLUMNS;

ALTER DATABASE REGISTER LOGICAL LOGFILE  '/u01/orabase19e/fast_recovery_area/orabasexix/archivelog/arch_398_1_705869229.arc';

Alter Database Character Set Clauses

Set the character set ALTER DATABASE CHARACTER SET INTERNAL_CONVERT <CHARACTER SET>;

ALTER DATABASE CHARACTER SET INTERNAL_CONVERT WE8MSWIN1252;

Set the national character set ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_CONVERT <CHARACTER SET>;

SELECT value

      FROM v$nls_valid_values

      WHERE parameter = 'CHARACTERSET'

      ORDER BY 1;

      

      ALTER DATABASE NATIONALCHARACTER SET INTERNAL_CONVERT AL16UTF16;

Alter Database Hot Backup

Section Note I've put this in here for historical, perhaps hysterical, reasons. If you use these commands you are decades past the mandatory retirement age.

Section Note I've put this in here for historical, perhaps hysterical, reasons. If you use these commands you are several decades past the mandatory retirement age.

Put the database into hot backup mode ALTER DATABASE BEGIN BACKUP;

ALTER DATABASE BEGIN BACKUP;

Take the database out of hot backup mode ALTER DATABASE END BACKUP;

ALTER DATABASE  END BACKUP;

      ALTER SYSTEM ARCHIVE LOG CURRENT;

Alter Database Recovery Clauses

Section Note I've put this in here for historical, perhaps hysterical, reasons. If you use these commands you are decades past the mandatory retirement age.

Alter Database Redo Thread Clauses (RAC)

Disable RAC Thread ALTER DATABASE DISABLE THREAD <integer>;

ALTER DATABASE DISABLE THREAD 7;

Enable RAC Thread ALTER DATABASE ENABLE PUBLIC THREAD <integer>;

ALTER DATABASE ENABLE PUBLIC THREAD 5;

Alter Database Security Clause

Prevent data in the database from being altered ALTER DATABASE GUARD <ALL | STANDBY | NONE>;

ALTER DATABASE GUARD ALL;

Alter Database Standby Database Clauses

Section Note Standby Database clauses are covered on the DataGuard page linked at page bottom

Alter Database Startup Clauses

Mount CDB container but do not open ALTER DATABASE MOUNT [<STANDBY | CLONE> DATABASE];

conn / as sysdba

      

      ALTER DATABASE MOUNT;

Open Database Read Only ALTER DATABASE OPEN READ ONLY;

conn / as sysdba

      

      ALTER DATABASE OPEN READ ONLY;

Open Database Read-Write ALTER DATABASE OPEN READ WRITE <RESETLOGS | NORESETLOGS> [<UPGRADE | DOWNGRADE>];

conn / as sysdba

      

      ALTER DATABASE OPEN READ WRITE RESETLOGS;

Alter Database Storage Clauses

Rename File ALTER DATABASE RENAME FILE <current_file_name> TO <new_file_name>;

conn sys@pdbdev as sysdba

      

      ALTER DATABASE RENAME FILE '/app/oracle/oradata/orabase/pdbdev/example.dbf' TO '/app/oracle/oradata/orabase/pdbdev/demos01.dbf';

Create Datafile ALTER DATABASE CREATE DATAFILE <file_name | file_number> AS <file_specification | NEW>;

conn sys@pdbtest as sysdba

      

      col file_name format a50

      

      SELECT file_name, file_id

      FROM dba_data_files;

      

      ALTER DATABASE CREATE DATAFILE 8  AS NEW;

      

      SELECT file_name, file_id

      FROM dba_data_files;

Alter Database Datafile

Resize Datafile ALTER DATABASE DATAFILE <file_name | file_number> RESIZE TO <integer><M | G | T | P>;

ALTER DATABASE DATAFILE 8 RESIZE 15G;

Make Datafile Not Autoextensible ALTER DATABASE DATAFILE <file_name | file_number> AUTOEXTEND <OFF | ON [NEXT <integer><M | G | T | P> MAXSIZE <UNLIMITED | <integer><M | G | T | P>]>;

SELECT file_name, autoextensible

      FROM dba_data_files;

      

      ALTER DATABASE DATAFILE 8 AUTOEXTEND OFF;

      

      SELECT file_name, autoextensible

      FROM dba_data_files;

Make datafile autoextensible ALTER DATABASE DATAFILE <file_name | file_number> AUTOEXTEND ON NEXT <integer><M | G | T> MAXSIZE <UNLIMITED | <integer><M | G | T | P>;

conn sys@pdbtest as sysdba

      

      SELECT file_name, autoextensible

      FROM dba_data_files;

      

      ALTER DATABASE DATAFILE 8 AUTOEXTEND ON NEXT 10G MAXSIZE 100M;

      

      SELECT file_name, autoextensible

      FROM dba_data_files;

Take a datafile offline or online: by name ALTER DATABASE DATAFILE <file_name | file_number> <OFFLINE | ONLINE>;

/* To use this form of the ALTER DATABASE statement, the database must be in ARCHIVELOG mode.
      This requirement prevents you from accidentally losing the datafile, since taking the datafile offline while in NOARCHIVELOG mode is likely to result in losing the file. */

      

      conn sys@pdbtest as sysdba

      

      SELECT file_name, status

      FROM dba_data_files;

      
      

      ALTER DATABASE DATAFILE '/u02/oracle/oradata/orabase/pdbtest/stuff01.dbf' OFFLINE;

      

      SELECT file_name, status

      FROM dba_data_files;

      

      ALTER DATABASE DATAFILE '/u02/oracle/oradata/orabase/pdbtest/stuff01.dbf' ONLINE;

      

      SELECT file_name, status

      FROM dba_data_files;

Take a datafile offline or online: by number ALTER DATABASE <file_name |file_number> OFFLINE;

conn sys@pdbtest as sysdba

      

      col file_name format a50

      

      SELECT file_name, status

      FROM dba_data_files;

      

      ALTER DATAFILE 8
      OFFLINE;

      

      SELECT file_name, status

      FROM dba_data_files;

      

      ALTER DATAFILE 8 ONLINE;

      

      SELECT file_name, status

      FROM dba_data_files;

Offline and drop datafile
-- NOARCHIVELOG mode only ALTER DATABASE <file_name |file_number> OFFLINE DROP;

conn sys@pdbtest as sysdba

      

      ALTER DATABASE DATAFILE '/u02/oracle/oradata/orabase/pdbtest/users03.dbf' OFFLINE DROP;

Alter Database Tempfile

Resize Tempfile ALTER DATABASE TEMPFILE <file_name | file_number> RESIZE TO <integer><M | G | T>;

col file_name format a45

      col tablespace_name format a20

      

      SELECT file_name, file_id, tablespace_name, (bytes/1024/1024) SIZE_IN_MB

      FROM dba_temp_files;

      

      ALTER DATABASE TEMPFILE 1 RESIZE 25G;

SELECT file_name, autoextensible

      FROM dba_temp_files;

      

      ALTER DATABASE TEMPFILE '/app/oracle/oradata/orabase/temp01.dbf' AUTOEXTEND ON NEXT 2G MAXSIZE 128G;

Drop Tempfile ALTER DATABASE TEMPFILE <file_name | file_number> DROP;

SELECT file_id, file_name, tablespace_name

      FROM dba_temp_files;

      

      ALTER DATABASE TEMPFILE 1 DROP;

Place Tempfile Offline/Online ALTER DATABASE TEMPFILE <file_name | file_number> OFFLINE;

SELECT file_name, file_id, status

      FROM dba_temp_files;

      

      FILE_NAME                                       FILE_ID STATUS

      ----------------------------------------------- ------- -----------

      C:\U01\ORABASE19\ORADATA\ORABASEXIX\TEMP01.DBF        1 ONLINE

      

      ALTER DATABASE TEMPFILE 1 OFFLINE;

      

      Database altered.

      

      SELECT file_name, file_id, status

      FROM dba_temp_files;

      

      FILE_NAME                                       FILE_ID STATUS

      ----------------------------------------------- ------- -----------

      C:\U01\ORABASE19\ORADATA\ORABASEXIX\TEMP01.DBF        1 OFFLINE

      

      ALTER DATABASE TEMPFILE 1 ONLINE;

      

      Database altered.

      

      SELECT file_name, file_id, status

      FROM dba_temp_files;

      

      FILE_NAME                                       FILE_ID STATUS

      ----------------------------------------------- ------- -----------

      C:\U01\ORABASE19\ORADATA\ORABASEXIX\TEMP01.DBF        1 ONLINE

Drop Database

Do not try this one for testing as it does exactly what it says unless you really want to drop the database removing all files DROP DATABASE;

SHUTDOWN ABORT;

      

      STARTUP MOUNT  RESTRICT;

      

      DROP DATABASE;

Related Queries

Installed Options col parameter format a40 col value format a20 SELECT * FROM gv$option; col comp_name format a35 col version format a11 col status format a11 SELECT comp_name, version, status FROM dba_registry ORDER BY 1; COMP_NAME VERSION STATUS ----------------------------------- ----------- ----------- JServer JAVA Virtual Machine 19.0.0.0.0 VALID Messaging Gateway 19.0.0.0.0 VALID OLAP Analytic Workspace 19.0.0.0.0 VALID Oracle Database Catalog Views 19.0.0.0.0 VALID Oracle Database Java Packages 19.0.0.0.0 VALID Oracle Database Packages and Types 19.0.0.0.0 VALID Oracle Database Vault 19.0.0.0.0 VALID Oracle Label Security 19.0.0.0.0 VALID Oracle Multimedia 19.0.0.0.0 VALID Oracle OLAP API 19.0.0.0.0 VALID Oracle Real Application Clusters 19.0.0.0.0 OPTION OFF Oracle Text 19.0.0.0.0 VALID Oracle Workspace Manager 19.0.0.0.0 VALID Oracle XDK 19.0.0.0.0 VALID Oracle XML Database 19.0.0.0.0 VALID Spatial 19.0.0.0.0 VALID

Database Properties from a data dictionary view set linesize 141 col property_name format a28 col property_value format a32 col description format a25 SELECT * FROM database_properties ORDER BY 1; PROPERTY_NAME PROPERTY_VALUE DESCRIPTION ---------------------------- -------------------------------- ------------------------- CON_VSN 4 version number for the CDB or the Application Container DBTIMEZONE 00:00 DB time zone DEFAULT_EDITION ORA$BASE Name of the database default edition DEFAULT_PERMANENT_TABLESPACE USERS Name of default permanent tablespace DEFAULT_TBS_TYPE SMALLFILE Default tablespace type DEFAULT_TEMP_TABLESPACE TEMP Name of default temporary tablespace DICT.BASE 2 dictionary base tables version # DICTIONARY_ENDIAN_TYPE LITTLE Endian type of the data dictionary DST_PRIMARY_TT_VERSION 32 Version of primary timezone data file DST_SECONDARY_TT_VERSION 0 Version of secondary time zone data file DST_UPGRADE_STATE NONE State of Day Light Saving Time Upgrade EXPORT_VIEWS_VERSION 8 Export views revision # Flashback Timestamp TimeZone GMT Flashback timestamp created in GMT GLOBAL_DB_NAME ORABASEX Global database name LOCAL_UNDO_ENABLED TRUE true if local undo is enabled MAX_PDB_SNAPSHOTS 8 maximum number of snapshots for a given PDB MAX_STRING_SIZE STANDARD MAX_STRING_SIZE parameter used for dictionary metadata NLS_CALENDAR GREGORIAN Calendar system NLS_CHARACTERSET AL32UTF8 Character set NLS_COMP BINARY NLS comparison NLS_CURRENCY $ Local currency NLS_DATE_FORMAT DD-MON-RR Date format NLS_DATE_LANGUAGE AMERICAN Date language NLS_DUAL_CURRENCY $ Dual currency symbol NLS_ISO_CURRENCY AMERICA ISO currency NLS_LANGUAGE AMERICAN Language NLS_LENGTH_SEMANTICS BYTE NLS length semantics NLS_NCHAR_CHARACTERSET AL16UTF16 NCHAR Character set NLS_NCHAR_CONV_EXCP FALSE NLS conversion exception NLS_NUMERIC_CHARACTERS ., Numeric characters NLS_RDBMS_VERSION 19.0.0.0.0 RDBMS version for NLS parameters NLS_SORT BINARY Linguistic definition NLS_TERRITORY AMERICA Territory NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM Time stamp format NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR Timestamp with timezone format NLS_TIME_FORMAT HH.MI.SSXFF AM Time format NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR Time with timezone format NO_USERID_VERIFIER_SALT E4FA6F27C073C7D5C89D3E2FBCA3D0C7 Per database random key for computing faux salt OLS_OID_STATUS 0 OLS OID Status used for Label Security TDE_MASTER_KEY_ID WORKLOAD_CAPTURE_MODE CAPTURE implies workload capture is in progress WORKLOAD_REPLAY_MODE PREPARE implies external replay clients can connect; REPLAY implies workload replay is in progress

Database Properties from a data dictionary table set linesize 141 col value$ format a35 col comment$ format a53 SELECT * FROM props$ ORDER BY 1;