Search results for query: *

I am writing a C++ program, and the program will call some C library ( haval.h, haval.c ). However, it prompt the following error while i try to compile the program. Would anyone kindly give me a hand ? nafxcwd.lib(afxmem.obj) : error LNK2005: "void * __cdecl operator new(unsigned...

My company is writing some java program , and use JDBC to execute SQL statment. However, somtimes the java program will throw an exception with this message : "ORA-00604: error occurred at recursive SQL level 1. Can anyone tell me what is recursive SQL ?

Yes, of course I have analyze table. I use the following commands for each table :<br><br>ANALYZE TABLE [Table Name ] COMPUTE STATISTICS FOR TABLE ;<br>ANALYZE TABLE [Table Name ] COMPUTE STATISTICS FOR ALL INDEXES ;<br>ANALYZE TABLE [Table Name ] COMPUTE STATISTICS FOR ALL COLUMNS...

When u try to optimize a SQL statement, which one u will choose ? <br>In my case, my SQL statement always join with 4 - 7 tables ( UNION appears 3 times for each SQL statement ). When I choose Choose-based, the showplan show that some tables use index scan, and 1 or 2 tables use full table scan...

I am new to Oracle, and have very limited concept on it.<br>I have created 2 Rollback Segnment for my Oracle DB, and each of the segment is associated with individual tablespace.<br>After that, I observed that these tablespace grows and increase in size every day. <br><br>My questions is :<br>1...

When I did some bulk insert SQL statement, sometimes later the Oracle server is hang, and the following message appear on the console:<br><br>Warning - The following error occured during ORACLE redo log archival :<br>Oracle Instance hhcl - Can not allocate log, archival required.<br>Press to...

Thanks a lot

I am new to Oracle, and have no knowledge on it. <br>I have a small system, in which only 2 tables get over<br>10000 records. However, when I writing SQL to retrieve <br>data ( join from 4 or 5 table ). It takes around 15 <br>minutes to retrieve the date ( around 4000 records will <br>be...