lafengmaker的博客

ORA-00911: 无效字符 注意写sql语句的时候不要带上；，否则就会报这个错误。jdbc:oracle:thin:@192.168.1.23:1521:orcloracle.jdbc.OracleDrivercom.mysql.jdbc.Driver

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...

---修改序列的当前值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...

 lsnrctl start 启动Oracle 11g服务： @echo off@ ECHO 启动 Oracle 11g 服务net start "OracleDBConsoleorcl"net start "OracleOraDb11g_home1TNSListener"net start "OracleServiceORCL"@ ECHO 启动完毕 按任...

链接远程oracle su - oracleexport NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK" --设置编码和数据库一致sqlplus "qqwcrm/密码@192.168.1.111:1521/orcl"  导入dmp imp qqwcrm151/pwd@ORCL file=/oracle/qqwcrm164.d...

 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...