rasti.hil@hilandco.com +41 79 367-9677

Thursday, 26 August 2010

BI Publisher turn on/off cache

From BI Publisher Release 10.1.3.3.2 there is a possibility to cache documents.
You can enable/disable this feature by going to

"Report" -> Edit -> Report Editor -> Report Properties -> General Settings -> Enable Document Cache

Tuesday, 3 August 2010

Recover datafile

1) check which tablespace is corrupted
SQL> select name, status from v$datafile where status not in ('ONLINE', 'SYSTEM');
2) take offline, recover datafile, bring it back online
SQL> alter datafile  'C:/ORACLEXE/ORADATA/XE/DATAFIEL_NAME.DBF' offline;
SQL> recover datafile 'C:/ORACLEXE/ORADATA/XE/DATAFIEL_NAME.DBF';
SQL> alter datafile  'C:/ORACLEXE/ORADATA/XE/DATAFIEL_NAME.DBF' online;