摘要:
My personal website: http://47.94.240.229:8080/yjh/project/
阅读全文
posted @ 2017-11-10 22:00
杨杨yang
阅读(274)
推荐(0)
摘要:
前提条件: 1.下载两个rpm包 全过程用root安装 https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/index.html oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm h
阅读全文
posted @ 2022-06-25 22:43
杨杨yang
阅读(194)
推荐(0)
摘要:
SP2-0734: unknown command beginning "lsnrctl st..." - rest of line ignored. Cause(原因):Command was being entered as an SQL command.在SQL命令窗口输入命令。Resolut
阅读全文
posted @ 2018-01-07 19:58
杨杨yang
阅读(6741)
推荐(0)
摘要:
https://www.cnblogs.com/linjiqin/archive/2012/04/01/2428695.html
阅读全文
posted @ 2017-12-25 00:36
杨杨yang
阅读(119)
推荐(0)
摘要:
1.Link name is random 2.username and password is database account 3.host name is ip address ifconfig 4.port usually is 1521 command lsnrclt start 5.si
阅读全文
posted @ 2017-12-14 22:16
杨杨yang
阅读(115)
推荐(0)
摘要:
How to rename table name eg. rename emp to emp01; see aslo: https://docs.oracle.com/javadb/10.8.3.0/ref/rrefsqljrenametablestatement.html
阅读全文
posted @ 2017-12-13 21:08
杨杨yang
阅读(129)
推荐(0)
摘要:
1.Environment:RedHat Linux Enterprise 6+Vmware Workstation 12 Pro 2.Linux shutdown and restart command summary shutdown command : shutdown -h now (imm
阅读全文
posted @ 2017-12-07 19:54
杨杨yang
阅读(261)
推荐(0)
摘要:
SUMMARY you can remember undo rule the same to redo if you want demo rule that you can look up the follow link http://blog.csdn.net/haibusuanyun/artic
阅读全文
posted @ 2017-11-30 00:31
杨杨yang
阅读(124)
推荐(0)
摘要:
if you have a question about recycle bin that can look the follow link; http://www.dba-oracle.com/t_oracle_recycle_bin.htm
阅读全文
posted @ 2017-11-28 23:41
杨杨yang
阅读(147)
推荐(0)
摘要:
a.single table insert b.more table insert
阅读全文
posted @ 2017-11-27 21:35
杨杨yang
阅读(144)
推荐(0)
摘要:
Tool:PL/SQL developer Syntax:SELECT 'DROP TABLE ' || table_name || ';' FROM user_tables; 1.then you can copy select result in command widows. 2.you ca
阅读全文
posted @ 2017-11-25 09:56
杨杨yang
阅读(139)
推荐(0)