Oracle Index – Synchronize periodically

You can create an index which will be synchronized automatically everytime you commit: Create index … on … INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS (‘SYNC ( ON COMMIT)’) or just periodically (p. x. every hour): Create index … on … INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS ‘SYNC (EVERY “SYSDATE+1/24”)’) See Topic on StackOverflow

Oracle tnsnames configuration

Usually the file is located under: C:\oracle\tns_admin\tnsnames.ora You can add an entry like this: <myapp> = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<ipaddress>)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(service_name=<myapp_servicename>))) If everything is ok you can try to test the connection Issuing a ping tnsping myapp or login as user sqlplus myuser@myapp or login as sysdba sqlplus sys@myapp as sysdba

Oracle: Exporting/Importing tables containing CLOB data

Exporting the table using SQLWorkbench Imagine you have a table images with a character column filename and a clob column image_data First you need to install the SQL-Workbench. Install does just mean to extract the archive in that case. The following command exports the table into a textfile. It does also generate the loader file […]