1.Oracle 11g ,装在我的笔记本上,笔记本2G内存,一切默认安装,装上以后,启动系统需要最少6分钟,太慢了,并且,打开系统性能监测,平时不作任何操作,进程中有一个 oracle.exe 一直高高在上,大约在80%左右,有办法解决一下啊
2.有一个建表语句,在SQL Developer中执行,会提示出错,没有找到原因,求高手指点原语句:
create table tbl_result_template --发送结果模板表
(
sm_type number not null,
sm_id number,
subtime date,
orgaddr varchar2(21),
destaddr varchar2(21),
sm_content varchar(160),
sendtime date,
msgid varchar2(22),
service_id varchar2(10),
fee_usertype varchar(1),
fee_terminal_id varchar(21),
msg_fmt number(6),
feetype varchar2(2),
feecode number(6),
valid_time date,
sent_time date not null,
msg_status varchar2(1),1表示成功,0表示失败
trytimes number(6),
recv_status varchar2(1),
recv_time date,
reserve1 number,
reserve2 varchar2(40)失败信息
)
报错信息如下:
Error starting at line 1 in command:
create table tbl_result_template --发送结果模板表
(
sm_type number not null,
sm_id number,
subtime date,
orgaddr varchar2(21),
destaddr varchar2(21),
sm_content varchar(160),
sendtime date,
msgid varchar2(22),
service_id varchar2(10),
fee_usertype varchar(1),
fee_terminal_id varchar(21),
msg_fmt number(6),
feetype varchar2(2),
feecode number(6),
valid_time date,
sent_time date not null,
msg_status varchar2(1),1表示成功,0表示失败
trytimes number(6),
recv_status varchar2(1),
recv_time date,
reserve1 number,
reserve2 varchar2(40)失败信息
)
Error at Command Line:19 Column:31
Error report:
SQL Error: ORA-00904: : 标识符无效
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
2.有一个建表语句,在SQL Developer中执行,会提示出错,没有找到原因,求高手指点原语句:
create table tbl_result_template --发送结果模板表
(
sm_type number not null,
sm_id number,
subtime date,
orgaddr varchar2(21),
destaddr varchar2(21),
sm_content varchar(160),
sendtime date,
msgid varchar2(22),
service_id varchar2(10),
fee_usertype varchar(1),
fee_terminal_id varchar(21),
msg_fmt number(6),
feetype varchar2(2),
feecode number(6),
valid_time date,
sent_time date not null,
msg_status varchar2(1),1表示成功,0表示失败
trytimes number(6),
recv_status varchar2(1),
recv_time date,
reserve1 number,
reserve2 varchar2(40)失败信息
)
报错信息如下:
Error starting at line 1 in command:
create table tbl_result_template --发送结果模板表
(
sm_type number not null,
sm_id number,
subtime date,
orgaddr varchar2(21),
destaddr varchar2(21),
sm_content varchar(160),
sendtime date,
msgid varchar2(22),
service_id varchar2(10),
fee_usertype varchar(1),
fee_terminal_id varchar(21),
msg_fmt number(6),
feetype varchar2(2),
feecode number(6),
valid_time date,
sent_time date not null,
msg_status varchar2(1),1表示成功,0表示失败
trytimes number(6),
recv_status varchar2(1),
recv_time date,
reserve1 number,
reserve2 varchar2(40)失败信息
)
Error at Command Line:19 Column:31
Error report:
SQL Error: ORA-00904: : 标识符无效
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
SQL> create table tbl_result_template --发送结果模板表
2 (
3 sm_type number not null,
4 sm_id number,
5 subtime date,
6 orgaddr varchar2(21),
7 destaddr varchar2(21),
8 sm_content varchar(160),
9 sendtime date,
10 msgid varchar2(22),
11 service_id varchar2(10),
12 fee_usertype varchar(1),
13 fee_terminal_id varchar(21),
14 msg_fmt number(6),
15 feetype varchar2(2),
16 feecode number(6),
17 valid_time date,
18 sent_time date not null,
19 msg_status varchar2(1),--1表示成功,0表示失败
20 trytimes number(6),
21 recv_status varchar2(1),
22 recv_time date,
23 reserve1 number,
24 reserve2 varchar2(40)--失败信息
25 );
Table created
如果慢系统慢, 可以把oracle所有的服务改成手动启动, 进入系统后要用的时候再start
方法:右键我的电脑->管理->服务和应用程序->服务
将关于oracle的进程都改为手动.只剩监听和实例两个为自动(一般是oracle最后两个)
在关机的时候,上面那两个也改为手动,下次启动电脑时就不会启动oracle.exe
如果开发时,再到服务里,打开监听和实例两个进程
(
sm_type number not null,
sm_id number,
subtime date,
orgaddr varchar2(21),
destaddr varchar2(21),
sm_content varchar(160),
sendtime date,
msgid varchar2(22),
service_id varchar2(10),
fee_usertype varchar(1),
fee_terminal_id varchar(21),
msg_fmt number(6),
feetype varchar2(2),
feecode number(6),
valid_time date,
sent_time date not null,
msg_status varchar2(1),--1表示成功,0表示失败
trytimes number(6),
recv_status varchar2(1),
recv_time date,
reserve1 number,
reserve2 varchar2(40)---失败信息
)