Ed Chen Logic - Page 3 of 76 - To Make My Logic More Logical

How to Resolve ORA-12899: value too large for column

by Ed Chen
November 13, 2019November 13, 2019

ORA-12899 ORA-12899 means that the value of being inserted or updated data is larger than column's allowable length that is defined in the table. Let's… Read More »

How to Resolve "Connected to an idle instance"

by Ed Chen
November 9, 2019January 14, 2020

Connected to an idle instance Actually, Connected to an idle instance is a message rather than an error, it indicates that the database you enter… Read More »

What Makes Instance Shutdown Itself

by Ed Chen
November 6, 2019November 7, 2019

What makes a running instance shutdown itself could be a very complicated topic to talk about, because we have to know what instance was thinking.… Read More »

How to Resolve ORA-00059: maximum number of DB_FILES exceeded

by Ed Chen
November 2, 2019November 13, 2019

ORA-00059 Found ORA-00059 when creating a new tablespace, it told us that the maximum number of data files (DB_FILES) had been reached and was likely… Read More »

What Can We See in a Normal Data File

by Ed Chen
October 30, 2019January 14, 2020

You might think that the content of a normal data file should be unrecognized binary text and we cannot really see it except using special… Read More »

How to Open Port on Windows Server

by Ed Chen
October 26, 2019November 29, 2019

After our Oracle database 12.2 has been created on Windows server, we should open port 1521 on firewall for incoming connections. For Linux, you can… Read More »

How to Install Oracle Database 12.2 on Windows Server

by Ed Chen
October 23, 2019November 1, 2019

The goal in this post is to install an Oracle database 12.2 on windows server 2012. Here we separate our job into 2 major steps:… Read More »

How to Fix Garbled Filename and Text

by Ed Chen
October 19, 2019October 24, 2019

There're several ways to display your garbled filename correctly. LANG Environment Variable PuTTY Character Set Rename Badly Encoded Filename A. LANG Environment Variable Tried to… Read More »

How to Cat a File Content by iNode

by Ed Chen
October 16, 2019October 23, 2019

Symptoms At times, we may see some garbled filenames or even worse, empty or white-spaced names like this: [root@test ~]# ls -lai total 48 402653349… Read More »

How Big a Table Can Be

by Ed Chen
October 12, 2019October 19, 2019

Maximum Size Limit of a Table According to Oracle Logical Database Limits, tables can have at most 1000 columns and no limit on rows and… Read More »