oracle sync index job log file
Hi, I am using windows 2003 server with oracle database 10g enterprise edition. I created a procedure and scheduled job to do sync text indexes. I am using parallel 2 for my sync index job. the proble is: After i enable the log file option, ctx_output.start_log(‘SYNC_INDEXES_JOB.TXT’); ctx_output.add_event(ctx_output.event_index_print_rowid); ctx_output.end_log; 3 log files at ORACLE_HOME/ctx/log directory are [...]

Answer Question   |  January 30, 2009  3:51 PM
Oracle 10g, Oracle Database, Oracle Database 10g, Windows Server 2003

Finding which columns contain data in a table
I have to establish which columns in a table have data present. Each row has up to 100 columns, and not all of the columns contain data relating to the row. So in Table 1, Col1 Col2 Col3 Col4 Row 1 abc Row 2 abc Row 3 abc Would give a report showing that Table [...]

Answer Question   |  December 10, 2008  3:42 PM
columns, Data migration, Database migration, Oracle Database, Oracle Database to SQL Database Migration, SQL Database

How does one COMMENT a table ONLY if it has NO comment?
I am importing comments on 1500 tables from a separate source. I would like to put a comment on each table ONLY if one does not currently exist (COMMENTS field is NULL). A command like: COMMENT ON TABLE owner1.table1 IS ‘Test 4 adding comment’ WHERE owner = ‘OWNER1′ AND table_name = ‘TABLE1′; But the WHERE [...]

Answer Question   |  April 20, 2012  2:39 PM
Oracle Database, Oracle Table, Oracle Table Comments

Oracle Statspack
I recently started running statspack on my Oracle 9.2.0.7 database so I can get concrete evidence of what is going on in my database, besides viewing it through the grid. I started up statspack on Monday at 5pm and told my director that I’d turn is off at 5pm the next day. I did not [...]

Answer Question   |  December 4, 2008  8:26 PM
Oracle 9, Oracle 9.2.0.7, Oracle administration, Oracle Database, Oracle performance, Oracle Statspack

SQL Query
Hello everyone, I have the following table: CREATE TABLE MKW ( ID NUMBER, UREN NUMBER, DATUM DATE ); It has the following records: SQL> select * from mkw order by datum,id; ID UREN DATUM ———- ———- ——– 1 3 01-12-08 1 2 01-12-08 2 3 01-12-08 2 2 01-12-08 3 6 05-12-08 4 10 05-12-08 [...]

Answer Question   |  December 2, 2008  4:11 PM
Oracle Database, Oracle developers, SQL Query

How to synch Lotus notes grop/contacts to my java application group/contacts ?
Hi, I am new to lotus notes and wanted to synch lotus notes group/contacts to our application which is java. The requirement is we need a facility to copy/synch the lotus notes group details (including the group member contacts to the application ), that is a one way (from lotus notes to application groups details [...]

Answer Question   |  December 1, 2008  7:38 PM
Java, Lotus Notes Contacts, Lotus Notes Groups, Lotus Notes Synchronization, Oracle Database

Linked Server Query Returns Incomplete Results
I have set up a linked server using Microsoft OLE DB Provider for ODBC Driver to an Oracle DB ODBC DSN. The Oracle table I’m querying has 865 rows but when I try to fetch all the rows I only get back 766 rows. Why am I not getting the complete results? Here is the [...]

Answer Question   |  January 6, 2011  12:42 PM
Linked servers, ODBC, OLE DB, Oracle Database

Develop Oracle application by 4GL
I am a good developer in 4gl under Informix under platform UNIX. I want to transfer to Oracle 10g under Windows 2003 Server. Would you please give me tools to write my own 4gl program in using Oracle database under Windows.

Answer Question   |  November 9, 2012  9:29 AM
Oracle 10g, Oracle Database, Oracle development