|
All in One -
Data
|
|
Written by Administrator
|
|
Wednesday, 18 November 2009 23:29 |
|
=IF(ISNA(VLOOKUP(J7;$M$7:$M$1682;1;FALSE));"0";"1") |
|
All in One -
Data
|
|
Written by Administrator
|
|
Tuesday, 15 September 2009 07:22 |
|
in procedure or pl-sql block you have to add commit or rollback |
|
All in One -
Data
|
|
Written by Administrator
|
|
Friday, 14 August 2009 07:19 |
|
Use Exists instead of IN dont use : 27 seconds select count(*) from pro where pro_id in ( select pro_id from sales) OK : 20 seconds
select count(*) from pro p where exists ( select 1 from sales s where s.pro_id=c.pro_id * index should be created in different tablespace with table |
|
Last Updated ( Tuesday, 25 August 2009 06:43 )
|
|
All in One -
Data
|
|
Written by Administrator
|
|
Thursday, 23 July 2009 08:14 |
|
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=h:\oradata\archive' SCOPE=BOTH; ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
Solution : 1. Reset the LOG_ARCHIVE_DEST to NULL value :
SQL> ALTER SYSTEM set log_archive_dest='';
2. Set the LOG_ARCHIVE_DEST_1 to the value set to LOG_ARCHIVE_DEST before SQL> ALTER SYSTEM set log_archive_dest_1='LOCATION=/...';
if you use this code, you dont need to restart database: ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=h:\oradata\archive' SCOPE=BOTH;
To check archival destination issue is ok: show parameter LOG_ARCHIVE_DEST; select DEST_ID, DEST_NAME,DESTINATION from v$archive_dest;
|
|
Last Updated ( Thursday, 23 July 2009 08:29 )
|