Category Archives: PLSQL
How to create textual index with phoneme
First of all you need create one user (schema to test), in this example the user is scott and the language example is PORTUGUESE. 1. Grant permissions to scott with sys user : GRANT EXECUTE ON CTXSYS.CTX_ADM TO SCOTT; GRANT EXECUTE ON CTXSYS.CTX_CLS TO SCOTT; GRANT EXECUTE ON CTXSYS.CTX_DDL TO SCOTT; GRANT EXECUTE ON […]
Oracle Portal Performance
This note apply to Oracle Portal 10.1.4.2.0 in HA environment and linux S.O. In the webcache event.log file , continuously this message is shown : [warning 11366] [ecid: xxxxxx] A client connection to listening port 80 is dropped. If the mandatory patches was applied and portal performance is really slow, follow bellow : This note […]
Be careful when migrating – Difference between oracle 10g and 11g
All of DBAs know about new features of Oracle Database 11g, but here will expose of the possible problems to migrate. This note apply to Oracle Database 11g Release 2. New Features: ASM Fast Mirror Resync, a snapshot standby database is a fully updatable standby, Data Recover Advisor automatically diagnoses data failures, Improved Block Corruption […]
Materialized View with OID users data
Sometimes you need access users data of OID to integrate with other systems, follow bellow how to do: 1. Create Types : CREATE OR REPLACE TYPE LDAP_USU_TABLE is table of LDAP_USU_ROW; / CREATE OR REPLACE TYPE LDAP_USU_ROW as object (login varchar2(200), name varchar2(200), mail varchar2(200), phone varchar2(200)); / […]
How to invalidate pages in Webcache using database procedure
To invalidate dynamic pages in the webcache, you need send an XML file with the URL of the pages that you want to invalidate to web cache The advantage to use database procedure to invalidate is that should be invalidated as soon as the data in the database is updated. The better way is create […]
Error Messages ORA-00000 to ORA-00832
ORA-00000 to ORA-00832 ORA-00000: normal, successful completion Cause: Normal exit. Action: None. ORA-00001: unique constraint (string.string) violated Cause: An UPDATE or INSERT statement attempted to insert a duplicate key. For Trusted Oracle configured in DBMS MAC mode, you may see this message if a duplicate entry exists at a different level. Action: Either remove […]