tag:blogger.com,1999:blog-60473015908105752512024-02-18T19:34:37.888-08:00Note 88Just write a simple notebudihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.comBlogger169125tag:blogger.com,1999:blog-6047301590810575251.post-36930514189370951182022-12-18T18:28:00.003-08:002022-12-18T18:28:17.628-08:00New RAM+SSD and Reinstall server HP DL380 Gen9<p> 1.tarik keluar 3/4 badan, buka tutup atas(tanpa alat),plastik, pasang RAM, tutup semua, pasang SSD</p><p>2.pasang monitor+keyboard+mouse di server</p><p>3.boot - tekan F10 - HP Smart Storage Administrator [ENTER]</p><p>4.[Configure] -> select All SSD, check UnASSIGNED Drives</p><p>5.RAID Level = Raid 1, biarkan default,[CREATE LOGICAL DRIVE] -> [FINISH]</p><p>6. [x] right top to [REBOOT]</p><p>7. boot - tekan F9 -> pilih boot dari FlashDisk (USB)</p>budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-5922805786651887672022-12-07T01:49:00.007-08:002022-12-07T18:47:28.538-08:00host=Debian11 ip-host=15 network=bridge virtual=ip12<p>#login root, remove DVD</p><p>nano /etc/apt/sources.list</p><p>menjadi=</p><p></p><blockquote><p>deb http://mirror.0x.sg/debian/ bullseye main</p><p>deb-src http://mirror.0x.sg/debian/ bullseye main</p><p><br /></p><p>deb http://security.debian.org/debian-security bullseye-security main</p><p>deb-src http://security.debian.org/debian-security bullseye-security main</p><p><br /></p><p># bullseye-updates, to get updates before a point release is made;</p><p># see https://www.debian.org/doc/manuals/debian-reference/ch02.en.html#_updates_and_backports</p><p>deb http://mirror.0x.sg/debian/ bullseye-updates main</p><p>deb-src http://mirror.0x.sg/debian/ bullseye-updates main</p></blockquote><p></p><p><br /></p><div>---end of sources.list</div><p>#allow root ssh</p><p>nano /etc/ssh/sshd_config</p><p><br /></p><p>#allow root login</p><p>nano /etc/gdm3/daemon.conf</p><p>[security]</p><p>AllowRoot=true</p><p><br /></p><p>nano /etc/pam.d/gdm-password</p><p>#auth required pam_succeed_if.so user != root quiet_success</p><p><br /></p><p>#instal kvm</p><p>apt install qemu-kvm libvirt-clients libvirt-daemon-system bridge-utils virtinst libvirt-daemon</p><p>apt install virt-manager -y</p><p><br /></p><p>virsh net-list --all</p><p><br /></p><p>#jadikan autostart</p><p>virsh net-autostart default</p><p><br /></p><p>#bridge util</p><p>apt install bridge-utils uml-utilities -y</p><p><br /></p><p>modprobe vhost_net</p><p><br /></p><p>#tambahkan vhost_net</p><p>nano /etc/modules</p><p>vhost_net</p><p><br /></p><p>#cek</p><p>lsmod | grep vhost</p><p><br /></p><p>#lihat nama network</p><p>ip a</p><p>#set bridge dg ip HOST, bukan ip TAMU</p><p>nano /etc/network/interfaces</p><p>#tambahin (bila nama networknya eno1)</p><p></p><blockquote><p>auto br0</p><p>iface br0 inet static</p><p> address 10.12.13.105/16</p><p> gateway 10.12.0.3</p><p> dns-nameservers 10.12.0.7</p><p> bridge_ports eno1</p></blockquote><p></p><div>#reboot</div><div><br /></div><div>#baru buka virt-manager utk define TAMU dg BRIDGE br0</div><div>#set ip masing2 TAMU di TAMU </div><div><br /></div>budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-42129013694432455722022-10-02T18:55:00.004-07:002022-10-02T20:49:34.758-07:00install myvestacp<p> 1.install minimal debian 11</p><p>2.ubah password root</p><p>3.ikuti=</p><p>apt install -y mc curl</p><p>curl -O http://c.myvestacp.com/vst-install-debian.sh</p><p>bash vst-install-debian.sh --apache yes --nginx yes --phpfpm no --vsftpd no --proftpd yes --named yes --mysql yes --mysql8 no --postgresql no --exim yes --dovecot yes --clamav yes --spamassassin yes --iptables yes --fail2ban yes --quota no --force no --interactive yes --port [isi-nomor-besar] --lang en</p><p>apt install postgresql postgresql-contrib</p><p>apt install openjdk-17-jdk -y</p><p>apt install lxde-core -y firefox-esr</p><div><br /></div>budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-31268089469129195992022-09-21T01:35:00.001-07:002022-09-21T01:35:01.360-07:00Backup Restore Postgresql<p>** backup **</p><p>[enter password utk postgres -- bila perlu]</p><p>root#passwd postgres</p><p>[enter password]</p><p>root#su postgres</p><p>postgres# pg_dump -W -F t idempiere > /tmp/idempiere.tar</p><p>exit</p><p><br /></p><p>** restore **</p><p>root#su postgres</p><p>postgres#psql --masuk psql</p><p>postgres# drop database idempiere</p><p>postgres# create database idempiere</p><div>postgres# exit ---dari psql</div><div><br /></div><div>postgres# pg_restore --dbname=idempiere < /tmp/idempiere.tar</div><div><br /></div><div>exit</div><div><br /></div><div>** selesai **</div>budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-90737019868138986192021-04-14T00:08:00.005-07:002021-04-19T23:36:06.853-07:00Check VPS / Test VPS<p>cek ini juga: http://note88.blogspot.com/2013/08/cara-test-vps.html </p><p> </p><p>https://github.com/masonr/yet-another-bench-script <br /></p><p>SSD LAPTOP LOKAL ASLI</p><p>Basic System Information:<br />---------------------------------<br />Processor : Intel Core Processor (Skylake, IBRS)<br />CPU cores : 2 @ 2711.998 MHz<br />AES-NI : ✔ Enabled<br />VM-x/AMD-V : ✔ Enabled<br />RAM : 1.9 GiB<br />Swap : 4.0 GiB<br />Disk : 191.9 GiB<br /><br />fio Disk Speed Tests (Mixed R/W 50/50):<br />---------------------------------<br />Block Size | 4k (IOPS) | 64k (IOPS)<br /> ------ | --- ---- | ---- ---- <br />Read | 182.77 MB/s (45.6k) | 1.35 GB/s (21.1k)<br />Write | 183.25 MB/s (45.8k) | 1.35 GB/s (21.2k)<br />Total | 366.02 MB/s (91.5k) | 2.70 GB/s (42.3k)<br /> | | <br />Block Size | 512k (IOPS) | 1m (IOPS)<br /> ------ | --- ---- | ---- ---- <br />Read | 1.14 GB/s (2.2k) | 1.38 GB/s (1.3k)<br />Write | 1.21 GB/s (2.3k) | 1.47 GB/s (1.4k)<br />Total | 2.36 GB/s (4.6k) | 2.86 GB/s (2.7k)<br /> </p><p> </p><p> </p><p> <br /></p><p>VPS SSD CACHE ....... rack (L.A)<br /></p><p>Wed Apr 14 13:59:03 WIB 2021<br /><br />Basic System Information:<br />---------------------------------<br />Processor : Intel(R) Xeon(R) CPU E5-2690 0 @ 2.90GHz<br />CPU cores : 3 @ 2899.996 MHz<br />AES-NI : ✔ Enabled<br />VM-x/AMD-V : ❌ Disabled<br />RAM : 2.3 GiB<br />Swap : 2.5 GiB<br />Disk : 38.3 GiB<br /><br />fio Disk Speed Tests (Mixed R/W 50/50):<br />---------------------------------<br />Block Size | 4k (IOPS) | 64k (IOPS)<br /> ------ | --- ---- | ---- ---- <br />Read | 3.24 MB/s (810) | 46.30 MB/s (723)<br />Write | 3.26 MB/s (816) | 46.49 MB/s (726)<br />Total | 6.50 MB/s (1.6k) | 92.80 MB/s (1.4k)<br /> | | <br />Block Size | 512k (IOPS) | 1m (IOPS)<br /> ------ | --- ---- | ---- ---- <br />Read | 115.94 MB/s (226) | 121.60 MB/s (118)<br />Write | 122.10 MB/s (238) | 129.70 MB/s (126)<br />Total | 238.04 MB/s (464) | 251.30 MB/s (244)<br /></p><p>iperf3 Network Speed Tests (IPv4):<br />---------------------------------<br />Provider | Location (Link) | Send Speed | Recv Speed <br /> | | | <br />Clouvider | London, UK (10G) | 528 Mbits/sec | 151 Mbits/sec <br />Online.net | Paris, FR (10G) | 205 Mbits/sec | busy <br />WorldStream | The Netherlands (10G) | 483 Mbits/sec | 95.9 Mbits/sec <br />Biznet | Jakarta, Indonesia (1G) | 502 Mbits/sec | 81.6 Mbits/sec <br />Clouvider | NYC, NY, US (10G) | 563 Mbits/sec | 221 Mbits/sec <br />Velocity Online | Tallahassee, FL, US (10G) | 614 Mbits/sec | 234 Mbits/sec <br />Clouvider | Los Angeles, CA, US (10G) | 681 Mbits/sec | 603 Mbits/sec </p><p>Iveloz Telecom | Sao Paulo, BR (2G) | 95.2 Mbits/sec | 71.1 Mbits/sec<br /></p><p><br /></p><p>VPS .....SING uson --- paroki (PARAHHHHHHHHHHHHH)<br /></p><p>Mon Apr 19 14:35:26 +08 2021 <br /> <br />Basic System Information: <br />--------------------------------- <br />Processor : QEMU Virtual CPU version 2.5+ <br />CPU cores : 2 @ 2397.222 MHz <br />AES-NI : ❌ Disabled <br />VM-x/AMD-V : ❌ Disabled <br />RAM : 1.9 GiB <br />Swap : 1024.0 MiB <br />Disk : 19.6 GiB <br /> <br />fio Disk Speed Tests (Mixed R/W 50/50):<br />--------------------------------- <br />Block Size | 4k (IOPS) | 64k (IOPS) <br /> ------ | --- ---- | ---- ---- <br />Read | 3.72 MB/s (930) | 3.43 MB/s (53)<br />Write | 3.75 MB/s (939) | 3.65 MB/s (57)<br />Total | 7.47 MB/s (1.8k) | 7.09 MB/s (110)<br /> | | <br />Block Size | 512k (IOPS) | 1m (IOPS)<br /> ------ | --- ---- | ---- ---- <br />Read | 9.14 MB/s (17) | 7.00 MB/s (6)<br />Write | 10.11 MB/s (19) | 7.67 MB/s (7)<br />Total | 19.26 MB/s (36) | 14.67 MB/s (13)<br /><br /></p><p>iperf3 Network Speed Tests (IPv4):<br />---------------------------------<br />Provider | Location (Link) | Send Speed | Recv Speed <br /> | | | <br />Clouvider | London, UK (10G) | 72.2 Mbits/sec | 105 Mbits/sec <br />Online.net | Paris, FR (10G) | 44.7 Mbits/sec | 83.7 Mbits/sec <br />WorldStream | The Netherlands (10G) | 71.6 Mbits/sec | 142 Mbits/sec <br />Biznet | Jakarta, Indonesia (1G) | 373 Mbits/sec | 213 Mbits/sec <br />Clouvider | NYC, NY, US (10G) | 122 Mbits/sec | 204 Mbits/sec <br />Velocity Online | Tallahassee, FL, US (10G) | 97.1 Mbits/sec | 171 Mbits/sec <br />Clouvider | Los Angeles, CA, US (10G) | 131 Mbits/sec | 198 Mbits/sec <br />Iveloz Telecom | Sao Paulo, BR (2G) | busy | busy <br /></p><p>Geekbench 5 Benchmark Test:<br />---------------------------------<br />Test | Value <br /> | <br />Single Core | 522 <br />Multi Core | 1005 <br />Full Test | https://browser.geekbench.com/v5/cpu/7491446<br /></p><p><br /></p><p><br /></p>budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com1tag:blogger.com,1999:blog-6047301590810575251.post-1261984809454914462021-04-08T19:38:00.002-07:002021-04-08T19:38:59.742-07:00hapus openlite speed cache<p></p><blockquote><p> Hapus SEMUA CACHE dan REBOOT:</p><p>rm /usr/local/lsws/cachedata -rf && reboot now </p></blockquote><p><br /></p>budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-42188479722583936912021-04-08T00:51:00.001-07:002021-04-08T00:51:59.888-07:00iptables - proteksi<p>--utk catat log yg drop <br /></p><div class="line number1 index0 alt2"><code class="bash plain">/sbin/iptables</code> <code class="bash plain">-N LOGDROP</code></div><div class="line number2 index1 alt1"><code class="bash plain">/sbin/iptables</code> <code class="bash plain">-A LOGDROP -j LOG</code></div><div class="line number3 index2 alt2"><code class="bash plain">/sbin/iptables</code> <code class="bash plain">-A LOGDROP -j DROP</code></div><div class="line number3 index2 alt2"><code class="bash plain"> </code></div><div class="line number3 index2 alt2"><code class="bash plain"> </code></div><div class="line number3 index2 alt2"><div class="line number4 index3 alt1"><code class="bash plain">iptables -I INPUT -p tcp --dport 80 -i eth0 -m state --state NEW -m recent --</code><code class="bash functions">set</code></div><code class="bash plain"></code></div><div class="line number3 index2 alt2"><code class="bash plain">iptables -I INPUT -p tcp --dport 80 -i eth0 -m state --state NEW -m recent --update --seconds 60 --hitcount 10 -j LOGDROP</code></div><div class="line number3 index2 alt2"><code class="bash plain"><br /></code></div><div class="line number3 index2 alt2"><code class="bash plain">--lihat log</code></div><div class="line number3 index2 alt2"><code class="bash plain">cat /var/log/kern.log</code></div><div class="line number3 index2 alt2"><code class="bash plain"><br /></code></div><div class="line number3 index2 alt2"><code class="bash plain">--permanent</code><br /><pre>iptables-save > /etc/iptables.up.rules</pre><code class="bash plain"></code></div><div class="line number3 index2 alt2"><pre>editor /etc/network/if-pre-up.d/iptables</pre>--tulis ini disana:</div><div class="line number3 index2 alt2"><pre>#!/bin/sh
<span class="anchor" id="line-2-4"></span> /sbin/iptables-restore < /etc/iptables.up.rules</pre><pre> </pre><pre>--chmod x</pre><pre>chmod +x /etc/network/if-pre-up.d/iptables </pre><br /><code class="bash plain"></code></div><div class="line number3 index2 alt2"><code class="bash plain"><br /></code></div>budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-87895466329953568112021-01-17T15:28:00.003-08:002021-01-17T15:39:38.056-08:00IP zoom.us<p> sumber:</p><p><a href="https://support.zoom.us/hc/en-us/articles/201362683-Network-Firewall-or-Proxy-Server-Settings-for-Zoom">https://support.zoom.us/hc/en-us/articles/201362683-Network-Firewall-or-Proxy-Server-Settings-for-Zoom</a></p><p><br /></p><p><a href="https://assets.zoom.us/docs/ipranges/Zoom.txt">https://assets.zoom.us/docs/ipranges/Zoom.txt</a></p><span><a name='more'></a></span><p><br /></p><p>--ip only:</p><p>3.7.35.0</p><p>3.21.137.128</p><p>3.22.11.0</p><p>3.23.93.0</p><p>3.25.41.128</p><p>3.25.42.0</p><p>3.25.49.0</p><p>3.80.20.128</p><p>3.96.19.0</p><p>3.101.32.128</p><p>3.101.52.0</p><p>3.104.34.128</p><p>3.120.121.0</p><p>3.127.194.128</p><p>3.208.72.0</p><p>3.211.241.0</p><p>3.235.69.0</p><p>3.235.82.0</p><p>3.235.71.128</p><p>3.235.72.128</p><p>3.235.73.0</p><p>3.235.96.0</p><p>4.34.125.128</p><p>4.35.64.128</p><p>8.5.128.0</p><p>13.52.6.128</p><p>13.52.146.0</p><p>18.157.88.0</p><p>18.205.93.128</p><p>50.239.202.0</p><p>50.239.204.0</p><p>52.61.100.128</p><p>52.81.151.128</p><p>52.81.215.0</p><p>52.202.62.192</p><p>52.215.168.0</p><p>64.125.62.0</p><p>64.211.144.0</p><p>65.39.152.0</p><p>69.174.57.0</p><p>69.174.108.0</p><p>99.79.20.0</p><p>101.36.167.0</p><p>103.122.166.0</p><p>109.94.160.0</p><p>111.33.115.0</p><p>111.33.181.0</p><p>115.110.154.192</p><p>115.114.56.192</p><p>115.114.115.0</p><p>115.114.131.0</p><p>120.29.148.0</p><p>129.151.0.0</p><p>129.159.0.0</p><p>130.61.164.0</p><p>134.224.0.0</p><p>140.238.128.0</p><p>140.238.232.0</p><p>144.195.0.0</p><p>147.124.96.0</p><p>149.137.0.0</p><p>152.67.20.0</p><p>152.67.118.0</p><p>152.67.168.0</p><p>152.67.180.0</p><p>152.67.184.0</p><p>152.67.240.0</p><p>158.101.64.0</p><p>160.1.56.128</p><p>161.189.199.0</p><p>161.199.136.0</p><p>162.12.232.0</p><p>162.255.36.0</p><p>165.254.88.0</p><p>168.138.16.0</p><p>168.138.48.0</p><p>168.138.56.0</p><p>168.138.72.0</p><p>168.138.74.0</p><p>168.138.96.0</p><p>168.138.116.0</p><p>168.138.244.0</p><p>170.114.0.0</p><p>173.231.80.0</p><p>192.204.12.0</p><p>193.122.32.0</p><p>193.122.36.0</p><p> 193.122.208.0</p><p>193.122.224.0</p><p>193.122.240.0</p><p>193.123.0.0</p><p>193.123.40.0</p><p>193.123.44.0</p><p>193.123.128.0</p><p>193.123.168.0</p><p>193.123.192.0</p><p>198.251.128.0</p><p>202.177.207.128</p><p>204.80.104.0</p><p>204.141.28.0</p><p>207.226.132.0</p><p>209.9.211.0</p><p>209.9.215.0</p><p>213.19.144.0</p><p>213.19.153.0</p><p>213.244.140.0</p><p>221.122.88.64</p><p>221.122.88.128</p><p>221.122.89.128</p><p>221.123.139.192</p><p><br /></p><p>-- atau:</p><p>3.7.35.0/25<br />3.21.137.128/25<br />3.22.11.0/24<br />3.23.93.0/24<br />3.25.41.128/25<br />3.25.42.0/25<br /><span class="s1">3.25.49.0/24<br /></span>3.80.20.128/25<br />3.96.19.0/24<br />3.101.32.128/25<br />3.101.52.0/25<br />3.104.34.128/25<br />3.120.121.0/25<br />3.127.194.128/25<br />3.208.72.0/25<br />3.211.241.0/25<br />3.235.69.0/25<br />3.235.82.0/23<br />3.235.71.128/25<br />3.235.72.128/25<br />3.235.73.0/25<br />3.235.96.0/23<br />4.34.125.128/25<br />4.35.64.128/25<br />8.5.128.0/23<br />13.52.6.128/25<br />13.52.146.0/25<br />18.157.88.0/24<br />18.205.93.128/25<br />50.239.202.0/23<br />50.239.204.0/24<br />52.61.100.128/25<br />52.81.151.128/25<br />52.81.215.0/24<br />52.202.62.192/26<br />52.215.168.0/25<br />64.125.62.0/24<br />64.211.144.0/24<br />65.39.152.0/24<br />69.174.57.0/24<br />69.174.108.0/22<br />99.79.20.0/25<br />101.36.167.0/24<br />103.122.166.0/23<br />109.94.160.0/22<br />111.33.115.0/25<br />111.33.181.0/25<br />115.110.154.192/26<strong> </strong><br />115.114.56.192/26<br />115.114.115.0/26 <br />115.114.131.0/26<br />120.29.148.0/24<br />129.151.0.0/20<br />129.159.0.0/20<br />130.61.164.0/22<br />134.224.0.0/16<br />140.238.128.0/24<br />140.238.232.0/22<br />144.195.0.0/16<br />147.124.96.0/19<br />149.137.0.0/17<br />152.67.20.0/24<br />152.67.118.0/24<br />152.67.168.0/22<br />152.67.180.0/24<br />152.67.184.0/22<br />152.67.240.0/21<br />158.101.64.0/24<br />160.1.56.128/25<br />161.189.199.0/25<br />161.199.136.0/22<br />162.12.232.0/22<br />162.255.36.0/22<br />165.254.88.0/23<br />168.138.16.0/22<br />168.138.48.0/24<br />168.138.56.0/21<br />168.138.72.0/24<br />168.138.74.0/25<br />168.138.96.0/22<br />168.138.116.0/22<br />168.138.244.0/24<br />170.114.0.0/16<br />173.231.80.0/20<br />192.204.12.0/22<br />193.122.32.0/22<br />193.122.36.0/22<br /> 193.122.208.0/20<br />193.122.224.0/20<br />193.122.240.0/20<br />193.123.0.0/19<br />193.123.40.0/22<br />193.123.44.0/22<br />193.123.128.0/19<br />193.123.168.0/21<br />193.123.192.0/19<br />198.251.128.0/17<br />202.177.207.128/27<br />204.80.104.0/21<br />204.141.28.0/22<br />207.226.132.0/24<br />209.9.211.0/24<br />209.9.215.0/24<br />213.19.144.0/24<br />213.19.153.0/24<br />213.244.140.0/24<br />221.122.88.64/27<br />221.122.88.128/25<br />221.122.89.128/25<br />221.123.139.192/27</p>budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com1tag:blogger.com,1999:blog-6047301590810575251.post-53900850398695247982020-12-15T16:34:00.006-08:002020-12-15T16:34:40.182-08:00Merubah directory dalam script<p> # tambahan </p><p>OLDPWD=$(pwd)</p><p>cd /opt/[direktory]</p><p>function atexit() { cd "$OLDPWD"; }</p><p>trap atexit EXIT # go back to where we came from, however we exit</p><p># end of tambahan </p><div><br /></div>budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-88874576960128563192020-12-09T00:31:00.001-08:002020-12-09T00:31:10.844-08:00All Oracle Constraint<p></p><blockquote><p> select c1.owner, c1.table_name, c1.constraint_name, c2.owner, c2.table_name, c2.column_name</p><p>from dba_constraints c1</p><p>JOIN dba_cons_columns c2</p><p>ON c1.R_CONSTRAINT_NAME=C2.CONSTRAINT_NAME and c1.r_owner=c2.owner</p><p>where C1.constraint_type = 'R' and c2.table_name='C_BPARTNER'</p><p>order by c1.owner, c1.table_name, c1.constraint_name, c2.position</p><p></p></blockquote><p><br /></p>budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-26094860699024614352020-11-30T19:29:00.004-08:002020-11-30T19:32:31.507-08:00idem81 on centos 8<p> perlu :</p><p>1.disable firewalld</p><p>2.set di .bash_profile</p><p>##tambahan</p><p>ORACLE_SID=XE</p><p>export ORACLE_SID</p><p>export ORAENV_ASK=NO</p><p>. oraenv</p><div><br /></div><div><br /></div><div>3.install fontconfig</div><div><br /></div><div><pre>yum install fontconfig</pre><pre><br /></pre><pre>4.buat service idem</pre><pre><br /></pre></div><p><br /></p>budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-64862488258786835542020-11-26T19:47:00.001-08:002020-11-26T19:47:46.603-08:00Install Oracle 18c XE on Centos 8<p> 1.install centos 8 minimal</p><p>2.install wget, mc</p><p>yum install -y gcc-c++ make</p><p>yum install -y ksh</p><p>yum install -y sysstat</p><p>yum install -y xorg-x11-utils</p><p>yum install java-11-openjdk-devel</p><p>yum install -y libnsl</p><p>rpm -ivh libaio-devel-0.3.110-12.el8.x86_64.rpm</p><p>rpm -ivh compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm</p><p>rpm -ivh compat-libcap1-1.10-7.el7.x86_64.rpm</p><p></p><p>Then install the Oracle files.</p><p></p><p>rpm -ivh oracle-database-preinstall-18c-1.0-1.el7.x86_64</p><p>rpm -ivh oracle-database-xe-18c-1.0-1.x86_64.rpm</p><p><br /></p><p>cari rpm di rpmfiles</p>budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-11272075695185742392020-11-10T22:13:00.001-08:002020-11-10T22:13:09.932-08:00Edit file di dalam image docker (inside docker image)<p> #add di eof</p><p>cat >>/opt/oracle/product/18c/dbhomeXE/network/admin/tnsnames.ora<<EOF<br />>ketik sembarang<br /></p><p>>EOF</p><p><br /></p><p>#kalau dilihat, cat [namafile]</p><p>ketik sembarang </p><p>#ada dibawah</p><p><br /></p><p>#utk search and replace</p><p>gunakan sed<br /></p>budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-74113349070559692872020-11-10T18:11:00.000-08:002020-11-10T18:11:00.700-08:00Install docker dan docker-compose#update<div class="code-toolbar"><pre class="code-pre command prefixed language-bash"><code class="code-highlight language-bash"><span class="token function"></span><ul class="prefixed"><span class="token function"></span><li class="line" data-prefix="$"><span class="token function">sudo</span> <span class="token function">apt</span> update
</li></ul></code></pre></div>
<p>#install a few prerequisite</p>
<div class="code-toolbar"><pre class="code-pre command prefixed language-bash"><code class="code-highlight language-bash"><span class="token function"></span><ul class="prefixed"><span class="token function"></span><li class="line" data-prefix="$"><span class="token function">sudo</span> <span class="token function">apt</span> <span class="token function">install</span> apt-transport-https ca-certificates <span class="token function">curl</span> software-properties-common
</li></ul></code></pre></div>
<p></p>
<div class="code-toolbar"><pre class="code-pre command prefixed language-bash"><code class="code-highlight language-bash"><span class="token function"></span><ul class="prefixed"><span class="token function"></span><li class="line" data-prefix="$"><span class="token function">curl</span> -fsSL https://download.docker.com/linux/ubuntu/gpg <span class="token operator">|</span> <span class="token function">sudo</span> apt-key <span class="token function">add</span> -
</li></ul></code></pre></div>
<p>#Add the Docker repository to APT sources:</p>
<div class="code-toolbar"><pre class="code-pre command prefixed language-bash"><code class="code-highlight language-bash"><span class="token function"></span><ul class="prefixed"><span class="token function"></span><li class="line" data-prefix="$"><span class="token function">sudo</span> add-apt-repository <span class="token string">"deb [arch=amd64] https://download.docker.com/linux/ubuntu <span class="highlight">bionic</span> stable"</span>
</li></ul></code></pre></div>
<p>#update</p>
<div class="code-toolbar"><pre class="code-pre command prefixed language-bash"><code class="code-highlight language-bash"><span class="token function"></span><ul class="prefixed"><span class="token function"></span><li class="line" data-prefix="$"><span class="token function">sudo</span> <span class="token function">apt</span> update
</li></ul></code></pre></div>
<p>#cek<br /></p>
<div class="code-toolbar"><pre class="code-pre command prefixed language-bash"><code class="code-highlight language-bash"><span class="token function"></span><ul class="prefixed"><span class="token function"></span><li class="line" data-prefix="$"><span class="token function">apt-cache</span> policy docker-ce
</li></ul></code></pre></div>
<p>You’ll see output like this, although the version number for Docker may be different:</p>
<div class="code-label " title="Output of apt-cache policy docker-ce">Output of apt-cache policy docker-ce</div><div class="code-toolbar"><pre class="code-pre language-bash"><code class="code-highlight language-bash">docker-ce:
Installed: <span class="token punctuation">(</span>none<span class="token punctuation">)</span>
Candidate: <span class="token number"></span><span class="highlight"><span class="token number">18.03</span>.1~ce~3-0~ubuntu</span>
Version table:
<span class="token number"></span><span class="highlight"><span class="token number">18.03</span>.1~ce~3-0~ubuntu</span> <span class="token number">500</span>
<span class="token number">500</span> https://download.docker.com/linux/ubuntu bionic/stable amd64 Packages</code></pre></div>
<p>Notice that <code>docker-ce</code> is not installed, but the candidate for installation is from the Docker repository for Ubuntu 18.04 (<code>bionic</code>). </p>
<p>#Finally, install Docker:</p>
<div class="code-toolbar"><pre class="code-pre command prefixed language-bash"><code class="code-highlight language-bash"><span class="token function"></span><ul class="prefixed"><span class="token function"></span><li class="line" data-prefix="$"><span class="token function">sudo</span> <span class="token function">apt</span> <span class="token function">install</span> docker-ce
</li></ul></code></pre></div>
<p>Docker should now be installed, the daemon started, and the process enabled to start on boot. Check that it’s running:</p>
<pre class="code-pre command prefixed language-bash"><code class="code-highlight language-bash"><span class="token function"></span><ul class="prefixed"><span class="token function"></span><li class="line" data-prefix="$"><span class="token function">sudo</span> systemctl status docker </li></ul><p> </p><p> </p><p> </p><p> </p><p>-----------install docker-compose</p><p> </p><p>#cek version:</p><p>https://github.com/docker/compose/releases</p><p> </p></code></pre><p>#ubah sesuai versi<br /></p>
<div class="code-toolbar"><pre class="code-pre command prefixed language-bash"><code class="code-highlight language-bash"><span class="token function"></span><ul class="prefixed"><span class="token function"></span><li class="line" data-prefix="$"><span class="token function">sudo</span> <span class="token function">curl</span> -L https://github.com/docker/compose/releases/download/[versi]<span class="highlight"></span>/docker-compose-<span class="token variable"><span class="token variable">`</span><span class="token function">uname</span> -s<span class="token variable">`</span></span>-<span class="token variable"><span class="token variable">`</span><span class="token function">uname</span> -m<span class="token variable">`</span></span> -o /usr/local/bin/docker-compose
</li></ul></code></pre></div>
<p>#set</p>
<div class="code-toolbar"><pre class="code-pre command prefixed language-bash"><code class="code-highlight language-bash"><span class="token function"></span><ul class="prefixed"><span class="token function"></span><li class="line" data-prefix="$"><span class="token function">sudo</span> <span class="token function">chmod</span> +x /usr/local/bin/docker-compose
</li></ul></code></pre></div>
<p>#verify</p>
<div class="code-toolbar"><pre class="code-pre command prefixed language-bash"><code class="code-highlight language-bash"><ul class="prefixed"><li class="line" data-prefix="$">docker-compose --version
</li></ul></code></pre></div>
<p></p>
<pre class="code-pre "><code><div class="secondary-code-label " title="Output">Output</div>docker-compose version <span class="highlight">[versi]</span>, build [xxxxx]
</code></pre><pre class="code-pre command prefixed language-bash"><code class="code-highlight language-bash"><p> </p></code></pre>budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-50601201688578160282020-11-09T02:12:00.007-08:002020-11-09T02:31:15.616-08:00Docker save and load backup (bukan export import)<p>#utk cek running/tidak <br /></p><p>docker ps </p><p>#utk lihat image</p><p>docker images</p><p>#utk save</p><p>docker save [nama image] > [namafile.tar]</p><p>#utk load backup</p><p>docker load < [namafile.tar]</p><p>#utk masuk ke image</p><p>docker exec -it [namaimage] bash</p><p>#utk keluar</p><p>exit</p><p><br /></p><p>#utk run oracle:</p><pre>docker run --name myxedb \
-d \
-p 51521:1521 \
-p 55500:5500 \
-e ORACLE_PWD=mysecurepassword \
-e ORACLE_CHARACTERSET=AL32UTF8 \
oracle/database:18.4.0-xe</pre><pre> </pre><p>#utk stop oracle<br /></p><pre>docker stop myxedb<br /></pre><pre> </pre><pre> </pre><p>#utk remove<br /></p><pre>docker rm [namaimage]</pre><pre><br /></pre><p>#utk remove image<br /></p>docker rmi [namaimage]<br /><pre> </pre>budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-86182814357290077602020-07-09T00:24:00.003-07:002020-07-09T00:25:12.221-07:00iptables block range ip# cat /etc/iptables/rules.v4<br />
----------------------------------------------<br />
# Generated by xtables-save v1.8.2 on Thu Jul 9 02:55:34 2020<br />
*filter<br />
:INPUT ACCEPT [755:72126]<br />
:FORWARD ACCEPT [0:0]<br />
:OUTPUT ACCEPT [1164:142504]<br />
-A INPUT -f -j DROP<br />
-A INPUT -p tcp -m tcp --tcp-flags FIN,SYN,RST,PSH,ACK,URG NONE -j DROP<br />
-A INPUT -p tcp -m tcp ! --tcp-flags FIN,SYN,RST,ACK SYN -m state --state NEW -j DROP<br />
-A INPUT -p tcp -m tcp --tcp-flags FIN,SYN,RST,PSH,ACK,URG FIN,SYN,RST,PSH,ACK,URG -j DROP<br />
-A INPUT -i lo -j ACCEPT<br />
-A INPUT -p tcp -m tcp --dport 39000 -j ACCEPT<br />
-A INPUT -s 185.0.0.0/8 -j DROP<br />
-A INPUT -s 46.0.0.0/8 -j DROP<br />
COMMIT<br />
# Completed on Thu Jul 9 02:55:34 2020<br />
<br />budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-30900138540303341942020-05-11T00:26:00.004-07:002020-05-11T00:26:49.035-07:00install debian 10 busterinstall from CD<br />
kosongi semua software, kecuali server ssh, minimal terakhir<br />
mirror pilih mirror.0x.sg<br />
<br />
<br />
<blockquote class="tr_bq">
root@localhost:/etc/apt# cat sources.list<br /># <br /><br /># deb cdrom:[Debian GNU/Linux 10.2.0 _Buster_ - Official amd64 NETINST 20191116-09:56]/ buster main<br /><br />#deb cdrom:[Debian GNU/Linux 10.2.0 _Buster_ - Official amd64 NETINST 20191116-09:56]/ buster main<br /><br /><br />deb http://mirror.0x.sg/debian/ buster main<br />deb-src http://mirror.0x.sg/debian/ buster main<br /><br />deb http://security.debian.org/debian-security buster/updates main contrib<br />deb-src http://security.debian.org/debian-security buster/updates main contrib<br /><br /># buster-updates, previously known as 'volatile'<br />deb http://mirror.0x.sg/debian/ buster-updates main contrib<br />deb-src http://mirror.0x.sg/debian/ buster-updates main contrib</blockquote>
<br />
apt-get update -y<br />
[apt-get install postgres, openjdk, mc, ntp, net-utils]<br />
apt-get install nginx, php, php-fpm<br />
<br />
install swoole:<br />
apt-get install php-dev<br />
<br />
<br />
<br />
<br />
<br />
<br />budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-2042972854396441042020-05-09T02:49:00.004-07:002020-05-09T02:49:57.090-07:00customlatihan mencoba custom<br />
<br />
<a name='more'></a><br /><br />
<br />
<blockquote class="tr_bq">
INSERT INTO ad_userquery (ad_userquery_id,ad_client_id,ad_org_id,isactive,created,createdby,updated,updatedby,"name",description,ad_user_id,ad_table_id,code,ad_tab_id,ad_userquery_uu,ad_window_id,ad_role_id) VALUES<br />(1000000,0,0,'Y','2020-01-23 10:22:59.171',0,'2020-01-23 10:25:53.865',0,'Windowku',NULL,afei,105,'AD_Window_ID<^>>=<^>1000000<^><^><^><^>',105,'4b3c0fb1-5063-457e-a9f8-2a87a513c82c',102,NULL)<br />,(1000001,0,0,'Y','2020-01-23 11:15:08.949',0,'2020-01-23 11:15:08.949',0,'Tableku',NULL,afei,100,'AD_Table_ID<^>>=<^>1000000<^><^><^><^>',100,'756e0ba6-8787-40d4-ae14-2907b8bcce23',100,NULL)<br />,(1000002,0,0,'Y','2020-05-09 16:36:19.441',0,'2020-05-09 16:36:19.441',0,'Win Trx Active',NULL,afei,105,'WindowType<^>=<^>T<^><^><^><^><~>IsBetaFunctionality<^>=<^>N<^><^>AND<^><^><~>AD_Window_ID<^><<^>1000000<^><^>AND<^><^><~>IsActive<^>=<^>Y<^><^>AND<^><^>',105,'9aa905be-a3d2-4b01-858b-d12da64d6071',102,NULL)<br />;</blockquote>
<br />
<br />
<blockquote class="tr_bq">
<br /> INSERT INTO ad_tab_customization (ad_client_id,ad_org_id,ad_tab_customization_id,ad_tab_id,ad_user_id,created,createdby,custom,isactive,updated,updatedby,ad_tab_customization_uu,isdisplayedgrid) VALUES<br />(0,0,100014,105,afei,'2020-05-09 16:16:41.715',0,'114,115,116,268,10569,267,5379,202516,4942,4943,5124,8194,10397,10396;141px,209px,300px,43px,47px,92px,82px,107px,160px,160px,160px,48px,120px,120px','Y','2020-05-09 16:17:12.008',0,'daefecec-13dc-4d76-aede-6c83e9768138',NULL)<br />,(0,0,100000,100,afei,'2020-01-09 09:40:51.445',0,'149,143,144,145,246,4874,249,6554,7530,147,7531,253,3207,5125,58844,202252;140px,183px,79px,97px,43px,34px,160px,128px,101px,160px,160px,110px,79px,160px,125px,121px','Y','2020-01-09 09:40:51.445',0,'5ce31d37-bf5e-45d5-b3e6-d338e5dd4623',NULL)<br />,(0,0,100008,246,afei,'2020-01-28 11:09:40.539',0,'2537,2546,2541,2542,205338,2543,5817,4576,2547,3110,5818,2539,2540,2907,2901,200097,2903,2904,2544,2902,4398,2906,2905,56333,56334,204372,205339;160px,144px,76px,100px,79px,43px,96px,125px,63px,128px,160px,160px,160px,160px,160px,66px,120px,68px,44px,208px,208px,160px,160px,300px,300px,136px,300px','Y','2020-01-28 11:09:40.539',0,'c4a42766-3ea2-4ed1-a28f-3404fba27185',NULL)<br />,(0,0,100009,101,afei,'2020-01-31 13:09:26.817',0,'157,156,152,170,171,172,160,825,205342,250,2370,155,158,310,56279,11264,1345,56374,50188,4941,166,2526,200648,2574,2573,161,10128,162,168,159,4940,204220,167,5121,56317,62467,202518,202519,5122,200288,202257,205668,59619;100px,124px,127px,87px,101px,160px,97px,60px,85px,43px,65px,57px,53px,88px,87px,90px,104px,94px,108px,101px,68px,58px,69px,66px,77px,75px,110px,114px,58px,71px,108px,122px,67px,77px,90px,72px,112px,109px,161px,168px,94px,40px,160px','Y','2020-04-23 07:37:24.731',0,'76cb5b38-d41c-4c5d-866b-d39a646f6c49',NULL)<br />,(0,0,100004,106,afei,'2020-01-23 10:19:42.744',0,'119,120,271,131,123,5326,1550,1549,11265,11266,124,929,11998,2575,927,5709,1546,57266,5707,11997,312,928,5708,1548,4956,201811,202515,5131,206373,5824,121,122;85px,106px,43px,160px,34px,37px,79px,83px,73px,56px,71px,66px,58px,68px,50px,66px,107px,59px,63px,46px,57px,91px,61px,81px,51px,81px,62px,122px,120px,72px,81px,98px','Y','2020-04-23 07:56:32.524',0,'400ce2ef-f7f3-48aa-81d8-f128cbd2cd07',NULL)<br />,(0,0,100001,107,afei,'2020-01-09 09:46:44.111',0,'126,127,130,274,4259,132,200276,924,133,13425,54402,54401,13424,136,142,137,200274,139,202362,138,8343,140,141,202341,5808,205345,62468,200771,53280,200837,200350,200348,200838,200834,200349,200835,200836,204213,203500,204214,128,129,1551;61px,141px,160px,43px,47px,64px,81px,66px,91px,61px,35px,37px,37px,93px,66px,35px,43px,67px,96px,95px,56px,82px,65px,86px,49px,83px,64px,74px,69px,51px,37px,50px,41px,73px,102px,76px,74px,68px,57px,48px,73px,103px,62px','Y','2020-04-23 08:05:35.548',0,'0856affb-b4f5-4d63-88a2-c4aa621b40d3',NULL)<br />,(0,0,100012,50006,afei,'2020-04-28 11:19:57.523',0,'50091,50095,50096,50097,50103,50111,50182,50104,50105,50098,50099,50100,50101,50102,50106,50107,50108,50109,50110,50112,50113,50114,50115,50183,50187,50116,50117,53284,57418,205861;93px,51px,160px,75px,72px,75px,121px,56px,108px,65px,129px,102px,134px,140px,114px,121px,42px,54px,64px,72px,160px,87px,89px,59px,78px,70px,52px,72px,105px,160px','Y','2020-04-28 11:24:11.903',0,'7f8900bb-e879-482b-93d8-ca4c491d7e7f',NULL)<br />;</blockquote>
<div>
<br /></div>
budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-69812277683539324392020-04-12T20:08:00.002-07:002020-04-12T20:08:50.250-07:00split manualpertama=<br />
dd if=debian-10.3.0-amd64-DVD-1.iso of=debian-10.3.0-amd64-DVD-1.iso.001 bs=1024 count=409600<br />
<br />
<br />
kedua pakai skip=<br />
dd if=debian-10.3.0-amd64-DVD-1.iso of=debian-10.3.0-amd64-DVD-1.iso.002 bs=1024 count=409600 skip=409600<br />
<br />
ketiga pakai skip*2=<br />
dd if=debian-10.3.0-amd64-DVD-1.iso of=debian-10.3.0-amd64-DVD-1.iso.003 bs=1024 count=409600 skip=819200<br />
<br />
<br />
gabungkan=<br />
<pre class="bbcodeblock" dir="ltr" style="border: 1px inset; height: 98px; margin-right: -99999px; margin: 0px; overflow: auto; padding: 3px; text-align: left; width: 98%;">dd if=part1 of=new_file bs=1024 count=3145728
dd if=part2 of=new_file bs=1024 count=3145728 seek=3145728
dd if=part3 of=new_file bs=1024 count=3145728 seek=6291456</pre>
<pre class="bbcodeblock" dir="ltr" style="border: 1px inset; height: 98px; margin-right: -99999px; margin: 0px; overflow: auto; padding: 3px; text-align: left; width: 98%;"> </pre>
budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-61057426806176612822019-12-30T20:24:00.000-08:002019-12-30T20:26:51.470-08:00idempiere Callout Factory and Callout<blockquote class="tr_bq">
public class MyCalloutFactory implements IColumnCalloutFactory{<br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>@Override<br />
<span style="white-space: pre;"> </span>public IColumnCallout[] getColumnCallouts(String tableName, String columnName) {<br />
<span style="white-space: pre;"> </span>// TODO Auto-generated method stub<br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>List<icolumncallout> list = new ArrayList<icolumncallout>();</icolumncallout></icolumncallout><br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>System.out.println("Kolom:"+tableName+"."+columnName);<br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>if(tableName.equalsIgnoreCase("C_ORDER") && columnName.equalsIgnoreCase("DESCRIPTION"))<br />
<span style="white-space: pre;"> </span>list.add(new MyCallout());<br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>if(tableName.equalsIgnoreCase("C_ORDER") && columnName.equalsIgnoreCase("AD_ORG_ID"))<br />
<span style="white-space: pre;"> </span>list.add(new MyCallout());<br />
<span style="white-space: pre;"> </span><br />
<span style="white-space: pre;"> </span>return list!=null ? list.toArray(new IColumnCallout[0]) : new IColumnCallout[0];<br />
<span style="white-space: pre;"> </span>}<br />
<br />
<br />
}<br />
<div>
<br /></div>
</blockquote>
Setiap masuk window, maka fungsi diatas dipanggil sebanyak kolom, untuk assign.<br />
<br />
<br />
<blockquote class="tr_bq">
public class MyCallout implements IColumnCallout{<br /><span style="white-space: pre;"> </span><span style="white-space: pre;"> </span>CLogger log = CLogger.getCLogger(MyCallout.class);<br /><span style="white-space: pre;"> </span>@Override<br /><span style="white-space: pre;"> </span>public String start(Properties ctx, int WindowNo, GridTab mTab, GridField mField, Object value, Object oldValue) {<br /><span style="white-space: pre;"> </span>// TODO Auto-generated method stub<br /><span style="white-space: pre;"> </span><span style="white-space: pre;"> </span>log.warning("* dari sini *");<br /><span style="white-space: pre;"> </span>log.warning("ColumnName: "+mField.getColumnName());<br /><span style="white-space: pre;"> </span>if (value != null)<br /><span style="white-space: pre;"> </span>log.warning("NewValue: "+value.toString());<br /><span style="white-space: pre;"> </span>if (oldValue != null)<br /><span style="white-space: pre;"> </span>log.warning("Oldvalue: "+oldValue.toString());<br /><span style="white-space: pre;"> </span>mTab.setValue("DocumentNo", "Test");<br /><span style="white-space: pre;"> </span><span style="white-space: pre;"> </span>return null;<br /><span style="white-space: pre;"> </span>}<br />}</blockquote>
<div>
Ini dipanggil HANYA oleh kolom yang di-assign</div>
<div>
<br /></div>
<div>
<br /></div>
<br />
<div>
<br /></div>
budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-53465482951209412882019-09-21T20:27:00.002-07:002019-09-21T20:35:06.600-07:00Oracle Client 18xe on Ubuntu 18 - 64bit1.download and install ALL 3 THIS:<br />
oracle-instantclient19.3-basic-19.3.0.0.0-1.x86_64.rpm<br />
oracle-instantclient19.3-sqlplus-19.3.0.0.0-1.x86_64.rpm<br />
oracle-instantclient19.3-devel-19.3.0.0.0-1.x86_64.rpm<br />
<br />
2.quick test:<br />
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash functions">export</code> <code class="bash plain">LD_LIBRARY_PATH=</code><code class="bash plain">/usr/lib/oracle/19</code><code class="bash plain">.3</code><code class="bash plain">/client64/lib</code></div>
<div class="line number2 index1 alt1">
<code class="bash plain">sqlplus System/manager</code><code class="bash plain">@192.168.122.205:1521/XE</code></div>
<div class="line number2 index1 alt1">
<code class="bash plain"><br /></code></div>
<div class="line number2 index1 alt1">
<code class="bash plain">3.add these lines (~/.bash_profile, ~/.profile, ~/.bashrc)</code></div>
<div class="line number2 index1 alt1">
<code class="bash plain">export LD_LIBRARY_PATH=/usr/lib/oracle/19.3/client64/lib</code></div>
<div class="line number2 index1 alt1">
<code class="bash plain"></code><br />
<div class="line number2 index1 alt1">
<code class="bash plain">export ORACLE_HOME=/usr/lib/oracle/19.3/client64</code></div>
<code class="bash plain">
<div class="line number2 index1 alt1">
export PATH=$PATH:$ORACLE_HOME/bin</div>
<div class="line number2 index1 alt1">
<code class="plain plain">export TNS_ADMIN=/usr/lib/oracle/19.3/client64/network/admin</code><br />
<code class="plain plain"><br /></code>
<code class="plain plain">[/etc/profile.d/oracle.sh]</code><br />
<div class="line number2 index1 alt1">
<code class="bash plain">export ORACLE_HOME=/usr/lib/oracle/19.3/client64</code></div>
<code class="plain plain"></code><br />
<div class="line number2 index1 alt1">
</div>
<br />
<div class="line number2 index1 alt1" style="-webkit-text-stroke-width: 0px; color: black; font-family: monospace; font-size: medium; font-style: normal; font-variant-caps: normal; font-variant-ligatures: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-decoration-color: initial; text-decoration-style: initial; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<div style="margin: 0px;">
export PATH=$PATH:$ORACLE_HOME/bin</div>
</div>
</div>
<div class="line number2 index1 alt1">
<code class="plain plain"><br /></code></div>
<div class="line number2 index1 alt1">
4.setup tnsnames.ora and sqlnet.ora</div>
<div class="line number2 index1 alt1">
<div class="container">
<div class="line number1 index0 alt2">
<code class="plain plain">cd /usr/lib/oracle/19.3/client64</code></div>
<div class="line number2 index1 alt1">
<code class="plain plain">sudo mkdir network</code></div>
<div class="line number3 index2 alt2">
<code class="plain plain">cd network</code></div>
<div class="line number4 index3 alt1">
<code class="plain plain">sudo mkdir admin</code></div>
<div class="line number5 index4 alt2">
<code class="plain plain">cd admin</code></div>
<div class="line number5 index4 alt2">
<code class="plain plain"><br /></code></div>
<div class="line number5 index4 alt2">
<code class="plain plain">[tnsnames.ora]</code></div>
<div class="line number5 index4 alt2">
<code class="plain plain"></code><br />
<div class="line number5 index4 alt2">
<code class="plain plain">XE =</code></div>
<code class="plain plain">
<div class="line number5 index4 alt2">
(DESCRIPTION =</div>
<div class="line number5 index4 alt2">
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.122.205)(PORT = 1521))</div>
<div class="line number5 index4 alt2">
(CONNECT_DATA =</div>
<div class="line number5 index4 alt2">
(SERVER = DEDICATED)</div>
<div class="line number5 index4 alt2">
(SERVICE_NAME = XE)</div>
<div class="line number5 index4 alt2">
)</div>
<div class="line number5 index4 alt2">
)</div>
<div class="line number5 index4 alt2">
<br /></div>
<div class="line number5 index4 alt2">
[sqlnet.ora]</div>
<div class="line number5 index4 alt2">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">SQLNET.AUTHENTICATION_SERVICES=(NTS)</code></div>
<div class="line number3 index2 alt2">
<code class="bash plain">NAMES.DIRECTORY_PATH=(LDAP,TNSNAMES,ONAMES,HOSTNAME)</code> </div>
<div class="line number5 index4 alt2">
<code class="bash plain">DEFAULT_SDU_SIZE=8761</code></div>
<div class="line number5 index4 alt2">
<code class="bash plain"><br /></code></div>
<div class="line number5 index4 alt2">
<code class="bash plain">sudo chmod a+w *.ora</code></div>
<div class="line number5 index4 alt2">
<code class="bash plain"><br /></code></div>
<div class="line number5 index4 alt2">
<code class="bash plain">5.reboot, run:</code></div>
<div class="line number5 index4 alt2">
<code class="bash plain">sqlplus </code><code class="bash plain">System/manager</code><code class="bash plain">@192.168.122.205:1521/XE</code></div>
<div class="line number5 index4 alt2">
<code class="bash plain"><br /></code></div>
<div class="line number5 index4 alt2">
<code class="bash plain">6.done</code></div>
</div>
</div>
</code></div>
</div>
</div>
</code></div>
</div>
budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-53173569297201157982019-09-01T22:45:00.004-07:002019-09-01T22:45:54.670-07:00idempiere total-record<blockquote class="tr_bq">
drop materialized view z_afei_total_record_03;</blockquote>
<br />
<a name='more'></a><br />
<blockquote class="tr_bq">
<br />create materialized view z_afei_total_record_03 as<br />select 'a_asset_delivery' as namatable, (select count(*) from a_asset_delivery) as jumlah<br />union all select 'a_asset_group_acct' as namatable, (select count(*) from a_asset_group_acct) as jumlah<br />union all select 'a_asset_acct' as namatable, (select count(*) from a_asset_acct) as jumlah<br />union all select 'a_asset' as namatable, (select count(*) from a_asset) as jumlah<br />union all select 'a_asset_group_trl' as namatable, (select count(*) from a_asset_group_trl) as jumlah<br />union all select 'a_asset_class' as namatable, (select count(*) from a_asset_class) as jumlah<br />union all select 'a_asset_group' as namatable, (select count(*) from a_asset_group) as jumlah<br />union all select 'a_asset_disposed' as namatable, (select count(*) from a_asset_disposed) as jumlah<br />union all select 'a_asset_info_fin' as namatable, (select count(*) from a_asset_info_fin) as jumlah<br />union all select 'a_asset_change_amt' as namatable, (select count(*) from a_asset_change_amt) as jumlah<br />union all select 'a_asset_info_ins' as namatable, (select count(*) from a_asset_info_ins) as jumlah<br />union all select 'a_asset_addition' as namatable, (select count(*) from a_asset_addition) as jumlah<br />union all select 'a_asset_change' as namatable, (select count(*) from a_asset_change) as jumlah<br />union all select 'a_asset_info_oth' as namatable, (select count(*) from a_asset_info_oth) as jumlah<br />union all select 'a_asset_info_tax' as namatable, (select count(*) from a_asset_info_tax) as jumlah<br />union all select 'a_asset_info_lic' as namatable, (select count(*) from a_asset_info_lic) as jumlah<br />union all select 'a_asset_retirement' as namatable, (select count(*) from a_asset_retirement) as jumlah<br />union all select 'a_asset_product' as namatable, (select count(*) from a_asset_product) as jumlah<br />union all select 'a_asset_split' as namatable, (select count(*) from a_asset_split) as jumlah<br />union all select 'a_asset_reval_index' as namatable, (select count(*) from a_asset_reval_index) as jumlah<br />union all select 'a_asset_type' as namatable, (select count(*) from a_asset_type) as jumlah<br />union all select 'a_asset_reval' as namatable, (select count(*) from a_asset_reval) as jumlah<br />union all select 'a_asset_reval_entry' as namatable, (select count(*) from a_asset_reval_entry) as jumlah<br />union all select 'a_asset_transfer' as namatable, (select count(*) from a_asset_transfer) as jumlah<br />union all select 'a_asset_spread' as namatable, (select count(*) from a_asset_spread) as jumlah<br />union all select 'a_depreciation_convention' as namatable, (select count(*) from a_depreciation_convention) as jumlah<br />union all select 'a_depreciation_forecast' as namatable, (select count(*) from a_depreciation_forecast) as jumlah<br />union all select 'a_depreciation_entry' as namatable, (select count(*) from a_depreciation_entry) as jumlah<br />union all select 'a_depreciation_method' as namatable, (select count(*) from a_depreciation_method) as jumlah<br />union all select 'a_depreciation_table_detail' as namatable, (select count(*) from a_depreciation_table_detail) as jumlah<br />union all select 'a_asset_use' as namatable, (select count(*) from a_asset_use) as jumlah<br />union all select 'a_fundingmode' as namatable, (select count(*) from a_fundingmode) as jumlah<br />union all select 'a_depreciation_table_header' as namatable, (select count(*) from a_depreciation_table_header) as jumlah<br />union all select 'a_registration' as namatable, (select count(*) from a_registration) as jumlah<br />union all select 'a_registrationattribute' as namatable, (select count(*) from a_registrationattribute) as jumlah<br />union all select 'a_fundingmode_acct' as namatable, (select count(*) from a_fundingmode_acct) as jumlah<br />union all select 'a_depreciation_workfile' as namatable, (select count(*) from a_depreciation_workfile) as jumlah<br />union all select 'a_depreciation' as namatable, (select count(*) from a_depreciation) as jumlah<br />union all select 'a_depreciation_build' as namatable, (select count(*) from a_depreciation_build) as jumlah<br />union all select 'a_depreciation_exp' as namatable, (select count(*) from a_depreciation_exp) as jumlah<br />union all select 'a_registrationproduct' as namatable, (select count(*) from a_registrationproduct) as jumlah<br />union all select 'a_registrationvalue' as namatable, (select count(*) from a_registrationvalue) as jumlah<br />union all select 'ad_alertprocessorlog' as namatable, (select count(*) from ad_alertprocessorlog) as jumlah<br />union all select 'ad_alertrule' as namatable, (select count(*) from ad_alertrule) as jumlah<br />union all select 'ad_archive' as namatable, (select count(*) from ad_archive) as jumlah<br />union all select 'ad_alert' as namatable, (select count(*) from ad_alert) as jumlah<br />union all select 'ad_alertprocessor' as namatable, (select count(*) from ad_alertprocessor) as jumlah<br />union all select 'ad_client' as namatable, (select count(*) from ad_client) as jumlah<br />union all select 'ad_alertrecipient' as namatable, (select count(*) from ad_alertrecipient) as jumlah<br />union all select 'ad_user' as namatable, (select count(*) from ad_user) as jumlah<br />union all select 'ad_attachment' as namatable, (select count(*) from ad_attachment) as jumlah<br />union all select 'ad_attribute' as namatable, (select count(*) from ad_attribute) as jumlah<br />union all select 'ad_broadcastmessage' as namatable, (select count(*) from ad_broadcastmessage) as jumlah<br />union all select 'ad_broadcastmessage_trl' as namatable, (select count(*) from ad_broadcastmessage_trl) as jumlah<br />union all select 'ad_chart' as namatable, (select count(*) from ad_chart) as jumlah<br />union all select 'ad_chartdatasource' as namatable, (select count(*) from ad_chartdatasource) as jumlah<br />union all select 'ad_column_access' as namatable, (select count(*) from ad_column_access) as jumlah<br />union all select 'ad_attribute_value' as namatable, (select count(*) from ad_attribute_value) as jumlah<br />union all select 'ad_chart_trl' as namatable, (select count(*) from ad_chart_trl) as jumlah<br />union all select 'ad_clientinfo' as namatable, (select count(*) from ad_clientinfo) as jumlah<br />union all select 'ad_clientshare' as namatable, (select count(*) from ad_clientshare) as jumlah<br />union all select 'ad_color_trl' as namatable, (select count(*) from ad_color_trl) as jumlah<br />union all select 'ad_color' as namatable, (select count(*) from ad_color) as jumlah<br />union all select 'ad_changelog' as namatable, (select count(*) from ad_changelog) as jumlah<br />union all select 'ad_column' as namatable, (select count(*) from ad_column) as jumlah<br />union all select 'ad_ctxhelpsuggestion' as namatable, (select count(*) from ad_ctxhelpsuggestion) as jumlah<br />union all select 'ad_ctxhelpmsg_trl' as namatable, (select count(*) from ad_ctxhelpmsg_trl) as jumlah<br />union all select 'ad_element' as namatable, (select count(*) from ad_element) as jumlah<br />union all select 'ad_desktop_trl' as namatable, (select count(*) from ad_desktop_trl) as jumlah<br />union all select 'ad_desktopworkbench' as namatable, (select count(*) from ad_desktopworkbench) as jumlah<br />union all select 'ad_column_trl' as namatable, (select count(*) from ad_column_trl) as jumlah<br />union all select 'ad_fieldgroup' as namatable, (select count(*) from ad_fieldgroup) as jumlah<br />union all select 'ad_entitytype' as namatable, (select count(*) from ad_entitytype) as jumlah<br />union all select 'ad_error' as namatable, (select count(*) from ad_error) as jumlah<br />union all select 'ad_field_trl' as namatable, (select count(*) from ad_field_trl) as jumlah<br />union all select 'ad_desktop' as namatable, (select count(*) from ad_desktop) as jumlah<br />union all select 'ad_document_action_access' as namatable, (select count(*) from ad_document_action_access) as jumlah<br />union all select 'ad_element_trl' as namatable, (select count(*) from ad_element_trl) as jumlah<br />union all select 'ad_field' as namatable, (select count(*) from ad_field) as jumlah<br />union all select 'ad_tab' as namatable, (select count(*) from ad_tab) as jumlah<br />union all select 'ad_ctxhelp' as namatable, (select count(*) from ad_ctxhelp) as jumlah<br />union all select 'ad_ctxhelpmsg' as namatable, (select count(*) from ad_ctxhelpmsg) as jumlah<br />union all select 'ad_form_access' as namatable, (select count(*) from ad_form_access) as jumlah<br />union all select 'ad_fieldgroup_trl' as namatable, (select count(*) from ad_fieldgroup_trl) as jumlah<br />union all select 'ad_impformat_row' as namatable, (select count(*) from ad_impformat_row) as jumlah<br />union all select 'ad_infocolumn' as namatable, (select count(*) from ad_infocolumn) as jumlah<br />union all select 'ad_form_trl' as namatable, (select count(*) from ad_form_trl) as jumlah<br />union all select 'ad_image' as namatable, (select count(*) from ad_image) as jumlah<br />union all select 'ad_indexcolumn' as namatable, (select count(*) from ad_indexcolumn) as jumlah<br />union all select 'ad_infoprocess' as namatable, (select count(*) from ad_infoprocess) as jumlah<br />union all select 'ad_impformat' as namatable, (select count(*) from ad_impformat) as jumlah<br />union all select 'ad_infocolumn_trl' as namatable, (select count(*) from ad_infocolumn_trl) as jumlah<br />union all select 'ad_importtemplateaccess' as namatable, (select count(*) from ad_importtemplateaccess) as jumlah<br />union all select 'ad_find' as namatable, (select count(*) from ad_find) as jumlah<br />union all select 'ad_form' as namatable, (select count(*) from ad_form) as jumlah<br />union all select 'ad_fieldsuggestion' as namatable, (select count(*) from ad_fieldsuggestion) as jumlah<br />union all select 'ad_housekeeping' as namatable, (select count(*) from ad_housekeeping) as jumlah<br />union all select 'ad_val_rule' as namatable, (select count(*) from ad_val_rule) as jumlah<br />union all select 'ad_importtemplate' as namatable, (select count(*) from ad_importtemplate) as jumlah<br />union all select 'ad_language' as namatable, (select count(*) from ad_language) as jumlah<br />union all select 'ad_infowindow_trl' as namatable, (select count(*) from ad_infowindow_trl) as jumlah<br />union all select 'ad_labelprinter' as namatable, (select count(*) from ad_labelprinter) as jumlah<br />union all select 'ad_infowindow' as namatable, (select count(*) from ad_infowindow) as jumlah<br />union all select 'ad_ldapprocessor' as namatable, (select count(*) from ad_ldapprocessor) as jumlah<br />union all select 'ad_ldapaccess' as namatable, (select count(*) from ad_ldapaccess) as jumlah<br />union all select 'ad_menu_trl' as namatable, (select count(*) from ad_menu_trl) as jumlah<br />union all select 'ad_ldapprocessorlog' as namatable, (select count(*) from ad_ldapprocessorlog) as jumlah<br />union all select 'ad_modelvalidator' as namatable, (select count(*) from ad_modelvalidator) as jumlah<br />union all select 'ad_note' as namatable, (select count(*) from ad_note) as jumlah<br />union all select 'ad_inforelated' as namatable, (select count(*) from ad_inforelated) as jumlah<br />union all select 'ad_message' as namatable, (select count(*) from ad_message) as jumlah<br />union all select 'ad_message_trl' as namatable, (select count(*) from ad_message_trl) as jumlah<br />union all select 'ad_menu' as namatable, (select count(*) from ad_menu) as jumlah<br />union all select 'ad_migrationscript' as namatable, (select count(*) from ad_migrationscript) as jumlah<br />union all select 'ad_infowindow_access' as namatable, (select count(*) from ad_infowindow_access) as jumlah<br />union all select 'ad_issue' as namatable, (select count(*) from ad_issue) as jumlah<br />union all select 'ad_modification' as namatable, (select count(*) from ad_modification) as jumlah<br />union all select 'ad_labelprinterfunction' as namatable, (select count(*) from ad_labelprinterfunction) as jumlah<br />union all select 'ad_orgtype' as namatable, (select count(*) from ad_orgtype) as jumlah<br />union all select 'ad_password_history' as namatable, (select count(*) from ad_password_history) as jumlah<br />union all select 'ad_package_imp' as namatable, (select count(*) from ad_package_imp) as jumlah<br />union all select 'ad_package_exp_detail' as namatable, (select count(*) from ad_package_exp_detail) as jumlah<br />union all select 'ad_orginfo' as namatable, (select count(*) from ad_orginfo) as jumlah<br />union all select 'ad_package_imp_proc' as namatable, (select count(*) from ad_package_imp_proc) as jumlah<br />union all select 'ad_package_exp_common' as namatable, (select count(*) from ad_package_exp_common) as jumlah<br />union all select 'ad_passwordrule' as namatable, (select count(*) from ad_passwordrule) as jumlah<br />union all select 'ad_package_imp_inst' as namatable, (select count(*) from ad_package_imp_inst) as jumlah<br />union all select 'ad_package_uuid_map' as namatable, (select count(*) from ad_package_uuid_map) as jumlah<br />union all select 'ad_package_imp_backup' as namatable, (select count(*) from ad_package_imp_backup) as jumlah<br />union all select 'ad_package_exp' as namatable, (select count(*) from ad_package_exp) as jumlah<br />union all select 'ad_org' as namatable, (select count(*) from ad_org) as jumlah<br />union all select 'c_bpartner' as namatable, (select count(*) from c_bpartner) as jumlah<br />union all select 'ad_pinstance_log' as namatable, (select count(*) from ad_pinstance_log) as jumlah<br />union all select 'ad_printcolor_trl' as namatable, (select count(*) from ad_printcolor_trl) as jumlah<br />union all select 'ad_printfont' as namatable, (select count(*) from ad_printfont) as jumlah<br />union all select 'ad_printgraph' as namatable, (select count(*) from ad_printgraph) as jumlah<br />union all select 'ad_printform' as namatable, (select count(*) from ad_printform) as jumlah<br />union all select 'ad_printformat_trl' as namatable, (select count(*) from ad_printformat_trl) as jumlah<br />union all select 'ad_process' as namatable, (select count(*) from ad_process) as jumlah<br />union all select 'ad_process_access' as namatable, (select count(*) from ad_process_access) as jumlah<br />union all select 'ad_pinstance_para' as namatable, (select count(*) from ad_pinstance_para) as jumlah<br />union all select 'ad_printpaper' as namatable, (select count(*) from ad_printpaper) as jumlah<br />union all select 'ad_printlabelline' as namatable, (select count(*) from ad_printlabelline) as jumlah<br />union all select 'ad_private_access' as namatable, (select count(*) from ad_private_access) as jumlah<br />union all select 'ad_printlabelline_trl' as namatable, (select count(*) from ad_printlabelline_trl) as jumlah<br />union all select 'ad_printtableformat' as namatable, (select count(*) from ad_printtableformat) as jumlah<br />union all select 'ad_printformatitem_trl' as namatable, (select count(*) from ad_printformatitem_trl) as jumlah<br />union all select 'ad_printlabel' as namatable, (select count(*) from ad_printlabel) as jumlah<br />union all select 'ad_postit' as namatable, (select count(*) from ad_postit) as jumlah<br />union all select 'ad_printcolor' as namatable, (select count(*) from ad_printcolor) as jumlah<br />union all select 'ad_preference' as namatable, (select count(*) from ad_preference) as jumlah<br />union all select 'ad_printformat' as namatable, (select count(*) from ad_printformat) as jumlah<br />union all select 'ad_printformatitem' as namatable, (select count(*) from ad_printformatitem) as jumlah<br />union all select 'ad_reportview' as namatable, (select count(*) from ad_reportview) as jumlah<br />union all select 'ad_replication' as namatable, (select count(*) from ad_replication) as jumlah<br />union all select 'ad_reference_trl' as namatable, (select count(*) from ad_reference_trl) as jumlah<br />union all select 'ad_record_access' as namatable, (select count(*) from ad_record_access) as jumlah<br />union all select 'ad_registration' as namatable, (select count(*) from ad_registration) as jumlah<br />union all select 'ad_reportview_column' as namatable, (select count(*) from ad_reportview_column) as jumlah<br />union all select 'ad_replicationstrategy' as namatable, (select count(*) from ad_replicationstrategy) as jumlah<br />union all select 'ad_process_trl' as namatable, (select count(*) from ad_process_trl) as jumlah<br />union all select 'ad_ref_list' as namatable, (select count(*) from ad_ref_list) as jumlah<br />union all select 'ad_ref_list_trl' as namatable, (select count(*) from ad_ref_list_trl) as jumlah<br />union all select 'ad_replicationdocument' as namatable, (select count(*) from ad_replicationdocument) as jumlah<br />union all select 'ad_replication_log' as namatable, (select count(*) from ad_replication_log) as jumlah<br />union all select 'ad_replicationtable' as namatable, (select count(*) from ad_replicationtable) as jumlah<br />union all select 'ad_recentitem' as namatable, (select count(*) from ad_recentitem) as jumlah<br />union all select 'ad_reference' as namatable, (select count(*) from ad_reference) as jumlah<br />union all select 'ad_relationtype' as namatable, (select count(*) from ad_relationtype) as jumlah<br />union all select 'ad_process_para' as namatable, (select count(*) from ad_process_para) as jumlah<br />union all select 'ad_reportview_col' as namatable, (select count(*) from ad_reportview_col) as jumlah<br />union all select 'ad_ref_table' as namatable, (select count(*) from ad_ref_table) as jumlah<br />union all select 'ad_process_para_trl' as namatable, (select count(*) from ad_process_para_trl) as jumlah<br />union all select 'ad_sequence' as namatable, (select count(*) from ad_sequence) as jumlah<br />union all select 'ad_sequence_audit' as namatable, (select count(*) from ad_sequence_audit) as jumlah<br />union all select 'ad_scheduler' as namatable, (select count(*) from ad_scheduler) as jumlah<br />union all select 'ad_schedule' as namatable, (select count(*) from ad_schedule) as jumlah<br />union all select 'ad_sequence_no' as namatable, (select count(*) from ad_sequence_no) as jumlah<br />union all select 'ad_schedulerlog' as namatable, (select count(*) from ad_schedulerlog) as jumlah<br />union all select 'ad_scheduler_para' as namatable, (select count(*) from ad_scheduler_para) as jumlah<br />union all select 'ad_schedulerrecipient' as namatable, (select count(*) from ad_schedulerrecipient) as jumlah<br />union all select 'ad_storageprovider' as namatable, (select count(*) from ad_storageprovider) as jumlah<br />union all select 'ad_session' as namatable, (select count(*) from ad_session) as jumlah<br />union all select 'ad_statusline' as namatable, (select count(*) from ad_statusline) as jumlah<br />union all select 'ad_searchdefinition' as namatable, (select count(*) from ad_searchdefinition) as jumlah<br />union all select 'ad_statuslineusedin' as namatable, (select count(*) from ad_statuslineusedin) as jumlah<br />union all select 'ad_rule' as namatable, (select count(*) from ad_rule) as jumlah<br />union all select 'ad_role_orgaccess' as namatable, (select count(*) from ad_role_orgaccess) as jumlah<br />union all select 'ad_role' as namatable, (select count(*) from ad_role) as jumlah<br />union all select 'ad_style' as namatable, (select count(*) from ad_style) as jumlah<br />union all select 'ad_role_included' as namatable, (select count(*) from ad_role_included) as jumlah<br />union all select 'ad_task_access' as namatable, (select count(*) from ad_task_access) as jumlah<br />union all select 'ad_styleline' as namatable, (select count(*) from ad_styleline) as jumlah<br />union all select 'ad_tab_customization' as namatable, (select count(*) from ad_tab_customization) as jumlah<br />union all select 'ad_table_trl' as namatable, (select count(*) from ad_table_trl) as jumlah<br />union all select 'ad_tree' as namatable, (select count(*) from ad_tree) as jumlah<br />union all select 'ad_task_trl' as namatable, (select count(*) from ad_task_trl) as jumlah<br />union all select 'ad_tab_trl' as namatable, (select count(*) from ad_tab_trl) as jumlah<br />union all select 'ad_toolbarbutton' as namatable, (select count(*) from ad_toolbarbutton) as jumlah<br />union all select 'ad_tableindex' as namatable, (select count(*) from ad_tableindex) as jumlah<br />union all select 'ad_table_scriptvalidator' as namatable, (select count(*) from ad_table_scriptvalidator) as jumlah<br />union all select 'ad_task' as namatable, (select count(*) from ad_task) as jumlah<br />union all select 'ad_toolbarbuttonrestrict' as namatable, (select count(*) from ad_toolbarbuttonrestrict) as jumlah<br />union all select 'ad_system' as namatable, (select count(*) from ad_system) as jumlah<br />union all select 'ad_treebar' as namatable, (select count(*) from ad_treebar) as jumlah<br />union all select 'ad_treenode' as namatable, (select count(*) from ad_treenode) as jumlah<br />union all select 'ad_treenodebp' as namatable, (select count(*) from ad_treenodebp) as jumlah<br />union all select 'ad_treenodecmc' as namatable, (select count(*) from ad_treenodecmc) as jumlah<br />union all select 'ad_treenodecmm' as namatable, (select count(*) from ad_treenodecmm) as jumlah<br />union all select 'ad_treenodecms' as namatable, (select count(*) from ad_treenodecms) as jumlah<br />union all select 'ad_treenodecmt' as namatable, (select count(*) from ad_treenodecmt) as jumlah<br />union all select 'ad_treenodemm' as namatable, (select count(*) from ad_treenodemm) as jumlah<br />union all select 'ad_sysconfig' as namatable, (select count(*) from ad_sysconfig) as jumlah<br />union all select 'ad_table_access' as namatable, (select count(*) from ad_table_access) as jumlah<br />union all select 'ad_treenodeu2' as namatable, (select count(*) from ad_treenodeu2) as jumlah<br />union all select 'ad_treenodeu3' as namatable, (select count(*) from ad_treenodeu3) as jumlah<br />union all select 'ad_treenodeu4' as namatable, (select count(*) from ad_treenodeu4) as jumlah<br />union all select 'ad_userbpaccess' as namatable, (select count(*) from ad_userbpaccess) as jumlah<br />union all select 'ad_userdef_tab' as namatable, (select count(*) from ad_userdef_tab) as jumlah<br />union all select 'ad_userpreference' as namatable, (select count(*) from ad_userpreference) as jumlah<br />union all select 'ad_wf_activityapprover' as namatable, (select count(*) from ad_wf_activityapprover) as jumlah<br />union all select 'ad_usermail' as namatable, (select count(*) from ad_usermail) as jumlah<br />union all select 'ad_userdef_win' as namatable, (select count(*) from ad_userdef_win) as jumlah<br />union all select 'ad_userquery' as namatable, (select count(*) from ad_userquery) as jumlah<br />union all select 'ad_wf_activity' as namatable, (select count(*) from ad_wf_activity) as jumlah<br />union all select 'ad_user_substitute' as namatable, (select count(*) from ad_user_substitute) as jumlah<br />union all select 'ad_userdef_field' as namatable, (select count(*) from ad_userdef_field) as jumlah<br />union all select 'ad_viewcomponent' as namatable, (select count(*) from ad_viewcomponent) as jumlah<br />union all select 'ad_wf_activityresult' as namatable, (select count(*) from ad_wf_activityresult) as jumlah<br />union all select 'ad_user_orgaccess' as namatable, (select count(*) from ad_user_orgaccess) as jumlah<br />union all select 'ad_treenodepr' as namatable, (select count(*) from ad_treenodepr) as jumlah<br />union all select 'ad_viewcolumn' as namatable, (select count(*) from ad_viewcolumn) as jumlah<br />union all select 'ad_wf_block' as namatable, (select count(*) from ad_wf_block) as jumlah<br />union all select 'ad_user_roles' as namatable, (select count(*) from ad_user_roles) as jumlah<br />union all select 'ad_treenodeu1' as namatable, (select count(*) from ad_treenodeu1) as jumlah<br />union all select 'ad_workbenchwindow' as namatable, (select count(*) from ad_workbenchwindow) as jumlah<br />union all select 'ad_window' as namatable, (select count(*) from ad_window) as jumlah<br />union all select 'ad_workflowprocessor' as namatable, (select count(*) from ad_workflowprocessor) as jumlah<br />union all select 'ad_window_trl' as namatable, (select count(*) from ad_window_trl) as jumlah<br />union all select 'ad_wf_processdata' as namatable, (select count(*) from ad_wf_processdata) as jumlah<br />union all select 'ad_wf_responsible' as namatable, (select count(*) from ad_wf_responsible) as jumlah<br />union all select 'ad_wf_node_para' as namatable, (select count(*) from ad_wf_node_para) as jumlah<br />union all select 'ad_workflow_access' as namatable, (select count(*) from ad_workflow_access) as jumlah<br />union all select 'ad_wf_node_trl' as namatable, (select count(*) from ad_wf_node_trl) as jumlah<br />union all select 'ad_wf_process' as namatable, (select count(*) from ad_wf_process) as jumlah<br />union all select 'ad_workflow_trl' as namatable, (select count(*) from ad_workflow_trl) as jumlah<br />union all select 'ad_wf_nodenext' as namatable, (select count(*) from ad_wf_nodenext) as jumlah<br />union all select 'ad_wf_nextcondition' as namatable, (select count(*) from ad_wf_nextcondition) as jumlah<br />union all select 'ad_workbench_trl' as namatable, (select count(*) from ad_workbench_trl) as jumlah<br />union all select 'ad_workflow' as namatable, (select count(*) from ad_workflow) as jumlah<br />union all select 'ad_workbench' as namatable, (select count(*) from ad_workbench) as jumlah<br />union all select 'ad_wf_node' as namatable, (select count(*) from ad_wf_node) as jumlah<br />union all select 'ad_window_access' as namatable, (select count(*) from ad_window_access) as jumlah<br />union all select 'ad_wf_eventaudit' as namatable, (select count(*) from ad_wf_eventaudit) as jumlah<br />union all select 'ad_wizardprocess' as namatable, (select count(*) from ad_wizardprocess) as jumlah<br />union all select 'asp_task' as namatable, (select count(*) from asp_task) as jumlah<br />union all select 'asp_field' as namatable, (select count(*) from asp_field) as jumlah<br />union all select 'ad_workflowprocessorlog' as namatable, (select count(*) from ad_workflowprocessorlog) as jumlah<br />union all select 'asp_module' as namatable, (select count(*) from asp_module) as jumlah<br />union all select 'asp_form' as namatable, (select count(*) from asp_form) as jumlah<br />union all select 'asp_process' as namatable, (select count(*) from asp_process) as jumlah<br />union all select 'ad_zoomcondition' as namatable, (select count(*) from ad_zoomcondition) as jumlah<br />union all select 'asp_process_para' as namatable, (select count(*) from asp_process_para) as jumlah<br />union all select 'asp_ref_list' as namatable, (select count(*) from asp_ref_list) as jumlah<br />union all select 'asp_tab' as namatable, (select count(*) from asp_tab) as jumlah<br />union all select 'b_bid' as namatable, (select count(*) from b_bid) as jumlah<br />union all select 'asp_workflow' as namatable, (select count(*) from asp_workflow) as jumlah<br />union all select 'b_buyer' as namatable, (select count(*) from b_buyer) as jumlah<br />union all select 'b_offer' as namatable, (select count(*) from b_offer) as jumlah<br />union all select 'b_buyerfunds' as namatable, (select count(*) from b_buyerfunds) as jumlah<br />union all select 'b_seller' as namatable, (select count(*) from b_seller) as jumlah<br />union all select 'b_bidcomment' as namatable, (select count(*) from b_bidcomment) as jumlah<br />union all select 'b_sellerfunds' as namatable, (select count(*) from b_sellerfunds) as jumlah<br />union all select 'asp_window' as namatable, (select count(*) from asp_window) as jumlah<br />union all select 'asp_clientexception' as namatable, (select count(*) from asp_clientexception) as jumlah<br />union all select 'asp_level' as namatable, (select count(*) from asp_level) as jumlah<br />union all select 'asp_clientlevel' as namatable, (select count(*) from asp_clientlevel) as jumlah<br />union all select 'b_topictype' as namatable, (select count(*) from b_topictype) as jumlah<br />union all select 'c_1099box' as namatable, (select count(*) from c_1099box) as jumlah<br />union all select 'c_addressvalidation' as namatable, (select count(*) from c_addressvalidation) as jumlah<br />union all select 'c_acctprocessorlog' as namatable, (select count(*) from c_acctprocessorlog) as jumlah<br />union all select 'c_acctschema_gl' as namatable, (select count(*) from c_acctschema_gl) as jumlah<br />union all select 'c_activity_trl' as namatable, (select count(*) from c_activity_trl) as jumlah<br />union all select 'c_allocationhdr' as namatable, (select count(*) from c_allocationhdr) as jumlah<br />union all select 'c_acctprocessor' as namatable, (select count(*) from c_acctprocessor) as jumlah<br />union all select 'c_bankaccount_acct' as namatable, (select count(*) from c_bankaccount_acct) as jumlah<br />union all select 'c_acctschema' as namatable, (select count(*) from c_acctschema) as jumlah<br />union all select 'c_addresstransaction' as namatable, (select count(*) from c_addresstransaction) as jumlah<br />union all select 'c_addressvalidationcfg' as namatable, (select count(*) from c_addressvalidationcfg) as jumlah<br />union all select 'c_bankaccount' as namatable, (select count(*) from c_bankaccount) as jumlah<br />union all select 'c_acctschema_element' as namatable, (select count(*) from c_acctschema_element) as jumlah<br />union all select 'c_bank' as namatable, (select count(*) from c_bank) as jumlah<br />union all select 'c_acctschema_default' as namatable, (select count(*) from c_acctschema_default) as jumlah<br />union all select 'b_topic' as namatable, (select count(*) from b_topic) as jumlah<br />union all select 'b_topiccategory' as namatable, (select count(*) from b_topiccategory) as jumlah<br />union all select 'c_bankstatement' as namatable, (select count(*) from c_bankstatement) as jumlah<br />union all select 'c_bp_edi' as namatable, (select count(*) from c_bp_edi) as jumlah<br />union all select 'c_bankaccountdoc' as namatable, (select count(*) from c_bankaccountdoc) as jumlah<br />union all select 'c_bankstatementloader' as namatable, (select count(*) from c_bankstatementloader) as jumlah<br />union all select 'c_bpartner_product' as namatable, (select count(*) from c_bpartner_product) as jumlah<br />union all select 'c_bankaccount_processor' as namatable, (select count(*) from c_bankaccount_processor) as jumlah<br />union all select 'c_bankstatementline' as namatable, (select count(*) from c_bankstatementline) as jumlah<br />union all select 'c_bankstatementmatcher' as namatable, (select count(*) from c_bankstatementmatcher) as jumlah<br />union all select 'c_bpartner_location' as namatable, (select count(*) from c_bpartner_location) as jumlah<br />union all select 'c_bp_employee_acct' as namatable, (select count(*) from c_bp_employee_acct) as jumlah<br />union all select 'c_bp_bankaccount' as namatable, (select count(*) from c_bp_bankaccount) as jumlah<br />union all select 'c_bp_group_acct' as namatable, (select count(*) from c_bp_group_acct) as jumlah<br />union all select 'c_bp_withholding' as namatable, (select count(*) from c_bp_withholding) as jumlah<br />union all select 'c_calendar' as namatable, (select count(*) from c_calendar) as jumlah<br />union all select 'c_campaign' as namatable, (select count(*) from c_campaign) as jumlah<br />union all select 'c_bp_vendor_acct' as namatable, (select count(*) from c_bp_vendor_acct) as jumlah<br />union all select 'c_bp_relation' as namatable, (select count(*) from c_bp_relation) as jumlah<br />union all select 'c_cashbook' as namatable, (select count(*) from c_cashbook) as jumlah<br />union all select 'c_cash' as namatable, (select count(*) from c_cash) as jumlah<br />union all select 'c_bp_group' as namatable, (select count(*) from c_bp_group) as jumlah<br />union all select 'c_bp_customer_acct' as namatable, (select count(*) from c_bp_customer_acct) as jumlah<br />union all select 'c_campaign_trl' as namatable, (select count(*) from c_campaign_trl) as jumlah<br />union all select 'c_bp_shippingacct' as namatable, (select count(*) from c_bp_shippingacct) as jumlah<br />union all select 'c_charge' as namatable, (select count(*) from c_charge) as jumlah<br />union all select 'c_commissionrun' as namatable, (select count(*) from c_commissionrun) as jumlah<br />union all select 'c_cashplanline' as namatable, (select count(*) from c_cashplanline) as jumlah<br />union all select 'c_commissionline' as namatable, (select count(*) from c_commissionline) as jumlah<br />union all select 'c_contactactivity' as namatable, (select count(*) from c_contactactivity) as jumlah<br />union all select 'c_commissiondetail' as namatable, (select count(*) from c_commissiondetail) as jumlah<br />union all select 'c_commission' as namatable, (select count(*) from c_commission) as jumlah<br />union all select 'c_cashline' as namatable, (select count(*) from c_cashline) as jumlah<br />union all select 'c_cashplan' as namatable, (select count(*) from c_cashplan) as jumlah<br />union all select 'c_chargetype_doctype' as namatable, (select count(*) from c_chargetype_doctype) as jumlah<br />union all select 'c_commissionamt' as namatable, (select count(*) from c_commissionamt) as jumlah<br />union all select 'c_conversion_rate' as namatable, (select count(*) from c_conversion_rate) as jumlah<br />union all select 'c_chargetype' as namatable, (select count(*) from c_chargetype) as jumlah<br />union all select 'c_conversiontype' as namatable, (select count(*) from c_conversiontype) as jumlah<br />union all select 'c_channel' as namatable, (select count(*) from c_channel) as jumlah<br />union all select 'c_city' as namatable, (select count(*) from c_city) as jumlah<br />union all select 'c_cashbook_acct' as namatable, (select count(*) from c_cashbook_acct) as jumlah<br />union all select 'c_charge_trl' as namatable, (select count(*) from c_charge_trl) as jumlah<br />union all select 'c_charge_acct' as namatable, (select count(*) from c_charge_acct) as jumlah<br />union all select 'c_currency_trl' as namatable, (select count(*) from c_currency_trl) as jumlah<br />union all select 'c_doctypecounter' as namatable, (select count(*) from c_doctypecounter) as jumlah<br />union all select 'c_countrygroupcountry' as namatable, (select count(*) from c_countrygroupcountry) as jumlah<br />union all select 'c_country' as namatable, (select count(*) from c_country) as jumlah<br />union all select 'c_countrygroup_trl' as namatable, (select count(*) from c_countrygroup_trl) as jumlah<br />union all select 'c_currency_acct' as namatable, (select count(*) from c_currency_acct) as jumlah<br />union all select 'c_depositbatch' as namatable, (select count(*) from c_depositbatch) as jumlah<br />union all select 'c_doctype_trl' as namatable, (select count(*) from c_doctype_trl) as jumlah<br />union all select 'c_cyclestep' as namatable, (select count(*) from c_cyclestep) as jumlah<br />union all select 'c_dunningrun' as namatable, (select count(*) from c_dunningrun) as jumlah<br />union all select 'c_cyclephase' as namatable, (select count(*) from c_cyclephase) as jumlah<br />union all select 'c_cycle' as namatable, (select count(*) from c_cycle) as jumlah<br />union all select 'c_countrygroup' as namatable, (select count(*) from c_countrygroup) as jumlah<br />union all select 'c_greeting' as namatable, (select count(*) from c_greeting) as jumlah<br />union all select 'c_dunninglevel' as namatable, (select count(*) from c_dunninglevel) as jumlah<br />union all select 'c_dunning' as namatable, (select count(*) from c_dunning) as jumlah<br />union all select 'c_dunningrunentry' as namatable, (select count(*) from c_dunningrunentry) as jumlah<br />union all select 'c_currency' as namatable, (select count(*) from c_currency) as jumlah<br />union all select 'c_doctype' as namatable, (select count(*) from c_doctype) as jumlah<br />union all select 'c_country_trl' as namatable, (select count(*) from c_country_trl) as jumlah<br />union all select 'c_depositbatchline' as namatable, (select count(*) from c_depositbatchline) as jumlah<br />union all select 'c_elementvalue_trl' as namatable, (select count(*) from c_elementvalue_trl) as jumlah<br />union all select 'c_paymentterm_trl' as namatable, (select count(*) from c_paymentterm_trl) as jumlah<br />union all select 'c_invoiceschedule' as namatable, (select count(*) from c_invoiceschedule) as jumlah<br />union all select 'c_location' as namatable, (select count(*) from c_location) as jumlah<br />union all select 'c_dunningrunline' as namatable, (select count(*) from c_dunningrunline) as jumlah<br />union all select 'c_order' as namatable, (select count(*) from c_order) as jumlah<br />union all select 'c_orderline' as namatable, (select count(*) from c_orderline) as jumlah<br />union all select 'c_interorg_acct' as namatable, (select count(*) from c_interorg_acct) as jumlah<br />union all select 'c_element' as namatable, (select count(*) from c_element) as jumlah<br />union all select 'c_greeting_trl' as namatable, (select count(*) from c_greeting_trl) as jumlah<br />union all select 'c_invoice' as namatable, (select count(*) from c_invoice) as jumlah<br />union all select 'c_paymentterm' as namatable, (select count(*) from c_paymentterm) as jumlah<br />union all select 'c_payment' as namatable, (select count(*) from c_payment) as jumlah<br />union all select 'c_elementvalue' as namatable, (select count(*) from c_elementvalue) as jumlah<br />union all select 'c_dunninglevel_trl' as namatable, (select count(*) from c_dunninglevel_trl) as jumlah<br />union all select 'm_product' as namatable, (select count(*) from m_product) as jumlah<br />union all select 'pp_product_bom' as namatable, (select count(*) from pp_product_bom) as jumlah<br />union all select 'c_uom_trl' as namatable, (select count(*) from c_uom_trl) as jumlah<br />union all select 'c_invoicebatch' as namatable, (select count(*) from c_invoicebatch) as jumlah<br />union all select 'c_invoicepayschedule' as namatable, (select count(*) from c_invoicepayschedule) as jumlah<br />union all select 's_resourceassignment' as namatable, (select count(*) from s_resourceassignment) as jumlah<br />union all select 'c_tax_trl' as namatable, (select count(*) from c_tax_trl) as jumlah<br />union all select 'm_product_trl' as namatable, (select count(*) from m_product_trl) as jumlah<br />union all select 'pp_product_bomline' as namatable, (select count(*) from pp_product_bomline) as jumlah<br />union all select 'm_attributesetinstance' as namatable, (select count(*) from m_attributesetinstance) as jumlah<br />union all select 'c_invoicetax' as namatable, (select count(*) from c_invoicetax) as jumlah<br />union all select 'c_invoicebatchline' as namatable, (select count(*) from c_invoicebatchline) as jumlah<br />union all select 'c_uom' as namatable, (select count(*) from c_uom) as jumlah<br />union all select 'c_tax' as namatable, (select count(*) from c_tax) as jumlah<br />union all select 'c_invoiceline' as namatable, (select count(*) from c_invoiceline) as jumlah<br />union all select 'c_jobremuneration' as namatable, (select count(*) from c_jobremuneration) as jumlah<br />union all select 'c_opportunity' as namatable, (select count(*) from c_opportunity) as jumlah<br />union all select 'c_orderlandedcost' as namatable, (select count(*) from c_orderlandedcost) as jumlah<br />union all select 'c_jobcategory' as namatable, (select count(*) from c_jobcategory) as jumlah<br />union all select 'c_job' as namatable, (select count(*) from c_job) as jumlah<br />union all select 'm_warehouse' as namatable, (select count(*) from m_warehouse) as jumlah<br />union all select 'c_jobassignment' as namatable, (select count(*) from c_jobassignment) as jumlah<br />union all select 'm_product_po' as namatable, (select count(*) from m_product_po) as jumlah<br />union all select 'c_landedcost' as namatable, (select count(*) from c_landedcost) as jumlah<br />union all select 'c_orderlandedcostallocation' as namatable, (select count(*) from c_orderlandedcostallocation) as jumlah<br />union all select 'c_nonbusinessday' as namatable, (select count(*) from c_nonbusinessday) as jumlah<br />union all select 'c_orderpayschedule' as namatable, (select count(*) from c_orderpayschedule) as jumlah<br />union all select 'c_ordertax' as namatable, (select count(*) from c_ordertax) as jumlah<br />union all select 'c_orgassignment' as namatable, (select count(*) from c_orgassignment) as jumlah<br />union all select 'c_ordersource' as namatable, (select count(*) from c_ordersource) as jumlah<br />union all select 'c_onlinetrxhistory' as namatable, (select count(*) from c_onlinetrxhistory) as jumlah<br />union all select 'c_landedcostallocation' as namatable, (select count(*) from c_landedcostallocation) as jumlah<br />union all select 'c_paymentbatch' as namatable, (select count(*) from c_paymentbatch) as jumlah<br />union all select 'c_payselectionline' as namatable, (select count(*) from c_payselectionline) as jumlah<br />union all select 'c_payschedule' as namatable, (select count(*) from c_payschedule) as jumlah<br />union all select 'c_pos' as namatable, (select count(*) from c_pos) as jumlah<br />union all select 'c_poskeylayout' as namatable, (select count(*) from c_poskeylayout) as jumlah<br />union all select 'c_phase' as namatable, (select count(*) from c_phase) as jumlah<br />union all select 'c_payselectioncheck' as namatable, (select count(*) from c_payselectioncheck) as jumlah<br />union all select 'c_paymentallocate' as namatable, (select count(*) from c_paymentallocate) as jumlah<br />union all select 'c_periodcontrol' as namatable, (select count(*) from c_periodcontrol) as jumlah<br />union all select 'c_payselection' as namatable, (select count(*) from c_payselection) as jumlah<br />union all select 'c_paymenttransaction' as namatable, (select count(*) from c_paymenttransaction) as jumlah<br />union all select 'c_period' as namatable, (select count(*) from c_period) as jumlah<br />union all select 'c_paymentprocessor' as namatable, (select count(*) from c_paymentprocessor) as jumlah<br />union all select 'c_poskey' as namatable, (select count(*) from c_poskey) as jumlah<br />union all select 'c_projectissue' as namatable, (select count(*) from c_projectissue) as jumlah<br />union all select 'c_recurringgroup' as namatable, (select count(*) from c_recurringgroup) as jumlah<br />union all select 'c_projectphase' as namatable, (select count(*) from c_projectphase) as jumlah<br />union all select 'c_postendertype' as namatable, (select count(*) from c_postendertype) as jumlah<br />union all select 'c_project' as namatable, (select count(*) from c_project) as jumlah<br />union all select 'c_region' as namatable, (select count(*) from c_region) as jumlah<br />union all select 'c_projectissuema' as namatable, (select count(*) from c_projectissuema) as jumlah<br />union all select 'c_pospayment' as namatable, (select count(*) from c_pospayment) as jumlah<br />union all select 'c_projecttask' as namatable, (select count(*) from c_projecttask) as jumlah<br />union all select 'c_projecttype' as namatable, (select count(*) from c_projecttype) as jumlah<br />union all select 'c_recurring_run' as namatable, (select count(*) from c_recurring_run) as jumlah<br />union all select 'c_recurring' as namatable, (select count(*) from c_recurring) as jumlah<br />union all select 'c_region_trl' as namatable, (select count(*) from c_region_trl) as jumlah<br />union all select 'c_project_acct' as namatable, (select count(*) from c_project_acct) as jumlah<br />union all select 'c_projectline' as namatable, (select count(*) from c_projectline) as jumlah<br />union all select 'c_salesregion_trl' as namatable, (select count(*) from c_salesregion_trl) as jumlah<br />union all select 'c_revenuerecognition_run' as namatable, (select count(*) from c_revenuerecognition_run) as jumlah<br />union all select 'c_remuneration' as namatable, (select count(*) from c_remuneration) as jumlah<br />union all select 'c_salesregion' as namatable, (select count(*) from c_salesregion) as jumlah<br />union all select 'c_rfqline' as namatable, (select count(*) from c_rfqline) as jumlah<br />union all select 'c_rfqresponse' as namatable, (select count(*) from c_rfqresponse) as jumlah<br />union all select 'c_rfq_topicsubscriber' as namatable, (select count(*) from c_rfq_topicsubscriber) as jumlah<br />union all select 'c_rfq' as namatable, (select count(*) from c_rfq) as jumlah<br />union all select 'c_rfqlineqty' as namatable, (select count(*) from c_rfqlineqty) as jumlah<br />union all select 'c_rfqresponseline' as namatable, (select count(*) from c_rfqresponseline) as jumlah<br />union all select 'c_rfq_topicsubscriberonly' as namatable, (select count(*) from c_rfq_topicsubscriberonly) as jumlah<br />union all select 'c_rfqresponselineqty' as namatable, (select count(*) from c_rfqresponselineqty) as jumlah<br />union all select 'c_revenuerecognition_plan' as namatable, (select count(*) from c_revenuerecognition_plan) as jumlah<br />union all select 'c_rfq_topic' as namatable, (select count(*) from c_rfq_topic) as jumlah<br />union all select 'c_revenuerecog_service' as namatable, (select count(*) from c_revenuerecog_service) as jumlah<br />union all select 'c_revenuerecognition' as namatable, (select count(*) from c_revenuerecognition) as jumlah<br />union all select 'c_taxprovider' as namatable, (select count(*) from c_taxprovider) as jumlah<br />union all select 'c_salesstage' as namatable, (select count(*) from c_salesstage) as jumlah<br />union all select 'c_taxtype' as namatable, (select count(*) from c_taxtype) as jumlah<br />union all select 'c_subscription_delivery' as namatable, (select count(*) from c_subscription_delivery) as jumlah<br />union all select 'c_task' as namatable, (select count(*) from c_task) as jumlah<br />union all select 'c_servicelevel' as namatable, (select count(*) from c_servicelevel) as jumlah<br />union all select 'c_taxdeclarationacct' as namatable, (select count(*) from c_taxdeclarationacct) as jumlah<br />union all select 'c_taxcategory' as namatable, (select count(*) from c_taxcategory) as jumlah<br />union all select 'c_taxdeclaration' as namatable, (select count(*) from c_taxdeclaration) as jumlah<br />union all select 'c_taxdefinition' as namatable, (select count(*) from c_taxdefinition) as jumlah<br />union all select 'c_taxgroup' as namatable, (select count(*) from c_taxgroup) as jumlah<br />union all select 'c_taxdeclarationline' as namatable, (select count(*) from c_taxdeclarationline) as jumlah<br />union all select 'c_subscription' as namatable, (select count(*) from c_subscription) as jumlah<br />union all select 'c_tax_acct' as namatable, (select count(*) from c_tax_acct) as jumlah<br />union all select 'c_taxbase' as namatable, (select count(*) from c_taxbase) as jumlah<br />union all select 'c_taxcategory_trl' as namatable, (select count(*) from c_taxcategory_trl) as jumlah<br />union all select 'c_salesstage_trl' as namatable, (select count(*) from c_salesstage_trl) as jumlah<br />union all select 'c_taxprovidercfg' as namatable, (select count(*) from c_taxprovidercfg) as jumlah<br />union all select 'c_subacct' as namatable, (select count(*) from c_subacct) as jumlah<br />union all select 'c_servicelevelline' as namatable, (select count(*) from c_servicelevelline) as jumlah<br />union all select 'c_subscriptiontype' as namatable, (select count(*) from c_subscriptiontype) as jumlah<br />union all select 'c_taxpostal' as namatable, (select count(*) from c_taxpostal) as jumlah<br />union all select 'c_withholding_acct' as namatable, (select count(*) from c_withholding_acct) as jumlah<br />union all select 'cm_broadcastserver' as namatable, (select count(*) from cm_broadcastserver) as jumlah<br />union all select 'c_withholding' as namatable, (select count(*) from c_withholding) as jumlah<br />union all select 'cm_accesslistrole' as namatable, (select count(*) from cm_accesslistrole) as jumlah<br />union all select 'c_year' as namatable, (select count(*) from c_year) as jumlah<br />union all select 'cm_accesslistbpgroup' as namatable, (select count(*) from cm_accesslistbpgroup) as jumlah<br />union all select 'c_uom_conversion' as namatable, (select count(*) from c_uom_conversion) as jumlah<br />union all select 'cm_accessmedia' as namatable, (select count(*) from cm_accessmedia) as jumlah<br />union all select 'cm_accessprofile' as namatable, (select count(*) from cm_accessprofile) as jumlah<br />union all select 'cm_chat' as namatable, (select count(*) from cm_chat) as jumlah<br />union all select 'cm_accessstage' as namatable, (select count(*) from cm_accessstage) as jumlah<br />union all select 'cm_accesscontainer' as namatable, (select count(*) from cm_accesscontainer) as jumlah<br />union all select 'cm_ad_cat' as namatable, (select count(*) from cm_ad_cat) as jumlah<br />union all select 'cm_ad' as namatable, (select count(*) from cm_ad) as jumlah<br />union all select 'cm_chattypeupdate' as namatable, (select count(*) from cm_chattypeupdate) as jumlah<br />union all select 'cm_container' as namatable, (select count(*) from cm_container) as jumlah<br />union all select 'cm_chattype' as namatable, (select count(*) from cm_chattype) as jumlah<br />union all select 'c_userremuneration' as namatable, (select count(*) from c_userremuneration) as jumlah<br />union all select 'cm_chatentry' as namatable, (select count(*) from cm_chatentry) as jumlah<br />union all select 'cm_chatupdate' as namatable, (select count(*) from cm_chatupdate) as jumlah<br />union all select 'c_validcombination' as namatable, (select count(*) from c_validcombination) as jumlah<br />union all select 'cm_accessnewschannel' as namatable, (select count(*) from cm_accessnewschannel) as jumlah<br />union all select 'cm_container_trl' as namatable, (select count(*) from cm_container_trl) as jumlah<br />union all select 'cm_newsitem' as namatable, (select count(*) from cm_newsitem) as jumlah<br />union all select 'cm_cstage_element_trl' as namatable, (select count(*) from cm_cstage_element_trl) as jumlah<br />union all select 'cm_cstage' as namatable, (select count(*) from cm_cstage) as jumlah<br />union all select 'cm_container_url' as namatable, (select count(*) from cm_container_url) as jumlah<br />union all select 'cm_cstage_element' as namatable, (select count(*) from cm_cstage_element) as jumlah<br />union all select 'cm_mediadeploy' as namatable, (select count(*) from cm_mediadeploy) as jumlah<br />union all select 'cm_cstage_trl' as namatable, (select count(*) from cm_cstage_trl) as jumlah<br />union all select 'cm_media_server' as namatable, (select count(*) from cm_media_server) as jumlah<br />union all select 'cm_container_element' as namatable, (select count(*) from cm_container_element) as jumlah<br />union all select 'cm_newschannel' as namatable, (select count(*) from cm_newschannel) as jumlah<br />union all select 'cm_container_element_trl' as namatable, (select count(*) from cm_container_element_trl) as jumlah<br />union all select 'cm_cstagettable' as namatable, (select count(*) from cm_cstagettable) as jumlah<br />union all select 'cm_media' as namatable, (select count(*) from cm_media) as jumlah<br />union all select 'cm_containerttable' as namatable, (select count(*) from cm_containerttable) as jumlah<br />union all select 'cm_webproject_domain' as namatable, (select count(*) from cm_webproject_domain) as jumlah<br />union all select 'cm_wikitoken' as namatable, (select count(*) from cm_wikitoken) as jumlah<br />union all select 'cm_template_ad_cat' as namatable, (select count(*) from cm_template_ad_cat) as jumlah<br />union all select 'dd_orderline' as namatable, (select count(*) from dd_orderline) as jumlah<br />union all select 'cm_webaccesslog' as namatable, (select count(*) from cm_webaccesslog) as jumlah<br />union all select 'cm_template' as namatable, (select count(*) from cm_template) as jumlah<br />union all select 'exp_format' as namatable, (select count(*) from exp_format) as jumlah<br />union all select 'exp_processor' as namatable, (select count(*) from exp_processor) as jumlah<br />union all select 'dbreplicasyncverifier' as namatable, (select count(*) from dbreplicasyncverifier) as jumlah<br />union all select 'cm_templatetable' as namatable, (select count(*) from cm_templatetable) as jumlah<br />union all select 'cm_webproject' as namatable, (select count(*) from cm_webproject) as jumlah<br />union all select 'dd_order' as namatable, (select count(*) from dd_order) as jumlah<br />union all select 'dual' as namatable, (select count(*) from dual) as jumlah<br />union all select 'exp_formatline' as namatable, (select count(*) from exp_formatline) as jumlah<br />union all select 'dd_networkdistribution' as namatable, (select count(*) from dd_networkdistribution) as jumlah<br />union all select 'gl_journal' as namatable, (select count(*) from gl_journal) as jumlah<br />union all select 'exp_processor_type' as namatable, (select count(*) from exp_processor_type) as jumlah<br />union all select 'fact_acct_summary' as namatable, (select count(*) from fact_acct_summary) as jumlah<br />union all select 'gl_category_trl' as namatable, (select count(*) from gl_category_trl) as jumlah<br />union all select 'gl_budget' as namatable, (select count(*) from gl_budget) as jumlah<br />union all select 'gl_category' as namatable, (select count(*) from gl_category) as jumlah<br />union all select 'gl_fund' as namatable, (select count(*) from gl_fund) as jumlah<br />union all select 'gl_distribution' as namatable, (select count(*) from gl_distribution) as jumlah<br />union all select 'gl_distributionline' as namatable, (select count(*) from gl_distributionline) as jumlah<br />union all select 'gl_journalgenerator' as namatable, (select count(*) from gl_journalgenerator) as jumlah<br />union all select 'exp_processorparameter' as namatable, (select count(*) from exp_processorparameter) as jumlah<br />union all select 'gl_budgetcontrol' as namatable, (select count(*) from gl_budgetcontrol) as jumlah<br />union all select 'gl_journalbatch' as namatable, (select count(*) from gl_journalbatch) as jumlah<br />union all select 'gl_journalgeneratorline' as namatable, (select count(*) from gl_journalgeneratorline) as jumlah<br />union all select 'gl_fundrestriction' as namatable, (select count(*) from gl_fundrestriction) as jumlah<br />union all select 'fact_acct' as namatable, (select count(*) from fact_acct) as jumlah<br />union all select 'fact_reconciliation' as namatable, (select count(*) from fact_reconciliation) as jumlah<br />union all select 'hr_department' as namatable, (select count(*) from hr_department) as jumlah<br />union all select 'hr_payroll' as namatable, (select count(*) from hr_payroll) as jumlah<br />union all select 'hr_payrollconcept' as namatable, (select count(*) from hr_payrollconcept) as jumlah<br />union all select 'hr_attribute' as namatable, (select count(*) from hr_attribute) as jumlah<br />union all select 'hr_employee' as namatable, (select count(*) from hr_employee) as jumlah<br />union all select 'hr_job' as namatable, (select count(*) from hr_job) as jumlah<br />union all select 'gl_journalgeneratorsource' as namatable, (select count(*) from gl_journalgeneratorsource) as jumlah<br />union all select 'hr_movement' as namatable, (select count(*) from hr_movement) as jumlah<br />union all select 'i_bankstatement' as namatable, (select count(*) from i_bankstatement) as jumlah<br />union all select 'hr_list' as namatable, (select count(*) from hr_list) as jumlah<br />union all select 'hr_listversion' as namatable, (select count(*) from hr_listversion) as jumlah<br />union all select 'hr_listline' as namatable, (select count(*) from hr_listline) as jumlah<br />union all select 'hr_listtype' as namatable, (select count(*) from hr_listtype) as jumlah<br />union all select 'hr_process' as namatable, (select count(*) from hr_process) as jumlah<br />union all select 'i_bpartner' as namatable, (select count(*) from i_bpartner) as jumlah<br />union all select 'hr_year' as namatable, (select count(*) from hr_year) as jumlah<br />union all select 'hr_concept' as namatable, (select count(*) from hr_concept) as jumlah<br />union all select 'hr_concept_category' as namatable, (select count(*) from hr_concept_category) as jumlah<br />union all select 'gl_journalline' as namatable, (select count(*) from gl_journalline) as jumlah<br />union all select 'hr_contract' as namatable, (select count(*) from hr_contract) as jumlah<br />union all select 'hr_concept_acct' as namatable, (select count(*) from hr_concept_acct) as jumlah<br />union all select 'i_asset' as namatable, (select count(*) from i_asset) as jumlah<br />union all select 'hr_period' as namatable, (select count(*) from hr_period) as jumlah<br />union all select 'i_gljournal' as namatable, (select count(*) from i_gljournal) as jumlah<br />union all select 'i_hr_movement' as namatable, (select count(*) from i_hr_movement) as jumlah<br />union all select 'i_elementvalue' as namatable, (select count(*) from i_elementvalue) as jumlah<br />union all select 'i_fajournal' as namatable, (select count(*) from i_fajournal) as jumlah<br />union all select 'i_invoice' as namatable, (select count(*) from i_invoice) as jumlah<br />union all select 'i_productplanning' as namatable, (select count(*) from i_productplanning) as jumlah<br />union all select 'i_pricelist' as namatable, (select count(*) from i_pricelist) as jumlah<br />union all select 'i_conversion_rate' as namatable, (select count(*) from i_conversion_rate) as jumlah<br />union all select 'i_order' as namatable, (select count(*) from i_order) as jumlah<br />union all select 'i_movement' as namatable, (select count(*) from i_movement) as jumlah<br />union all select 'i_product' as namatable, (select count(*) from i_product) as jumlah<br />union all select 'i_inventory' as namatable, (select count(*) from i_inventory) as jumlah<br />union all select 'i_payment' as namatable, (select count(*) from i_payment) as jumlah<br />union all select 'i_fixedasset' as namatable, (select count(*) from i_fixedasset) as jumlah<br />union all select 'i_inoutlineconfirm' as namatable, (select count(*) from i_inoutlineconfirm) as jumlah<br />union all select 'k_entryrelated' as namatable, (select count(*) from k_entryrelated) as jumlah<br />union all select 'imp_processorparameter' as namatable, (select count(*) from imp_processorparameter) as jumlah<br />union all select 'k_category' as namatable, (select count(*) from k_category) as jumlah<br />union all select 'k_source' as namatable, (select count(*) from k_source) as jumlah<br />union all select 'imp_processor_type' as namatable, (select count(*) from imp_processor_type) as jumlah<br />union all select 'k_categoryvalue' as namatable, (select count(*) from k_categoryvalue) as jumlah<br />union all select 'k_comment' as namatable, (select count(*) from k_comment) as jumlah<br />union all select 'k_entrycategory' as namatable, (select count(*) from k_entrycategory) as jumlah<br />union all select 'k_topic' as namatable, (select count(*) from k_topic) as jumlah<br />union all select 'k_entry' as namatable, (select count(*) from k_entry) as jumlah<br />union all select 'k_index' as namatable, (select count(*) from k_index) as jumlah<br />union all select 'k_indexstop' as namatable, (select count(*) from k_indexstop) as jumlah<br />union all select 'k_indexlog' as namatable, (select count(*) from k_indexlog) as jumlah<br />union all select 'i_reportline' as namatable, (select count(*) from i_reportline) as jumlah<br />union all select 'k_type' as namatable, (select count(*) from k_type) as jumlah<br />union all select 'm_attribute' as namatable, (select count(*) from m_attribute) as jumlah<br />union all select 'k_synonym' as namatable, (select count(*) from k_synonym) as jumlah<br />union all select 'imp_processor' as namatable, (select count(*) from imp_processor) as jumlah<br />union all select 'imp_processorlog' as namatable, (select count(*) from imp_processorlog) as jumlah<br />union all select 'm_attributeset' as namatable, (select count(*) from m_attributeset) as jumlah<br />union all select 'm_costhistory' as namatable, (select count(*) from m_costhistory) as jumlah<br />union all select 'm_costqueue' as namatable, (select count(*) from m_costqueue) as jumlah<br />union all select 'm_attributevalue' as namatable, (select count(*) from m_attributevalue) as jumlah<br />union all select 'm_attributesearch' as namatable, (select count(*) from m_attributesearch) as jumlah<br />union all select 'm_bomalternative' as namatable, (select count(*) from m_bomalternative) as jumlah<br />union all select 'm_changenotice' as namatable, (select count(*) from m_changenotice) as jumlah<br />union all select 'm_bom' as namatable, (select count(*) from m_bom) as jumlah<br />union all select 'm_attributeinstance' as namatable, (select count(*) from m_attributeinstance) as jumlah<br />union all select 'm_costelement' as namatable, (select count(*) from m_costelement) as jumlah<br />union all select 'm_changerequest' as namatable, (select count(*) from m_changerequest) as jumlah<br />union all select 'm_costdetail' as namatable, (select count(*) from m_costdetail) as jumlah<br />union all select 'm_costtype' as namatable, (select count(*) from m_costtype) as jumlah<br />union all select 'm_bomproduct' as namatable, (select count(*) from m_bomproduct) as jumlah<br />union all select 'm_attributesetexclude' as namatable, (select count(*) from m_attributesetexclude) as jumlah<br />union all select 'm_commodityshipment' as namatable, (select count(*) from m_commodityshipment) as jumlah<br />union all select 'm_bp_price' as namatable, (select count(*) from m_bp_price) as jumlah<br />union all select 'm_cost' as namatable, (select count(*) from m_cost) as jumlah<br />union all select 'm_attributeuse' as namatable, (select count(*) from m_attributeuse) as jumlah<br />union all select 'm_demandline' as namatable, (select count(*) from m_demandline) as jumlah<br />union all select 'm_forecastline' as namatable, (select count(*) from m_forecastline) as jumlah<br />union all select 'm_freight' as namatable, (select count(*) from m_freight) as jumlah<br />union all select 'm_discountschemabreak' as namatable, (select count(*) from m_discountschemabreak) as jumlah<br />union all select 'm_distributionlist' as namatable, (select count(*) from m_distributionlist) as jumlah<br />union all select 'm_distributionlistline' as namatable, (select count(*) from m_distributionlistline) as jumlah<br />union all select 'm_demand' as namatable, (select count(*) from m_demand) as jumlah<br />union all select 'm_distributionrunline' as namatable, (select count(*) from m_distributionrunline) as jumlah<br />union all select 'm_distributionrun' as namatable, (select count(*) from m_distributionrun) as jumlah<br />union all select 'm_edi' as namatable, (select count(*) from m_edi) as jumlah<br />union all select 'm_edi_info' as namatable, (select count(*) from m_edi_info) as jumlah<br />union all select 'm_freightcategory' as namatable, (select count(*) from m_freightcategory) as jumlah<br />union all select 'm_discountschema' as namatable, (select count(*) from m_discountschema) as jumlah<br />union all select 'm_demanddetail' as namatable, (select count(*) from m_demanddetail) as jumlah<br />union all select 'm_discountschemaline' as namatable, (select count(*) from m_discountschemaline) as jumlah<br />union all select 'm_forecast' as namatable, (select count(*) from m_forecast) as jumlah<br />union all select 'm_inventory' as namatable, (select count(*) from m_inventory) as jumlah<br />union all select 'm_inoutlinema' as namatable, (select count(*) from m_inoutlinema) as jumlah<br />union all select 'm_inventorylinema' as namatable, (select count(*) from m_inventorylinema) as jumlah<br />union all select 'm_locator' as namatable, (select count(*) from m_locator) as jumlah<br />union all select 'm_inoutlineconfirm' as namatable, (select count(*) from m_inoutlineconfirm) as jumlah<br />union all select 'm_inventoryline' as namatable, (select count(*) from m_inventoryline) as jumlah<br />union all select 'm_inoutconfirm' as namatable, (select count(*) from m_inoutconfirm) as jumlah<br />union all select 'm_rmaline' as namatable, (select count(*) from m_rmaline) as jumlah<br />union all select 'm_inout' as namatable, (select count(*) from m_inout) as jumlah<br />union all select 'm_inoutline' as namatable, (select count(*) from m_inoutline) as jumlah<br />union all select 'm_lot' as namatable, (select count(*) from m_lot) as jumlah<br />union all select 'm_lotctl' as namatable, (select count(*) from m_lotctl) as jumlah<br />union all select 'm_product_bom' as namatable, (select count(*) from m_product_bom) as jumlah<br />union all select 'm_package' as namatable, (select count(*) from m_package) as jumlah<br />union all select 'm_movementline' as namatable, (select count(*) from m_movementline) as jumlah<br />union all select 'm_movementconfirm' as namatable, (select count(*) from m_movementconfirm) as jumlah<br />union all select 'm_matchinv' as namatable, (select count(*) from m_matchinv) as jumlah<br />union all select 'm_lotctlexclude' as namatable, (select count(*) from m_lotctlexclude) as jumlah<br />union all select 'm_movementlinema' as namatable, (select count(*) from m_movementlinema) as jumlah<br />union all select 'm_packageline' as namatable, (select count(*) from m_packageline) as jumlah<br />union all select 'm_movementlineconfirm' as namatable, (select count(*) from m_movementlineconfirm) as jumlah<br />union all select 'm_locatortype' as namatable, (select count(*) from m_locatortype) as jumlah<br />union all select 'm_matchpo' as namatable, (select count(*) from m_matchpo) as jumlah<br />union all select 'm_operationresource' as namatable, (select count(*) from m_operationresource) as jumlah<br />union all select 'm_movement' as namatable, (select count(*) from m_movement) as jumlah<br />union all select 'm_substitute' as namatable, (select count(*) from m_substitute) as jumlah<br />union all select 'm_productionline' as namatable, (select count(*) from m_productionline) as jumlah<br />union all select 'm_perpetualinv' as namatable, (select count(*) from m_perpetualinv) as jumlah<br />union all select 'm_productprice' as namatable, (select count(*) from m_productprice) as jumlah<br />union all select 'm_product_category_acct' as namatable, (select count(*) from m_product_category_acct) as jumlah<br />union all select 'm_pricelist_version_trl' as namatable, (select count(*) from m_pricelist_version_trl) as jumlah<br />union all select 'm_parttype' as namatable, (select count(*) from m_parttype) as jumlah<br />union all select 'm_product_category_trl' as namatable, (select count(*) from m_product_category_trl) as jumlah<br />union all select 'm_packagemps' as namatable, (select count(*) from m_packagemps) as jumlah<br />union all select 'm_pricelist_trl' as namatable, (select count(*) from m_pricelist_trl) as jumlah<br />union all select 'm_product_acct' as namatable, (select count(*) from m_product_acct) as jumlah<br />union all select 'm_production' as namatable, (select count(*) from m_production) as jumlah<br />union all select 'm_relatedproduct' as namatable, (select count(*) from m_relatedproduct) as jumlah<br />union all select 'm_storagereservation' as namatable, (select count(*) from m_storagereservation) as jumlah<br />union all select 'm_product_qualitytest' as namatable, (select count(*) from m_product_qualitytest) as jumlah<br />union all select 'm_productdownload' as namatable, (select count(*) from m_productdownload) as jumlah<br />union all select 'm_productionlinema' as namatable, (select count(*) from m_productionlinema) as jumlah<br />union all select 'm_pricelist' as namatable, (select count(*) from m_pricelist) as jumlah<br />union all select 'm_pricelist_version' as namatable, (select count(*) from m_pricelist_version) as jumlah<br />union all select 'm_storageonhand' as namatable, (select count(*) from m_storageonhand) as jumlah<br />union all select 'm_product_category' as namatable, (select count(*) from m_product_category) as jumlah<br />union all select 'm_promotiongroupline' as namatable, (select count(*) from m_promotiongroupline) as jumlah<br />union all select 'm_productionplan' as namatable, (select count(*) from m_productionplan) as jumlah<br />union all select 'm_requisitionline' as namatable, (select count(*) from m_requisitionline) as jumlah<br />union all select 'm_promotionreward' as namatable, (select count(*) from m_promotionreward) as jumlah<br />union all select 'm_promotionline' as namatable, (select count(*) from m_promotionline) as jumlah<br />union all select 'm_qualitytest' as namatable, (select count(*) from m_qualitytest) as jumlah<br />union all select 'm_promotiondistribution' as namatable, (select count(*) from m_promotiondistribution) as jumlah<br />union all select 'm_promotiongroup' as namatable, (select count(*) from m_promotiongroup) as jumlah<br />union all select 'm_productpricevendorbreak' as namatable, (select count(*) from m_productpricevendorbreak) as jumlah<br />union all select 'm_rmatax' as namatable, (select count(*) from m_rmatax) as jumlah<br />union all select 'm_qualitytestresult' as namatable, (select count(*) from m_qualitytestresult) as jumlah<br />union all select 'm_rma' as namatable, (select count(*) from m_rma) as jumlah<br />union all select 'm_promotionprecondition' as namatable, (select count(*) from m_promotionprecondition) as jumlah<br />union all select 'm_promotion' as namatable, (select count(*) from m_promotion) as jumlah<br />union all select 'm_replenish' as namatable, (select count(*) from m_replenish) as jumlah<br />union all select 'm_requisition' as namatable, (select count(*) from m_requisition) as jumlah<br />union all select 'm_productoperation' as namatable, (select count(*) from m_productoperation) as jumlah<br />union all select 'm_shipperlabels' as namatable, (select count(*) from m_shipperlabels) as jumlah<br />union all select 'm_shippingtransaction' as namatable, (select count(*) from m_shippingtransaction) as jumlah<br />union all select 'm_transaction' as namatable, (select count(*) from m_transaction) as jumlah<br />union all select 'm_shipperlabelscfg' as namatable, (select count(*) from m_shipperlabelscfg) as jumlah<br />union all select 'm_shipperpackaging' as namatable, (select count(*) from m_shipperpackaging) as jumlah<br />union all select 'm_shipperpackagingcfg' as namatable, (select count(*) from m_shipperpackagingcfg) as jumlah<br />union all select 'm_shipperpickuptypes' as namatable, (select count(*) from m_shipperpickuptypes) as jumlah<br />union all select 'm_warehouse_acct' as namatable, (select count(*) from m_warehouse_acct) as jumlah<br />union all select 'm_shipperpickuptypescfg' as namatable, (select count(*) from m_shipperpickuptypescfg) as jumlah<br />union all select 'm_shippercfg' as namatable, (select count(*) from m_shippercfg) as jumlah<br />union all select 'm_shippingprocessor' as namatable, (select count(*) from m_shippingprocessor) as jumlah<br />union all select 'm_shippingprocessorcfg' as namatable, (select count(*) from m_shippingprocessorcfg) as jumlah<br />union all select 'pa_achievement' as namatable, (select count(*) from pa_achievement) as jumlah<br />union all select 'm_transactionallocation' as namatable, (select count(*) from m_transactionallocation) as jumlah<br />union all select 'm_shippingtransactionline' as namatable, (select count(*) from m_shippingtransactionline) as jumlah<br />union all select 'm_rmatype' as namatable, (select count(*) from m_rmatype) as jumlah<br />union all select 'm_shipper' as namatable, (select count(*) from m_shipper) as jumlah<br />union all select 'm_sernoctlexclude' as namatable, (select count(*) from m_sernoctlexclude) as jumlah<br />union all select 'm_sernoctl' as namatable, (select count(*) from m_sernoctl) as jumlah<br />union all select 'pa_reportcolumnset' as namatable, (select count(*) from pa_reportcolumnset) as jumlah<br />union all select 'pa_dashboardpreference' as namatable, (select count(*) from pa_dashboardpreference) as jumlah<br />union all select 'pa_dashboardcontent_access' as namatable, (select count(*) from pa_dashboardcontent_access) as jumlah<br />union all select 'pa_ratio' as namatable, (select count(*) from pa_ratio) as jumlah<br />union all select 'pa_documentstatus_trl' as namatable, (select count(*) from pa_documentstatus_trl) as jumlah<br />union all select 'pa_goal' as namatable, (select count(*) from pa_goal) as jumlah<br />union all select 'pa_dashboardcontent_trl' as namatable, (select count(*) from pa_dashboardcontent_trl) as jumlah<br />union all select 'pa_goalrestriction' as namatable, (select count(*) from pa_goalrestriction) as jumlah<br />union all select 'pa_measurecalc' as namatable, (select count(*) from pa_measurecalc) as jumlah<br />union all select 'pa_report' as namatable, (select count(*) from pa_report) as jumlah<br />union all select 'pa_ratioelement' as namatable, (select count(*) from pa_ratioelement) as jumlah<br />union all select 'pa_benchmark' as namatable, (select count(*) from pa_benchmark) as jumlah<br />union all select 'pa_hierarchy' as namatable, (select count(*) from pa_hierarchy) as jumlah<br />union all select 'pa_measure' as namatable, (select count(*) from pa_measure) as jumlah<br />union all select 'pa_reportcolumn' as namatable, (select count(*) from pa_reportcolumn) as jumlah<br />union all select 'pa_colorschema' as namatable, (select count(*) from pa_colorschema) as jumlah<br />union all select 'pa_documentstatus' as namatable, (select count(*) from pa_documentstatus) as jumlah<br />union all select 'pa_dashboardcontent' as namatable, (select count(*) from pa_dashboardcontent) as jumlah<br />union all select 'pp_cost_collectorma' as namatable, (select count(*) from pp_cost_collectorma) as jumlah<br />union all select 'pa_sla_criteria' as namatable, (select count(*) from pa_sla_criteria) as jumlah<br />union all select 'pp_cost_collector' as namatable, (select count(*) from pp_cost_collector) as jumlah<br />union all select 'pa_sla_measure' as namatable, (select count(*) from pa_sla_measure) as jumlah<br />union all select 'pp_mrp' as namatable, (select count(*) from pp_mrp) as jumlah<br />union all select 'pp_order_bomline' as namatable, (select count(*) from pp_order_bomline) as jumlah<br />union all select 'pp_order' as namatable, (select count(*) from pp_order) as jumlah<br />union all select 'pa_reportlineset' as namatable, (select count(*) from pa_reportlineset) as jumlah<br />union all select 'pa_reportline' as namatable, (select count(*) from pa_reportline) as jumlah<br />union all select 'pa_reportcube' as namatable, (select count(*) from pa_reportcube) as jumlah<br />union all select 'pa_reportsource' as namatable, (select count(*) from pa_reportsource) as jumlah<br />union all select 'pa_sla_goal' as namatable, (select count(*) from pa_sla_goal) as jumlah<br />union all select 'pp_order_bom_trl' as namatable, (select count(*) from pp_order_bom_trl) as jumlah<br />union all select 'pp_order_bomline_trl' as namatable, (select count(*) from pp_order_bomline_trl) as jumlah<br />union all select 'pp_order_bom' as namatable, (select count(*) from pp_order_bom) as jumlah<br />union all select 'pp_order_node_trl' as namatable, (select count(*) from pp_order_node_trl) as jumlah<br />union all select 'pp_wf_node_asset' as namatable, (select count(*) from pp_wf_node_asset) as jumlah<br />union all select 'pp_product_bomline_trl' as namatable, (select count(*) from pp_product_bomline_trl) as jumlah<br />union all select 'pp_order_workflow_trl' as namatable, (select count(*) from pp_order_workflow_trl) as jumlah<br />union all select 'pp_wf_node_product' as namatable, (select count(*) from pp_wf_node_product) as jumlah<br />union all select 'pp_order_nodenext' as namatable, (select count(*) from pp_order_nodenext) as jumlah<br />union all select 'pp_order_workflow' as namatable, (select count(*) from pp_order_workflow) as jumlah<br />union all select 'pp_product_bom_trl' as namatable, (select count(*) from pp_product_bom_trl) as jumlah<br />union all select 'pp_order_node' as namatable, (select count(*) from pp_order_node) as jumlah<br />union all select 'qm_specification' as namatable, (select count(*) from qm_specification) as jumlah<br />union all select 'pp_order_cost' as namatable, (select count(*) from pp_order_cost) as jumlah<br />union all select 'pp_order_node_product' as namatable, (select count(*) from pp_order_node_product) as jumlah<br />union all select 'pp_order_node_asset' as namatable, (select count(*) from pp_order_node_asset) as jumlah<br />union all select 'pp_product_planning' as namatable, (select count(*) from pp_product_planning) as jumlah<br />union all select 'r_requestprocessor_route' as namatable, (select count(*) from r_requestprocessor_route) as jumlah<br />union all select 'r_interestarea' as namatable, (select count(*) from r_interestarea) as jumlah<br />union all select 'r_contactinterest' as namatable, (select count(*) from r_contactinterest) as jumlah<br />union all select 'r_issueuser' as namatable, (select count(*) from r_issueuser) as jumlah<br />union all select 'r_category' as namatable, (select count(*) from r_category) as jumlah<br />union all select 'r_mailtext' as namatable, (select count(*) from r_mailtext) as jumlah<br />union all select 'r_issuesource' as namatable, (select count(*) from r_issuesource) as jumlah<br />union all select 'r_issuestatus' as namatable, (select count(*) from r_issuestatus) as jumlah<br />union all select 'r_issuesystem' as namatable, (select count(*) from r_issuesystem) as jumlah<br />union all select 'r_requestprocessorlog' as namatable, (select count(*) from r_requestprocessorlog) as jumlah<br />union all select 'r_issuerecommendation' as namatable, (select count(*) from r_issuerecommendation) as jumlah<br />union all select 'r_requesttype' as namatable, (select count(*) from r_requesttype) as jumlah<br />union all select 'r_request' as namatable, (select count(*) from r_request) as jumlah<br />union all select 'qm_specificationline' as namatable, (select count(*) from qm_specificationline) as jumlah<br />union all select 'r_requestprocessor' as namatable, (select count(*) from r_requestprocessor) as jumlah<br />union all select 'r_categoryupdates' as namatable, (select count(*) from r_categoryupdates) as jumlah<br />union all select 'r_requestaction' as namatable, (select count(*) from r_requestaction) as jumlah<br />union all select 'r_mailtext_trl' as namatable, (select count(*) from r_mailtext_trl) as jumlah<br />union all select 'r_groupupdates' as namatable, (select count(*) from r_groupupdates) as jumlah<br />union all select 'r_issueproject' as namatable, (select count(*) from r_issueproject) as jumlah<br />union all select 'r_group' as namatable, (select count(*) from r_group) as jumlah<br />union all select 'r_status' as namatable, (select count(*) from r_status) as jumlah<br />union all select 'w_click' as namatable, (select count(*) from w_click) as jumlah<br />union all select 'r_standardresponse' as namatable, (select count(*) from r_standardresponse) as jumlah<br />union all select 'r_statuscategory' as namatable, (select count(*) from r_statuscategory) as jumlah<br />union all select 'r_resolution' as namatable, (select count(*) from r_resolution) as jumlah<br />union all select 'r_requestupdate' as namatable, (select count(*) from r_requestupdate) as jumlah<br />union all select 'r_requesttypeupdates' as namatable, (select count(*) from r_requesttypeupdates) as jumlah<br />union all select 'r_requestupdates' as namatable, (select count(*) from r_requestupdates) as jumlah<br />union all select 't_bomline' as namatable, (select count(*) from t_bomline) as jumlah<br />union all select 'w_clickcount' as namatable, (select count(*) from w_clickcount) as jumlah<br />union all select 't_1099extract' as namatable, (select count(*) from t_1099extract) as jumlah<br />union all select 's_resourcetype' as namatable, (select count(*) from s_resourcetype) as jumlah<br />union all select 's_expensetype' as namatable, (select count(*) from s_expensetype) as jumlah<br />union all select 's_timeexpenseline' as namatable, (select count(*) from s_timeexpenseline) as jumlah<br />union all select 's_training' as namatable, (select count(*) from s_training) as jumlah<br />union all select 's_timetype' as namatable, (select count(*) from s_timetype) as jumlah<br />union all select 's_resourceunavailable' as namatable, (select count(*) from s_resourceunavailable) as jumlah<br />union all select 's_timeexpense' as namatable, (select count(*) from s_timeexpense) as jumlah<br />union all select 's_training_class' as namatable, (select count(*) from s_training_class) as jumlah<br />union all select 's_resource' as namatable, (select count(*) from s_resource) as jumlah<br />union all select 't_bankregister' as namatable, (select count(*) from t_bankregister) as jumlah<br />union all select 't_alter_column' as namatable, (select count(*) from t_alter_column) as jumlah<br />union all select 't_aging' as namatable, (select count(*) from t_aging) as jumlah<br />union all select 't_bom_indented' as namatable, (select count(*) from t_bom_indented) as jumlah<br />union all select 't_cashflow' as namatable, (select count(*) from t_cashflow) as jumlah<br />union all select 't_invoicegl' as namatable, (select count(*) from t_invoicegl) as jumlah<br />union all select 't_selection' as namatable, (select count(*) from t_selection) as jumlah<br />union all select 't_replenish' as namatable, (select count(*) from t_replenish) as jumlah<br />union all select 't_mrp_crp' as namatable, (select count(*) from t_mrp_crp) as jumlah<br />union all select 't_reconciliation' as namatable, (select count(*) from t_reconciliation) as jumlah<br />union all select 't_report' as namatable, (select count(*) from t_report) as jumlah<br />union all select 't_reportstatement' as namatable, (select count(*) from t_reportstatement) as jumlah<br />union all select 't_spool' as namatable, (select count(*) from t_spool) as jumlah<br />union all select 't_selection2' as namatable, (select count(*) from t_selection2) as jumlah<br />union all select 't_selection_infowindow' as namatable, (select count(*) from t_selection_infowindow) as jumlah<br />union all select 't_transaction' as namatable, (select count(*) from t_transaction) as jumlah<br />union all select 't_distributionrundetail' as namatable, (select count(*) from t_distributionrundetail) as jumlah<br />union all select 't_inventoryvalue' as namatable, (select count(*) from t_inventoryvalue) as jumlah<br />union all select 'w_mailmsg' as namatable, (select count(*) from w_mailmsg) as jumlah<br />union all select 'u_blacklistcheque' as namatable, (select count(*) from u_blacklistcheque) as jumlah<br />union all select 'w_countercount' as namatable, (select count(*) from w_countercount) as jumlah<br />union all select 'w_advertisement' as namatable, (select count(*) from w_advertisement) as jumlah<br />union all select 'u_web_properties' as namatable, (select count(*) from u_web_properties) as jumlah<br />union all select 'w_basketline' as namatable, (select count(*) from w_basketline) as jumlah<br />union all select 'test' as namatable, (select count(*) from test) as jumlah<br />union all select 'w_basket' as namatable, (select count(*) from w_basket) as jumlah<br />union all select 'w_counter' as namatable, (select count(*) from w_counter) as jumlah<br />union all select 'u_webmenu' as namatable, (select count(*) from u_webmenu) as jumlah<br />union all select 'u_posterminal' as namatable, (select count(*) from u_posterminal) as jumlah<br />union all select 'w_store_trl' as namatable, (select count(*) from w_store_trl) as jumlah<br />union all select 'w_mailmsg_trl' as namatable, (select count(*) from w_mailmsg_trl) as jumlah<br />union all select 'u_rolemenu' as namatable, (select count(*) from u_rolemenu) as jumlah<br />union all select 'ws_webservice' as namatable, (select count(*) from ws_webservice) as jumlah<br />union all select 'w_store' as namatable, (select count(*) from w_store) as jumlah<br />union all select 'ws_webservicefieldoutput' as namatable, (select count(*) from ws_webservicefieldoutput) as jumlah<br />union all select 'ws_webservicetypeaccess' as namatable, (select count(*) from ws_webservicetypeaccess) as jumlah<br />union all select 'ws_webservice_para' as namatable, (select count(*) from ws_webservice_para) as jumlah<br />union all select 'ws_webservicemethod' as namatable, (select count(*) from ws_webservicemethod) as jumlah<br />union all select 'ws_webservicetype' as namatable, (select count(*) from ws_webservicetype) as jumlah<br />union all select 'c_activity' as namatable, (select count(*) from c_activity) as jumlah<br />union all select 't_trialbalance' as namatable, (select count(*) from t_trialbalance) as jumlah<br />union all select 'ad_table' as namatable, (select count(*) from ad_table) as jumlah<br />union all select 'ad_taskinstance' as namatable, (select count(*) from ad_taskinstance) as jumlah<br />union all select 'ad_attachmentnote' as namatable, (select count(*) from ad_attachmentnote) as jumlah<br />union all select 'ad_accesslog' as namatable, (select count(*) from ad_accesslog) as jumlah<br />union all select 'ws_webservicefieldinput' as namatable, (select count(*) from ws_webservicefieldinput) as jumlah<br />union all select 'ad_package_imp_detail' as namatable, (select count(*) from ad_package_imp_detail) as jumlah<br />union all select 'ad_replication_run' as namatable, (select count(*) from ad_replication_run) as jumlah<br />union all select 'c_allocationline' as namatable, (select count(*) from c_allocationline) as jumlah<br />union all select 'dd_networkdistributionline' as namatable, (select count(*) from dd_networkdistributionline) as jumlah<br />union all select 'pa_benchmarkdata' as namatable, (select count(*) from pa_benchmarkdata) as jumlah<br />union all select 'r_issueknown' as namatable, (select count(*) from r_issueknown) as jumlah<br />union all select 'z_document' as namatable, (select count(*) from z_document) as jumlah<br />union all select 't_moveclient' as namatable, (select count(*) from t_moveclient) as jumlah<br />union all select 'ad_pinstance' as namatable, (select count(*) from ad_pinstance) as jumlah<br />union all select 'p_namafile' as namatable, (select count(*) from p_namafile) as jumlah<br />union all select 'z_csv' as namatable, (select count(*) from z_csv) as jumlah<br />union all select 'z_csv_result' as namatable, (select count(*) from z_csv_result) as jumlah<br />union all select 'z_csv_data' as namatable, (select count(*) from z_csv_data) as jumlah<br />union all select 'z_product' as namatable, (select count(*) from z_product) as jumlah<br />union all select 'z_afei' as namatable, (select count(*) from z_afei) as jumlah<br />union all select 'z_aa' as namatable, (select count(*) from z_aa) as jumlah</blockquote>
budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-82674727696382815452019-08-27T21:46:00.000-07:002019-08-27T21:46:07.096-07:00idempiere Single Production Journal<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1f7nLCH-xGNwU_ar1Rsl_AvaLLCp8eQhUmw0plBGLfs8szQlN08dvfP16cJhd0baQMw4VqdgFqeuOOP81WG3BvXtg1M0W1j4HO6OzwnfbuXeZqpwaoDFgO9byQv2fN7ZZD5Gg4FijUq4/s1600/2019-08-28-114000_1366x768_scrot.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="228" data-original-width="807" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1f7nLCH-xGNwU_ar1Rsl_AvaLLCp8eQhUmw0plBGLfs8szQlN08dvfP16cJhd0baQMw4VqdgFqeuOOP81WG3BvXtg1M0W1j4HO6OzwnfbuXeZqpwaoDFgO9byQv2fN7ZZD5Gg4FijUq4/s1600/2019-08-28-114000_1366x768_scrot.png" /></a></div>
<br />budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-26506205729269731322019-08-03T05:20:00.000-07:002019-08-03T05:20:32.062-07:00Open Port 1521 on Windows 10//open cmd as Administrator<br />
<br />
netsh advfirewall firewall add rule name="Open Oracle 1521" protocol=TCP dir=in localport=1521 action=allow<br />
<br />budihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0tag:blogger.com,1999:blog-6047301590810575251.post-14615650589011469342019-07-29T02:52:00.003-07:002019-07-29T02:52:57.398-07:00Oracle 11xe silent installsetup.exe /s /f1"c:\path-to-Disk1\response\OracleXE-install.iss"<br />
<br />
HARUS DIIJINKAN INSTALLbudihttp://www.blogger.com/profile/02512534395990476517noreply@blogger.com0