How to number the retrieved rows
Hi! Is there a way to show a number in front of every row retrieved through a select statement...? select column1, column2 from tablename The output should look like: 1column1_value column2_value Any idea how I can achieve that? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Script to compare two schemas
Hi! Does anybody out there have a script to compare to database schemas and list the differences? I know this has been posted a few times, but I don't have the emails anymore and can't find anything in the archives... Sorry. This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-01489 result of string concatenation is too long
Hi! I'm concatenating two LONG columns (2800 characters each). I get an ORA-01489 result of string concatenation is too long Cause: String concatenation result is more than the maximum size. Action: Make sure that the result is less than the maximum size. Although the variables used are set as LONG, it seems that still the 4000 character limit (e.g. for varchar2) kicks in. Any iedas anybody? This is 8.1.6. on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
insert very long string of text into LONG column
Hi! How do I insert a very long string of text (about 200k in notepad) into a LONG column with a standard SQL insert command? What would be the best way to achieve this? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
What columns are in the Primary Key
Hi! Is there a data dictionary view that gives me all the columns in a primary key of a table? I can query user_constraints to find out about all constraints on a table: select * from user_constraints where table_name='TBACCOUNTS' OWNER CONSTRAINT_NAME C TABLE_NAME SEARCH_CONDITION -- --- - - VIVOUSER SYS_C003011 C TBACCOUNTS COMPANYID IS NOT NULL VIVOUSER SYS_C003012 C TBACCOUNTS STORELOCID IS NOT NULL VIVOUSER SYS_C003013 C TBACCOUNTS ACCOUNTID IS NOT NULL VIVOUSER PK_ACCOUNTS P TBACCOUNTS How can I get what columns are in the primary key PK_ACCOUNTS ? I have more NOT NULL columns in the table than in the PK. Any idea? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Order of columns in a table
Hi! How can I find out what the order of columns in a table is? If I do a select * from tablename, the columns appear in a specific order. The same order than they appear when I do a describe tablename. I can even do an insert without specifying the columns in my VALUES (.,) when they are in that specific order. How and where can I find the order of the columns within a table? Any ideas? Yhis is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Multi-Master Replication
Hi! I am currently working on a system architecture. We are thinking about using multi-master replication. I am pretty new to that area... Initially we will have three master databases replicating to each other. If we want to scale the system, can we easily integrate a fourth master database in to replication architecture? Is this doable? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
create second listener service on 2000/NT
Hi! How Do I create a second listener service on Windows NT/2000? Any ideas anybody? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Problems with 8.1.6.3.4 patch on NT/2000
Hi there! I have just installed the 8.1.6.3.4 patch on Win2k (i.e. upgraded from 8.1.6.3.0 to 8.1.6.3.4) and now the db is nor starting anymore. The Windows service starts, but it does not start the database. When trying to use oradim to start the db, I get some kernl32.dll error message etc. Weird things. Anybody else experiencing difficulties with the 8.1.6.3.4 patch? Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Service does not start
Hi! I'm having a problem with Oracle on Win2k here. I can't start Oracle by using the Management Console (i.e. start the windows Service). The Service remains in the status "starting" but never goes to "started". Then I can't even stop the service again. Not with the tool neither with the command line. I can start the database using SVRMGRL / SQLPLUS, but the Windows Service still doesn't start. Seems weird to me. Any ideas? This is 8.1.6.3.0 on Win2k Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Problem with database link
Hi there! I'm having a problem with database links here. I am on my SPEEDY database and want to create a link that points to another database called SAM. create database link SAM connect to user identified by pasword using 'SAM'; Then I try and issue that statement: select view_name from user_views@SAM * ERROR at line 2: ORA-02085: database link SAM.VIVONET.COM connects to SAM Where does our domain name appendix (vivonet.com) come from I looked in all the possible config files (e.g. sqlnet.ora etc.) and couldn't find anything. In both databases the init.ora parameter is set to global_names = true. Any idea? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Question abount Unique Keys
Hi! I have a question about unique keys: When I issue the statement CREATE UNIQUE INDEX UK_TBDOCUMENT ON TBDOCUMENT(DOCUMENTID) Oracle creates a unique index (as in user_indexes) but no unique constraint (as in user_constraints) When I issue that statement in a create table statement create table CONSTRAINT UK_TBDOCUMENT UNIQUE (DOCUMENTID) Oracle creates a unique constraint plus an index. Why is Oracle doing this? Could somebody please shed some light on this? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
inserting into DATE colum
Hi!
I have a question concerning inserting data in a DATE column. The deal is
that sometimes, I just wanna insert DD/MM/ and in other cases I wanna
insert DD/MM/ HH:MI:SS in the same column.
How can I handle that?
insert into TbTABLE values (To_Date('03/09/2001'), To_Date('03/09/2001'),
To_Date('03/09/2001'), To_Date('03/09/2001'),
To_Date('03/09/2001 11:11:11'))
Do I need to supply formatting information for the date to the insert
statement?
This is 8.1.6 on Win2k.
Thanks,
Helmut
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Helmut Daiminger
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Oracle license prices
Hi! Sorry to ask this question again, but I can't find the old thread that already discussed that topic several weeks ago. What is the Oracle license price per Power Unit? For Enterprise Edition and Standard Edition? Does th eoperating system matter? A power unit is MHz * 1.0 for Intel processors and MHz * 1.5 for RISC processors, right? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unable to extend TEMP tablespace
Hi there! I'm experiencing strange errors on our production database in the middle of the night. From the alert log file: Mon Apr 09 03:41:33 2001 ORA-1652: unable to extend temp segment by 64 in tablespace TEMP The deal is that nobody is accessing our system at 3:40 am! No jobs are scheduled for that time. Basically there shouldn't anything go on on the server. Is there a way that I can find out what causes this error? What user / statement is generating so much temporary data? Is there a way to coalesce the TEMP tablespace so that orphan temp segments get deleted and the usage of the TEMP tablespace isn't always up to 99%? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Database / OS monitoring tool
Hi! What software is available that can be used for database and operating system (NT/2000) monitoring? It should be capable to email/page administrators in case a Windows service fails or Oracle crashes or the like. Is anybody out there using software like that? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: killing a thread
Hi! ORAKILL is only available on Windows NT/2000. Because Oracle uses a thread based architecture on Windows and all threads run within the same "oracle.exe". On UNIX, Oracle is process based and you can kill the corresponding process. hth, Helmut -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gene Sais Sent: Thursday, April 05, 2001 02:07 PM To: Multiple recipients of list ORACLE-L Subject: RE: killing a thread I can't find it either. Is the script you meant? $ORACLE_HOME/network/agent/jobs/oracle/cmanager/general/killsess.tcl [EMAIL PROTECTED] 04/05/01 12:16PM I didn't see this in my $ORACLE_HOME/bin. Is this platform specific? -Original Message- Sent: Thursday, April 05, 2001 1:00 AM To: Multiple recipients of list ORACLE-L There is a utility called orakill, this will kill the session. U can find the executable in $ORACLE_HOME/bin directory. This is very useful utility. Try it. -- On Wed, 04 Apr 2001 12:36:08 Kevin Kostyszyn wrote: did you try alter system kill session immediate? -Original Message- Eric Sent: Wednesday, April 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Is there a way to kill (other than kill session) a thread that is doing an insert - nologging? I have tried "alter system kill session" to no avail. It gives me the message "marked for kill" but the process continues to hang. The process has a row exclusive lock with a lock type of TM(dml). There are no rows in the table that is being inserted into. Any ideas? Thanks, Eric -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chesebro, Eric INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! at Lycos Mail http://mail.lycos.com/freemail/vistaprint_index.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be rem
Compare tow schemas
Hi! I know there has been a thread about this topic recently, but I can't find the emails... And the archives don't have them either. Does anybody have a script to compare two schemas and show the differences? I know that I can do it with TOAD, but I would need the script anyway. Sorry for the inconvenience! This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Update two columns in a single update statement
Hi! Can I update two columns in a single update statement? What is the exact syntax for this... update tablename set col1,col2 = 45,33 Just like in an insert statement, you would go insert into (col1,col2) values (45,33) This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Problems with export/import
Hi! I'm having weird problems with exporting/importing tables... First I run an export on database A About to export specified tables via Conventional Path ... Table(T) or Partition(T:P) to be exported: (RETURN to quit) tbclocktimes . . exporting table TBCLOCKTIMES 2929 rows exported The exports terminates successfully without warnings. Then I want to import that dump file into database B, but it fails: . importing VIVOUSER's objects into VIVOUSER . . importing table "TBCLOCKTIMES" IMP-00058: ORACLE error 1403 encountered ORA-01403: no data found Any idea what's going wrong? This is 8.1.6 on Win2k Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Update existing rows at import
Hi! Is there a tool available that allows me to read data from a comma-delimited flat file into Oracle and if a row already exists, updates that record. If the row does not exist, it should insert a new record into the table. Looks to me like SQL*Loader can't do this. How could this be done? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Import comma-delimited text file into Oracle
Hi! Is SQL*Loader the only way to move the contents of a comma-delimited ASCII file into Oracle? UTL_FILE would be another option, right? Or are there any other ways to do this? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Anybody using Network Applicance Storage boxes with Oracle?
Hi there! Is anybody out there running Oracle on NetApp Storage Networking box? I was told by some NetApp guys that using their boxes we don't have to worry about distributing datafiles, RBS etc. across the disks because the NetApp OS takes care of all that. Any comments? Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Using OLE DB connection
Hi there! I have a question concerning the usage of the Oracle OLE DB provider on Win2k. We have a web server (running on Win2k) with a bunch of COM+ objects on it that are connecting to an Oracle database. The connection is made through the Oracle OLE DB provider 8.1.6.2.0. Does anybody have an idea what the performance overhead is when using OLE DB instead of using native Net8? Is it significant? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Send Email on NT/2000
Hi! For all guys running Oracle on NT/2000: I found this nice little tool that you can e.g. use to have the alert log file mailed to you. I also run a tablespace usage script that writes the results to a txt file. Then I use automailer to mail me that file. Check it out: http://www.duodata.de/automailer/ AutoMailer automatically transfers files as email-attachments. The files you wish to be mailed must be stored in a single directory on your hard drive. AutoMailer periodically polls this directory for changes and if a new or modified file is found, it is mailed. hth, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Using OLE DB connection
Hi there! I have a question concerning the usage of the Oracle OLE DB provider on Win2k. We have a web server (running on Win2k) with a bunch of COM+ objects on it that are connecting to an Oracle database. The connection is made through the Oracle OLE DB provider 8.1.6.2.0. Does anybody have an idea what the performance overhead is when using OLE DB instead of using native Net8? Is it significant? This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Insert data into LOB column
Hi!
I am new to working with LOBs. I want to insert data (through
SQL or PL/SQL)
into a table that looks like this:
column1 varchar2(100)
column2 BLOB
column3 number
How can I insert data into that table directly?
insert into table (column1, colum2, column3) values ('sample
text', ?, 12345);
The BLOB can be a TXT-file or GIF-picture or bmp-picture. The file is
locally stored on the hard drive.
This is 8.1.6 on Win2k.
Any ideas?
Thanks,
Helmut
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Helmut Daiminger
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
