![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
lafengmaker
这个作者很懒,什么都没留下…
展开
-
oracle在jdbc中连接出现出现ORA-00911: 无效字符
ORA-00911: 无效字符 注意写sql语句的时候不要带上;,否则就会报这个错误。 jdbc:oracle:thin:@192.168.1.23:1521:orcl oracle.jdbc.OracleDriver com.mysql.jdbc.Driver原创 2010-08-30 12:35:43 · 570 阅读 · 0 评论 -
oracle查看会话数,kill会话,查看linux oracle
select username, sid, serial# from v$session where username='用户名'; drop user yiwu2 cascade; select username,sid,serial# from v$session ; alter system kill session '14,7123'; alter system kill sess...原创 2010-08-30 12:52:14 · 317 阅读 · 0 评论 -
zz修改序列的当前值
---修改序列的当前值 declare LastValue integer; begin loop select seq_bl.currval into LastValue from dual; exit when LastValue >= 16000 - 1; select seq_bl.nextval into LastValue from dua...原创 2010-09-20 14:10:04 · 104 阅读 · 0 评论 -
oracle 启动服务
lsnrctl start 启动Oracle 11g服务: @echo off @ ECHO 启动 Oracle 11g 服务 net start "OracleDBConsoleorcl" net start "OracleOraDb11g_home1TNSListener" net start "OracleServiceORCL" @ ECHO 启动完毕 按任...原创 2012-09-21 09:59:02 · 61 阅读 · 0 评论 -
oracle常用
链接远程oracle su - oracle export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK" --设置编码和数据库一致 sqlplus "qqwcrm/密码@192.168.1.111:1521/orcl" 导入dmp imp qqwcrm151/pwd@ORCL file=/oracle/qqwcrm164.d...原创 2012-09-21 09:59:38 · 80 阅读 · 0 评论 -
oracle 表空间管理
create tablespace oms datafile 'D:\app\fff\oradata\orcl\OMS01.dbf' size 800m; alter tablespace oms add datafile 'c:\APP\ADMINISTRATOR\ORADATA\ORCL\OMS03.dbf' size 800m; alter tablespace oms add...原创 2012-09-22 15:42:09 · 80 阅读 · 0 评论