发布时间:2014-02-10 15:53:21
在portal没有加入TDS安全性后,portal密码策略需要修改以下参数来实现。修改WP ValidationService参数,添加以下变量。user.UNIQUEID.min = 1user.UNIQUEID.max = 60user.UNIQUEID.charset = asciiuser.UNIQUEID.extra_chars = -._ 密码的限制:password.min_characters = 5password.max_characters = 60p.........【阅读全文】
发布时间:2014-01-31 13:35:57
1.在服务器端执行命令开启监听[oracle@oracle11g ~]$ lsnrctl startLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 31-JAN-2014 13:24:51Copyright (c) 1991, 2011, Oracle. All rights reserved.Starting /u01/oracle/product/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0..........【阅读全文】
发布时间:2014-01-30 20:47:50
闪回删除表SQL> create table emp tablespace users as select * from hr.employees;Table created.SQL> select count(*) from emp; COUNT(*)---------- 107SQL> drop table emp;Table dropped.SQL> flashback table emp to before drop;Flashback complete.SQL> s.........【阅读全文】
发布时间:2014-01-30 20:16:21
闪回表闪回hr.employees表到10分钟之前SQL> flashback table hr.employees to timestamp (systimestamp - interval '10' minute);Flashback complete.将hr.employees闪回到SCN为1080381的时候SQL> alter table hr.departments enable row movement;Table altered.将hr.employees和hr.departments两张表到SCN为108.........【阅读全文】
发布时间:2014-01-30 20:04:03
闪回表时候报错:SQL> flashback table hr.employees to timestamp (systimestamp - interval '10' minute);flashback table hr.employees to timestamp (systimestamp - interval '10' minute) *ERROR at line 1:ORA-08189: cannot flashback t.........【阅读全文】