Time Zone
SQL> create table registry_backup as select * from registry$database;
SQL> INSERT into registry$database (platform_id, platform_name, edition, tz_version) VALUES ((select platform_id from v$database), (select platform_name from v$database),NULL,(select version from v$timezone_file));
1 row created.
SQL> select * from sys.registry$database;
PLATFORM_ID PLATFORM_NAME EDITION TZ_VERSION
----------- ------------------------------ ------------------------------ ----------
13 Linux x86 64-bit
13 Linux x86 64-bit 14
SQL> delete from sys.registry$database where TZ_VERSION is NULL;
1 row deleted.
SQL> select * from registry_backup;
PLATFORM_ID PLATFORM_NAME EDITION TZ_VERSION
----------- ------------------------------ ------------------------------ ----------
13 Linux x86 64-bit
SQL> commit;
Commit complete.
SQL> select * from sys.registry$database;
PLATFORM_ID PLATFORM_NAME EDITION TZ_VERSION
----------- ------------------------------ ------------------------------ ----------
13 Linux x86 64-bit 14
Timezone issue resolved with above solution.
--1
create table registry_backup as select * from registry$database;
--2
INSERT into registry$database (platform_id, platform_name, edition, tz_version) VALUES ((select platform_id from v$database), (select platform_name from v$database),NULL,(select version from v$timezone_file));
--3
delete from sys.registry$database where TZ_VERSION is NULL;
--4
commit;
--5
select * from sys.registry$database;
SQL> select * from sys.registry$database;
PLATFORM_ID PLATFORM_NAME EDITION TZ_VERSION
----------- ------------------------------ ------------------------------ ----------
13 Linux x86 64-bit
@$ORACLE_HOME/rdbms/admin/catalog.sql;
@$ORACLE_HOME/rdbms/admin/catproc.sql;
@$ORACLE_HOME/rdbms/admin/utlrp.sql
2017年9月23日 星期六
訂閱:
張貼留言 (Atom)
RHEL install EPEL
https://www.linuxtechi.com/install-epel-repo-on-rhel-system/ EPEL dnf install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest...
-
下載 出處 下載網址: http://tinyurl.com/plodb56 Step 1 下載取得「Windows10TweakTool」並解壓縮,在壓縮出的「Windows10SettingTool.bat」上按一下滑鼠右鍵,點擊選單中的【以系統管理員身分...
-
政黨還是有政績的 - 蠻有意思的 - 蠻有意思的,僅博君一笑 其實執政黨還是有政績的 ! 所以,不要再為難執政黨政府了,提出來跟大家分享 ! 1. 縮小貧富差距 – 至少 95% 的人都快要一樣窮了,大學畢業賺的錢跟國中畢業 賺的差不多 2. 與他國關係友好 – 不...
-
一、 FORMAT 字符串替代变量 使用 FORMAT 参数时可使用的各种替换变量,如下: %c :备份片的拷贝数 ( 从 1 开始编号 ) ; %d :数据库名称; %D :位于该月中的天数 (DD) ; %M :位于该年中的月份 (MM) ; ...
沒有留言:
張貼留言