摘要:
alter system set db_file_name_convert='AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA….' scope=spfile;-- 如果值超过255个字符,可以这样处理:alter system set db_file_name_convert='AAA','BBB','CCC','DDD'… scope=s... 阅读全文
摘要:
1. 创建分离分区的存储过程 CREATE OR REPLACE Procedure SP_Split_Partition(v_table_name_in in varchar2,v_part_name_prifex_in in varchar2,v_split_partition_source_in in varchar2,v_tablespace_name_in i... 阅读全文
摘要:
下载报的错误信息: Error 118 (net::ERR_CONNECTION_TIMED_OUT) The problem is with your IP address and it doesn't matter if you use google chrome or other browsers. You simply have to renew your IP address... 阅读全文
摘要:
select value from temp_a awhere a.id between 1 and 100and not exists(select * from temp_b b where a.value=b.value);这时能查出结果select value from temp_a awhere a.id between 1 and 100and a.valuenot in(select valuefrom temp_b);此时查出的结果为空.经过google终于找出原因: 内表(temp_b)有空值. 用not in得到的结果集都为空.以下是结论:1、对于not exists查询, 阅读全文