冰洞

[code="java"]declare maxrecords constant int:=100; i int :=1;begin for i in 1..maxrecords loop insert into T_SMS_TO_MMS_DIY_DATA(ID,MOBILE_NO,CONTENT,LINKID,INSERT_TIME,IS_FETCH,IS_S...

表空间创建例子如下:1 CREATE TABLESPACE "SAMPLE"2 LOGGING3 DATAFILE 'D:\ORACLE\ORADATA\ORA92\SAMPLE.ora' SIZE 5M,4 'D:\ORACLE\ORADATA\ORA92\dd.ora' SIZE 5M5 EXTENT MANAGEMENT LOCAL6 UNIFORM SEGMENT ...

oracle安装目录下：E:\oracle\product\10.2.0\db_1\install\portlist.ini

ora-12505 1.重新启动监听程序2.listener.ora中增加红色部分SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = E:\oracle\product\10.2.0\db_1) (PROGRAM ...

[code="java"]C:\Documents and Settings\Administrator>sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on 星期五 2月 18 08:45:09 2011Copyright (c) 1982, 2005, Oracle. All rights reserved....

使用imp导入数据时，出现12557错误。使用同一账号plsql登陆没有问题。用的是64位oracle 11g，安装了32位客户端。从网上参考的方法解决了此问题并成功导入，解决办法是：将path参数中，服务端配置放置在客户端配置前。如：F:\oracle\product\11.2.0\client_1\bin;F:\oracle\product\11.2.0\clien...