sudo dnf groupinstall "Development Tools" -y
sudo dnf install libjpeg-devel libpng-devel -y
aws rds describe-db-engine-versions --engine aurora-postgresql --query '*[].[EngineVersion]' --output text --region ap-northeast-1
ALTER TABLE ARCSDBCS.CSM002 ADD CONSTRAINT CSM002_PK PRIMARY KEY (UCODE) ENABLE;
CREATE INDEX CSM002_INDEX01 ON ARCSDBCS.CSM002 (gcode, ccode, scode) TABLESPACE USERS;
※ 独自の環境変数を発生させる
#systemctl set-environment {NAME}={VALUE}SELECT CASE
WHEN f.bankcode IS NULL THEN v.bankcode
ELSE f.bankcode
END AS bankcode,
f.banknamef AS banknamef,
f.banknamek AS banknamek,
v.banknamef AS banknamef,
v.banknamek AS banknamek
FROM (SELECT *
FROM foreign_ccm102
EXCEPT
SELECT *
FROM view_ccm102) v
FULL JOIN (SELECT *
FROM view_ccm102
EXCEPT
SELECT *
FROM foreign_ccm102) f
ON f.bankcode = v.bankcode
ORDER BY bankcode;
create table ssr002_part ・・・・
最大日付を取得
一回目
INSERT INTO ssr002_part SELECT * FROM ssr002;
ALTER TABLE arcsdbss.ssr002 RENAME TO ssr002_no_part;
ALTER TABLE arcsdbss.ssr002_part RENAME TO ssr002;
2回目
INSERT INTO arcsdbss.ssr002 AS target
SELECT *
FROM arcsdbss.ssr002_no_part
where
rdate >='20250415'
ON CONFLICT (rdate, gcode, ccode, scode, rcode)
DO UPDATE SET
stime = EXCLUDED.stime,
xtime = EXCLUDED.xtime,
ztime = EXCLUDED.ztime,
stime_updatetime = EXCLUDED.stime_updatetime,
xtime_updatetime = EXCLUDED.xtime_updatetime,
ztime_updatetime = EXCLUDED.ztime_updatetime;
2'回目
INSERT INTO arcsdbss.ssr002 AS target
SELECT *
FROM arcsdbss.ssr002_no_part
WHERE
stime_updatetime > '20250415233000'
OR xtime_updatetime > '20250415233000'
OR ztime_updatetime > '20250415233000'
ON CONFLICT (rdate, gcode, ccode, scode, rcode)
DO UPDATE SET
stime = EXCLUDED.stime,
xtime = EXCLUDED.xtime,
ztime = EXCLUDED.ztime,
stime_updatetime = EXCLUDED.stime_updatetime,
xtime_updatetime = EXCLUDED.xtime_updatetime,
ztime_updatetime = EXCLUDED.ztime_updatetime;
#------------------------------------------------------------------
SET client_encoding TO 'UTF8';
SET search_path = arcsdbss,public;
CREATE TABLE sst008_p202403 PARTITION OF sst008
FOR VALUES FROM ('20240301000000000') TO ('20240401000000000')
PARTITION BY HASH (gcode, ccode, scode);
CREATE TABLE sst008_sys_subp202403_0 PARTITION OF sst008_p202403
FOR VALUES WITH (MODULUS 8, REMAINDER 0);
CREATE TABLE sst008_sys_subp202403_1 PARTITION OF sst008_p202403
FOR VALUES WITH (MODULUS 8, REMAINDER 1);
CREATE TABLE sst008_sys_subp202403_2 PARTITION OF sst008_p202403
FOR VALUES WITH (MODULUS 8, REMAINDER 2);
CREATE TABLE sst008_sys_subp202403_3 PARTITION OF sst008_p202403
FOR VALUES WITH (MODULUS 8, REMAINDER 3);
CREATE TABLE sst008_sys_subp202403_4 PARTITION OF sst008_p202403
FOR VALUES WITH (MODULUS 8, REMAINDER 4);
CREATE TABLE sst008_sys_subp202403_5 PARTITION OF sst008_p202403
FOR VALUES WITH (MODULUS 8, REMAINDER 5);
CREATE TABLE sst008_sys_subp202403_6 PARTITION OF sst008_p202403
FOR VALUES WITH (MODULUS 8, REMAINDER 6);
CREATE TABLE sst008_sys_subp202403_7 PARTITION OF sst008_p202403
FOR VALUES WITH (MODULUS 8, REMAINDER 7);
CREATE TABLE sst008_p202404 PARTITION OF sst008
FOR VALUES FROM ('20240401000000000') TO ('20240501000000000')
PARTITION BY HASH (gcode, ccode, scode);
CREATE TABLE sst008_sys_subp202404_0 PARTITION OF sst008_p202404
FOR VALUES WITH (MODULUS 8, REMAINDER 0);
CREATE TABLE sst008_sys_subp202404_1 PARTITION OF sst008_p202404
FOR VALUES WITH (MODULUS 8, REMAINDER 1);
CREATE TABLE sst008_sys_subp202404_2 PARTITION OF sst008_p202404
FOR VALUES WITH (MODULUS 8, REMAINDER 2);
CREATE TABLE sst008_sys_subp202404_3 PARTITION OF sst008_p202404
FOR VALUES WITH (MODULUS 8, REMAINDER 3);
CREATE TABLE sst008_sys_subp202404_4 PARTITION OF sst008_p202404
FOR VALUES WITH (MODULUS 8, REMAINDER 4);
CREATE TABLE sst008_sys_subp202404_5 PARTITION OF sst008_p202404
FOR VALUES WITH (MODULUS 8, REMAINDER 5);
CREATE TABLE sst008_sys_subp202404_6 PARTITION OF sst008_p202404
FOR VALUES WITH (MODULUS 8, REMAINDER 6);
CREATE TABLE sst008_sys_subp202404_7 PARTITION OF sst008_p202404
FOR VALUES WITH (MODULUS 8, REMAINDER 7);
CREATE TABLE sst008_p202405 PARTITION OF sst008
FOR VALUES FROM ('20240501000000000') TO ('20240601000000000')
PARTITION BY HASH (gcode, ccode, scode);
CREATE TABLE sst008_sys_subp202405_0 PARTITION OF sst008_p202405
FOR VALUES WITH (MODULUS 8, REMAINDER 0);
CREATE TABLE sst008_sys_subp202405_1 PARTITION OF sst008_p202405
FOR VALUES WITH (MODULUS 8, REMAINDER 1);
CREATE TABLE sst008_sys_subp202405_2 PARTITION OF sst008_p202405
FOR VALUES WITH (MODULUS 8, REMAINDER 2);
CREATE TABLE sst008_sys_subp202405_3 PARTITION OF sst008_p202405
FOR VALUES WITH (MODULUS 8, REMAINDER 3);
CREATE TABLE sst008_sys_subp202405_4 PARTITION OF sst008_p202405
FOR VALUES WITH (MODULUS 8, REMAINDER 4);
CREATE TABLE sst008_sys_subp202405_5 PARTITION OF sst008_p202405
FOR VALUES WITH (MODULUS 8, REMAINDER 5);
CREATE TABLE sst008_sys_subp202405_6 PARTITION OF sst008_p202405
FOR VALUES WITH (MODULUS 8, REMAINDER 6);
CREATE TABLE sst008_sys_subp202405_7 PARTITION OF sst008_p202405
FOR VALUES WITH (MODULUS 8, REMAINDER 7);
CREATE TABLE sst008_p202406 PARTITION OF sst008
FOR VALUES FROM ('20240601000000000') TO ('20240701000000000')
PARTITION BY HASH (gcode, ccode, scode);
CREATE TABLE sst008_sys_subp202406_0 PARTITION OF sst008_p202406
FOR VALUES WITH (MODULUS 8, REMAINDER 0);
CREATE TABLE sst008_sys_subp202406_1 PARTITION OF sst008_p202406
FOR VALUES WITH (MODULUS 8, REMAINDER 1);
CREATE TABLE sst008_sys_subp202406_2 PARTITION OF sst008_p202406
FOR VALUES WITH (MODULUS 8, REMAINDER 2);
CREATE TABLE sst008_sys_subp202406_3 PARTITION OF sst008_p202406
FOR VALUES WITH (MODULUS 8, REMAINDER 3);
CREATE TABLE sst008_sys_subp202406_4 PARTITION OF sst008_p202406
FOR VALUES WITH (MODULUS 8, REMAINDER 4);
CREATE TABLE sst008_sys_subp202406_5 PARTITION OF sst008_p202406
FOR VALUES WITH (MODULUS 8, REMAINDER 5);
CREATE TABLE sst008_sys_subp202406_6 PARTITION OF sst008_p202406
FOR VALUES WITH (MODULUS 8, REMAINDER 6);
CREATE TABLE sst008_sys_subp202406_7 PARTITION OF sst008_p202406
FOR VALUES WITH (MODULUS 8, REMAINDER 7);
CREATE TABLE sst008_sys_subp202406_default PARTITION OF sst008 DEFAULT;
$ wget https://standards-oui.ieee.org/oui/oui.txt
$ sqlplus system/password@dbsv:1521/service_name as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Wed Feb 21 17:44:10 2024
Version 18.5.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
$ sqlplus system/password@dbsv:1521/service_name
SQL*Plus: Release 18.0.0.0.0 - Production on Wed Feb 21 17:45:39 2024
Version 18.5.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> oradebug setmypid
ORA-01031: insufficient privileges
※ 特権にはOS認証が必要? リモートでは認証不可?
vi /usr/share/applications/google-chrome.desktop vi /usr/share/applications/chromium-browser.desktop Exec=/usr/bin/google-chrome-stable --g...