Description:
Oracle related topics.
|
|
|
ODP.NET 10.2
|
| |
Hi, I'm not sure that this is a proper forum for this question but... I'm having a problem with setting the InitialLOBFetchSize to -1 in order to optimize the performance. When looking at the documentation this should be OK but the application is crashing or returning with corrupt data. Does anyone knows how to succesfully use this parameter... more »
|
|
Help Needed
|
| |
Greetings, Table structure test_users Data: role user 12 James 23 James 1002 James 9000 James 50000 James 9000 Scott 23 Brian 9000 Brian 50000 Sushil 45 Moore I have this enhancement where I have to EXCLUDE all users with roles < 1000 but keeping following in mind 1) role < 1000 and user should not be in any other role... more »
|
|
Split a dmp file before import
|
| |
Hi all, I have a dmp file that contains about 9 million rows. Is there a utility/technique that will split the file into two (or more) so that I can run the import in two (or more) stages? Thanks, Sashi
|
|
best easy oracle report writer?
|
| |
I've got some simple reports to generate. It would be nice if they could be put on the web and also generate PDFs. These reports are for internal consumption and probably will use just a small percentage of any software's feature set, so I would prefer cheap and simple over complex and full featured.... more »
|
|
Multi column update
|
| |
Hi all, I'm trying to write where appears to be a simple query but can't get it right. Here's the intent. update A set (a1,a2,a3) = (select sum(b1),sum(b2),sum(b3) from B group by b4 where B.b4 = A.A4) I got two tables, A and B. The join parameters are A.A4 and B.B4. I need to updated a1, a2 and a3 in A to equal the sums of b1, b2 and... more »
|
|
Blobs vs Bfile in 10g. Pros and Cons?
|
| |
Our department is uses 10g. We will be loading PDF files and/or pictures into our database. What are the pros and cons verses Bfile and Blobs. What has been your experience? Regards
|
|
Index on timestamp with timezone AT LOCAL
|
| |
Hi all, I have a table with a time stamp with timezone column: CREATE TABLE TEST_TZ ( DATE_TIME_TZ TIMESTAMP(3) ); CREATE INDEX IDX_DATE_TIME_TZ ON TEST_TZ (DATE_TIME_TZ); I want to use a view to get the time stamp column at the timezone of the session: CREATE OR REPLACE FORCE VIEW VI_TEST_TZ (DATE_TIME_LOCAL)... more »
|
|
free traffic
|
| |
Even if your PCs meet the Windows 7 minimum system requirements, there are a variety of other issues to consider with existing software and peripheral … [link]
|
|
|