Locale

How to Fix Garbled Filename

Posted on
There’re several ways to display your garbled filename correctly. Correct LANG Environment Variable Correct PuTTY Character Set Rename Badly Encoded Filename Correct LANG Environment Variable Tried to list a file which name is made by a multi-byte language like this. [root@test ~]# ll total 8 -rw-r–r–  1 root root  217 Oct 17 00:39 ▒?▒▒?▒▒?▒.txt … […]
Shell Script

How to Cat a File Content by iNode

Posted on
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 -rw-r–r–   1 root root  174 Oct 17 17:31 402653313 dr-xr-x—.  3 root root 4096 Oct 17 17:36 .       128 dr-xr-xr-x. 18 root root 4096 Oct 17 17:27 […]
Table

How Big a Table Can Be

Posted on
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 space, so theoretically, there’s no space limit on a table. But not so fast, we should consider other factors. Since one ordinary table can only be stored in one tablespace, […]
Space

How Big a Database Can Be

Posted on
Create Tablespace in a Database
Maximum Size Limit of a Database After knowing how big a data file can be and how big a tablespace can be in previous posts, we can continue to calculate how big a database can be. According to the physical database limits, we can have at most 65533 data files or 64000 tablespaces in a […]
Tablespace

How Big a Tablespace Can Be

Posted on
Add DataFile in a Tablespace
Maximum Size Limit of a Tablespace Basically, at least one data file should be specified in the tablespace creation, thereafter we can add more data files to the tablespace. After knowing how big a data file can be in the previous post, we can continue to calculate how big a tablespace can be. For a […]
Data File

How Big a Data File Can Be

Posted on
DB Blocks Auto Extend in a Data File
Maximum Size Limit of a Data File According to Oracle Database Physical Database Limits, we can have approximate 222 database blocks for a data file in a smallfile tablespace (default) and 232 database blocks for a data file in a bigfile tablespace. In fact, the exact allowable database blocks in a data file should be […]
Startup and Shutdown

How to Stop Oracle Database

Posted on
Stop Oracle Database After knowing how to start an Oracle database, we may begin to learn something about stopping an Oracle database. Stopping a database is a less complex job than starting a database. This is because all kinds of shutdown shall go to the idle state eventually, no matter what state currently is. That […]
Startup and Shutdown

How to Start Oracle Database

Posted on
Start Oracle Database To start Oracle database, you have to know what database you want to start. This includes at least two things, where Oracle home is and what Oracle SID is. For remote database startup, you additionally need to know where the server is. The startup can be manual or automatic, it depends on […]
Table

How to Check Oracle Table Size

Posted on
Although we have listed the top 10 biggest tables in our Oracle database, we also can check single table size by similar ways. Theoretical Table Size We used NUM_ROWS and AVG_ROW_LEN (in byte) in DBA_TABLES to calculate how many bytes that active rows of the table are used. The result can not be very accurate […]
Globalization

ORA-01846: 指定した曜日が無効です。の解決方法

Posted on
ORA-01846 ORA-01846: 指定した曜日が無効です。、SQLエンジンは現在のNLS_DATE_LANGUAGEで入力文字列の週の日の値を認識できません。この投稿では、以下に示すORA-01846のエラーパターンについて説明します。 週の比類のない日の値 スペルミスのある曜日の値 週の外国の日の値 ORA-01846 週の比類のない日の値 [oracle@test ~]$ export NLS_LANG=Japanese_Japan.UTF8 [oracle@test ~]$ sqlplus /nolog … SQL> conn hr/hr Connected. SQL> set heading off; SQL> select value from v$nls_parameters where parameter = ‘NLS_DATE_LANGUAGE’; JAPANESE 週の曜日の値に何も問題がないと思われるかもしれませんが、使用した曜日の値はOracleによって受け入れられない場合があります。例を見てみましょう。 次に、「きんようび」という用語を使用しました。これは、日本語でも「金曜日」を意味します。 SQL> select TO_DATE(‘2019-08-30, きんようび’, ‘YYYY-MM-DD, Day’) from dual; select TO_DATE(‘2019-08-30, きんようび’, ‘YYYY-MM-DD, Day’) from dual       […]