摘要: My personal website: http://47.94.240.229:8080/yjh/project/ 阅读全文
posted @ 2017-11-10 22:00 杨杨yang 阅读(266) 评论(0) 推荐(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 阅读(141) 评论(0) 推荐(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 阅读(6562) 评论(0) 推荐(0) 编辑
摘要: https://www.cnblogs.com/linjiqin/archive/2012/04/01/2428695.html 阅读全文
posted @ 2017-12-25 00:36 杨杨yang 阅读(115) 评论(0) 推荐(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 阅读(111) 评论(0) 推荐(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 阅读(123) 评论(0) 推荐(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 阅读(251) 评论(0) 推荐(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 阅读(119) 评论(0) 推荐(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 阅读(134) 评论(0) 推荐(0) 编辑
摘要: a.single table insert b.more table insert 阅读全文
posted @ 2017-11-27 21:35 杨杨yang 阅读(140) 评论(0) 推荐(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 阅读(132) 评论(0) 推荐(0) 编辑