Re: How to load pictures/documents in oracle

asktom.oracle.com has a number of plsql examples to do so. hth connor --- Gene Sais [EMAIL PROTECTED] wrote: I don't have much experience developing applications using blobs but here is a link to help get you started. http://developer.iplanet.com/appserver/samples/database/docs/blob.html

RE: Statistics on SYS?

The cynic in me would think that this is tantamount to Oracle asking us to beta-test their cbo-enabled dictionary in preparation for ver 10 :-) I think they're pretty much there though - bucketloads of the recursive sql seems to be hinted nowadays, presumably to get it cbo ready. cheers connor

Re: bulk load of data

certainly sqlldr direct is the way to do until you could look at external tables in ver 9. The only advice I would add is that if you do go the external table route in v9, try get more benefit than just replacing sqlldr with some sql. I've seen a few places where they adopted external tables but

Re: Oracle Magazine excels itself

I agree wholeheartedly, the reason being (to share my own experiences), that some months ago I sent some feedback on an (unrelated) article in Oracle magazine because I thought much of it was incorrect. I got a reply from the author of the article basically agreeing with my points. Of course,

DeadLock: session wait on itself with no rows.

hi, friends: select count(*) into :b0 from USERCONFIRMINFO where USER_ID=:b1 The following deadlock is not an ORACLE error. It is a deadlock due to user error in the design of an application or from issuing incorrect ad-hoc SQL. The following information may aid in determining the

RE: multiple oracle homes

We do something similar to this, we created a series of scripts that use the oratab file to create a menu for the oracle id. this same proc is called when running batch jobs against the DB's by sending the DB name as a parm. -Original Message- Kirti Sent: Friday, February 28, 2003 10:15

V$ARCHIVED_LOG question

Oracle 9i has quite a few new columns added to the V$ARCHIVED_LOG dictionary view,however there is no documentation. For example, END_OF_REDO, ARCHIVAL_THREAD#,ACTIVATION# Any clues on what these columns mean. Thanks Murali DEST_IDTHREAD# SEQUENCE# END BACKUP_COUNT ARCHIVAL_THREAD#

Re: V$ARCHIVED_LOG question

Murali, I can offer some insight into the activation# column because I was interested in that too earlier. When a database starts, a new database instantiation id is given to that instance, presumably for the RMAN backups. This id can be seen from v$database under column activation#. So when you

Re: DeadLock: session wait on itself with no rows.

chao_ping, Read MetaLink Doc Id 166924.1. It offer some insights into this kind of Self Deadlocks. Here is an excerpt. QUOTE 1. Self Deadlocks It occur when one session tries to get a lock on a resource that he already has in some way. Normally, the Oracle engine should detect those situations

Datafile Resize Question

Hi all - I am trying to resize a datafile and have the following puzzler - I used the following query to get the list of tables that use this datafile and then use 'alter table ... move tablespace ' to move the tables to another tablespace. Now the datafile should be empty as indicated by the

RE: Datafile Resize Question

encoded content removed -- binaries not allowed by ListGuru The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender

RE: Datafile Resize Question

John - Your E-mail came to me as unreadable. If you have an answer to this, can you send plain text ? Thanks! Dennis -Original Message- Sent: Sunday, March 02, 2003 11:59 AM To: Multiple recipients of list ORACLE-L encoded content removed -- binaries not allowed by ListGuru -- Please

RE: Datafile Resize Question

Apologies - when I use MS Web Outlook, I can't change the mail format from rich text to plan text, so it attaches the winmail.dat garbage. Are your tablespaces, by any chance, locally managed with a large uniform extent size? I don't believe you can shrink the size of a datafile smaller than

RE: Datafile Resize Question

Thanks John. Actually it turns out there are a couple of small tables left in the tablespace that I missed in my query. After moving those outta there, I was able to shrink. Thanks Dennis -Original Message- Sent: Sunday, March 02, 2003 1:49 PM To: Multiple recipients of list ORACLE-L

Re: V$ARCHIVED_LOG question

The ACTIVATION# and ARCHIVAL_THREAD# columns are apparently used by Data Guard fetch archive log (FAL) processes to manage any logfile transfer gaps using the FAL_CLIENT and FAL_SERVER parameters on the primary and standby databases. Metalink note #150214.1 (Synchronization of primary and standby

[Q]terminating instance due to error 601

Hi folks , whats the meaning of error 601. The Database crashed with the following message in alert log -- Mon Mar 3 03:15:53 2003 PMON: terminating instance due to error 601 Instance terminated by PMON, pid = 1222 Platform Details-- OS - RH 7.1 Oracle - 8.1.6 TIA Tc -- Please see the

Re: [Q]terminating instance due to error 601

...take a look at the latest pmon_*.trc file in the BACKGROUND_DUMP_DEST... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, March 02, 2003 3:03 PM Hi folks , whats the meaning of error 601. The Database crashed with the following message

RE: [Q]terminating instance due to error 601

Teenu Here is the text from oerr. 00601, 0, cleanup lock conflict // *Cause: PMON process runs into lock conflict trying to recovery processes // *Action: This is trapped internally, no action necessary Was a trace file produced in bdump or udump? Dennis Williams DBA, 40%OCP, 100% DBA

Oracle Mag Bio

Congrats to Arup Nanda, whose bio appears in the latest issue of Oracle Mag. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: multiple oracle homes

Kirti, The next enhancement would be to execute script (from .profile) which will generate all aliases based on oratab. I use something like alias PRMT='. /usr/local/bin/oracle_setup.ksh PRMT' and /usr/local/bin/oracle_setup.ksh will source oraenv and do some additional customization. Alex.

Re: Oracle Mag Bio

Thanks for the compliments, Jared. Much appreciated. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, March 02, 2003 8:23 PM Congrats to Arup Nanda, whose bio appears in the latest issue of Oracle Mag. Jared -- Please see the

Re: What to check?

David, Have you checked the most obvious... The number of rows in the table? Also, you say three different Solaris8 machines... How different are they? Are the disk subsystems the same on all three? How identical are their configurations? How similar are the init.ora files on all three

RE: multiple oracle homes

Alex, Thanks for that idea :) - Kirti -Original Message- Sent: Sunday, March 02, 2003 8:04 PM To: Multiple recipients of list ORACLE-L Kirti, The next enhancement would be to execute script (from .profile) which will generate all aliases based on oratab. I use something like alias

RE: [Q]terminating instance due to error 601

Dennis,Tim - here are the trace files. Hmmm, the problem seems to be ORA-27303 //*Cause: OS system call error // *Action: contact Oracle Support :-O Thanks ! Regards, Teenu _pmon_1222.trc__ *** SESSION ID:(1.1) 2003-03-02 22:37:41.250 *** 2003-03-02 22:37:41.360

Threat to Fast exports

Please have a look at following note: 223399.1 having title ALERT: EXPORT with large BUFFER can silently produce a dump file with corrupted data. Looks like all major versions on all platforms are affected. Really scary one.. Rajesh -- Please see the official ORACLE-L FAQ: