Oracle 23c SSB setting Tips
A small data pump export file for the SSB schema that can be used on a laptop
Oracle 23c SQL Diagnostic Report Tips
SQL Diagnostic Report
DBMS_SQLDIAG has a new function called REPORT_SQL
Oracle 23c set user password limit Tips
There is below errors while set simple password for test user.
ORA-28003: The password chosen did not meet the required complexity rules set
by your organization.
ORA-20000: password length less than 9 characters
Oracle 23c dbcs basic Tips
Some info
Oracle 23c create acfs in dbcs Tips
Create ACFS for oracle user.
Oracle CONTROL_FILE_RECORD_KEEP_TIME Tips
CONTROL_FILE_RECORD_KEEP_TIME
CONTROL_FILE_RECORD_KEEP_TIME specifies the minimum number of days before a reusable record in the control file can be reused.
Note:This parameter applies only to records in the control file that are circularly reusable (such as archive log records and various backup records). It does not apply to records such as data file, tablespace, and redo thread records, which are never reused unless the corresponding object is dropped from the tablespace.
Oracle NLS_DATE_FORMAT Tips
Setting NLS_DATE_FORMAT in the shell environment variable using setenv or export command is not effective. When querying dates from SQL*Plus, it does not reflect the NLS_DATE_FORMAT.
% setenv NLS_DATE_FORMAT 'YYYYMMDD'
% sqlplus / as sysdba
SQL> select sysdate from dual;
SYSDATE
---------
17-SEP-18
Oracle 23c Free rpm install Tips
MySQL 8.0 Study 015 Tips
学习系列
MySQL 8.0 Study 014 Tips
学习系列
Oracle drop user trace Tips
SYS@cdb1> drop user C##_U1;
drop user C##_U1
*
ERROR at line 1:
ORA-01922: CASCADE must be specified to drop 'C##_U1'
SYS@cdb1>
MySQL 8.0 Study 000 Tips
常用sql