Search results for query: *

We're using "Oracle9i", right? 9.2, hopefully? Then you can follow Oracle's advice: Stop using longs. use to_lob to convert the column to a CLOB. Then you can use context to provide all the cool full text searching you could ever want, or, if you just need to treat it like a big...

This type of error arises in CR 7,8,9 because they are using the Oracle7 OCI programmer's library. We have noticed significant problems with CLOB handling that are due to this problem as well. CR10 allegedly addresses this problem.

Dug, I'm inferring (ok, guessing) a bit here, but it looks like in your import script, you are probably doing something like: insert into bar(rtg_commit_start_dt) select to_date(commit_date,'mmdyyyy') from foo; when what you really want to do is: insert into bar(rtg_commit_start_dt) select...

Documentation links to the production release are now available on OTN... http://otn.oracle.com/documentation/database10g.html

Not at the expense of DOING something with 9i/10g. I'd much rather talk to someone who can talk intelligently about their experience implementing a 9i DB with a transparent gateway to MSSQL, and about the recovery scenario from the major fire they had last year, rather than four hours of...

The job of a dba is going away only if you think that the only job requirements are to make sure redo logs are sized appropriately. Right now, I'm working with some dbas to install oracle collaboration suite -- so now, the dba group will be responsible for installing, tuning, and maintaining a...

How are you 'output to screen'ing? Most languages can deal with ref cursors in some way shape or form. That sounds like the best way to meet your requirements.

In general, this type of question indicates that you're probably not using temporary tables in a way that makes sense in Oracle. If your plan is to create a table, fill it with values, do something to the rows you've generated, then drop the table, this is *not* what Oracle intends to support...

How fast do your users read? I'm pretty good at it, but 300,000 rows is a LOT of data. (300,000 rows x 5 secs. per row = 17 days 24/7) Do your users really need to see more than a tiny, tiny subset of that information? Like one? I think that's what you should focus on. Writing 300,000 rows to...