Lucy's thoughts ...

Search This Blog

ADG_REDIRECT_DML in Oracle Active Data Guard 19c

on October 27, 2022

0

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Oracle Release Schedule

on October 18, 2017

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Release Schedule of Current Database Releases (Doc ID 742060.1)

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

Oracle: Understanding the table user$

Table user$ : SQL> desc user$ Name Null? Type ----------------------------------------- -------- ---------------------------- USER# NOT NULL NUMBER NAME NOT NULL VARCHAR2(30) TYPE# NOT NULL NUMBER PASSWORD VARCHAR2(30) DATATS# NOT NULL NUMBER TEMPTS# NOT NULL NUMBER CTIME NOT NULL DATE PTIME DATE EXPTIME DATE LTIME DATE RESOURCE$ NOT NULL NUMBER AUDIT$ VARCHAR2(38) DEFROLE NOT NULL NUMBER DEFGRP# NUMBER DEFGRP_SEQ# NUMBER ASTATUS NOT NULL NUMBER LCOUNT NOT NULL NUMBER DEFSCHCLASS VARCHAR2(30) EXT_USERNAME VARCHAR2(4000) SPARE1 NUMBER SPARE2 NUMBER SPARE3 NUMBER SPARE4 VARCHAR2(1000) SPARE5 VARCHAR2(1000) SPARE6 DATE Explanation of some columns: CTIME is the date the user was created. LTIME is the date the user was last locked. (Note that it d

"psdgbt: bind csid (1) does not match session csid (873)" and "psdgbt: session charset is AL32UTF8"

After restart of the server and starting the database you can notice a lot of generated trace files: Fri Aug 25 10:18:48 2017 Errors in file /oracle/orcldb/base/diag/rdbms/orcldb_dc1/orcldb/trace/orcldb_ora_2131.trc: Errors in file /oracle/orcldb/base/diag/rdbms/orcldb_dc1/orcldb/trace/orcldb_ora_2131.trc: Fri Aug 25 10:18:59 2017 Errors in file /oracle/orcldb/base/diag/rdbms/orcldb_dc1/orcldb/trace/orcldb_ora_2131.trc: Errors in file /oracle/orcldb/base/diag/rdbms/orcldb_dc1/orcldb/trace/orcldb_ora_2131.trc: Fri Aug 25 10:19:10 2017 Errors in file /oracle/orcldb/base/diag/rdbms/orcldb_dc1/orcldb/trace/orcldb_ora_2131.trc: Errors in file /oracle/orcldb/base/diag/rdbms/orcldb_dc1/orcldb/trace/orcldb_ora_2131.trc: Fri Aug 25 10:19:23 2017 Errors in file /oracle/orcldb/base/diag/rdbms/orcldb_dc1/orcldb/trace/orcldb_ora_2131.trc: Errors in file /oracle/orcldb/base/diag/rdbms/orcldb_dc1/orcldb/trace/orcldb_ora_2131.trc: Fri Aug 25 10:19:50 2017 Errors in file /oracle/orcldb/base/diag/r

Oracle: How to change datatype VARCHAR2 to CLOB

At the beginning of creation database structure you decided to use datatype VARCHAR2 and that time you thought 4000B should be enough. But later you want to insert more than 4000B, it's time to change this datatype to CLOB. If you don't have data in the table, it's ideal situation and the solution is very easy: SQL> create table test ( 2 id number, 3 name varchar2(50), 4 comments varchar2(4000) 5 ); Table created. SQL> desc test Name Null? Type ----------------------------------------- -------- ---------------------------- ID NUMBER NAME VARCHAR2(50) COMMENTS VARCHAR2(4000) Because there is not direct way, how to modify column from VARCHAR2 to CLOB, we need to modify column in two steps. Steps: - VARCHAR2 --> LONG - LONG --> CLOB SQL> alter table test modi

Powered by Blogger

Lucia Hustatyova

ADG_REDIRECT_DML in Oracle Active Data Guard 19c

Oracle Release Schedule

Comments

Post a Comment