Re: Oracle 9.2 Stability Feedback Requested

All the bugs? Possible? Perhaps... Reality? Nope. The crippling bugs with SMU appear (at first glance) to be fixed in 9.2, but there is no shortage of other bugs. The first one I found was with many queries against the data dictionary being 70-180 times slower! I'm running 9.2.0.1 on Linux

Re: Senware AutoDBA

That was truly a disaster of a session. I, and the small group I was with, left almost immediately. I was on the sundeck for the post-mortem though and even have a nice picture of Gaja discussing (emphasis on "cuss") it with Stan. I believe the presenter was the CTO, but I'm not sure. I have b

pls-00553 when 'Set Serverout On' in glogin.sql

(reposting) -- List, Are we not supposed to 'Set Serveroutput On' in the glogin.sql file? If the parameter is set in glogin.sql, I'm getting the following error when using DBMS_OUTPUT in pl/sql SQL> Create or Replace Procedure TEST1 as Begin DBMS_OUTPUT.PUT_LINE('TEST'); End; C

Shutdown Immediate Hanging

Title: Message I hope somebody can help me with this  shutdown problem. There's 2 questions unless: how to troubleshoot a stalled shutdown and the best way to deal with it.   #1 - Database hangs during shutdown We have several instances running 8.1.7.3 on Win2k and continue to have intermit

SunFire v100

Hello everyone. Just want to ask if anybody tried to use a SunFire v100 as a database server. I was told this is a headless server, but otherwise, very similar to any other sun servers. Looks like an oracle database on this baby can work enough as a development server. Would like to get anybody's

RE: drop tablespace including contents

I had one experience with an ERP, since then I'm avoiding those contract. Developping a system is so much more interesting in my point of view. Unfortunately there is more and more ERP sold :-( --- "Brooks, Russ" <[EMAIL PROTECTED]> a écrit : > Yeah, that's what I do too. I just wish it wou

Re: how to reduce SQL*Net more data to client wait event

"SQL*Net more data to client" (as opposed to "from client") seems to indicate that flow is from server to client, which doesn't seem appropriate for SQL statements... - Original Message - From: Johnson, Michael To: '[EMAIL PROTECTED]' ; 'Tim Gorman' Sent: Wednesday, Aug

PLSExtProc

PLSExtProc - found in listener.ora and tnsnames.ora - it's got to do with interMedia. What else is it good for? Is this really necessary for an Oracle Database to function? Thanks for any tips. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL

off topic - How to find used and free capacity on a DLT IV tape

Hello Guys, I am testing some backup scripts on a dlt library and trying to run manual backups. mc -p /dev/dltrobotics -s S15 -d D1 backup -f /dev/rmt/4m -i /prod1 -v Is there any easy way (other than keeping track of files being copied to tape) to find out space left on the tape(uncompressed/

RE: Senware AutoDBA

you are being kind. I was there, and was amazed that Gaja was as calm as he was before he walked out. I think we scared the next speaker (also on this list) with the venting we ALL did. I did try to correct something the speaker said by asking a question with the correct answer in the question.

RE: how to reduce SQL*Net more data to client wait event

thank you.   mike -Original Message-From: Anjo Kolk [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 1:09 PMTo: Multiple recipients of list ORACLE-LSubject: Re: how to reduce SQL*Net more data to client wait event No,   this is "to client", so it is the resul

RE: Cannot start database -- RESOLVED!

I think 'startup force' would have worked as well. -Original Message- Sent: 22 August 2002 07:29 To: Multiple recipients of list ORACLE-L Thanks Scott,Mike,Kevin, and Ruth. I was so shocked to see the "database running" message (when I knew it was not) that I didn't try the obvious. shu

Has anyone used Note 77335.1 (TCP Tuning for Oracle Application S

Hi all, As above... I am looking at opportunties to tune up a 9iAS W/server (for the ERP application from your favorite vendor). John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointments are inevitable in Life, but discouragement is optional. You decide! ** The opinio

RE: Catching errors on inserts[SOLVED!]

This was solved by the knowledgeable Charlie Mengler of the list The problem was the "=" SQL> alter session set events='0001 trace name errorstack forever,level 10' ; Took that off and it generated me a 14M trc file!! Not pretty but it worked Thanks to all who helped with this Best re

RE: Install Pro*C

Ron, I believe you need to install the pro*c compiler from the installation disks, but it is on the client option. Bryan -Original Message- Sent: Wednesday, August 21, 2002 5:44 PM To: Multiple recipients of list ORACLE-L Someone forgot to install Pro*C on our 8.1.7 Sun server. I nee

RE: Analyzing a Trigger for Performance: Ok for Now

Hi All, I'm going to take some time now to look into the DBMS_PROFILER and DBMS_TRACE packages. They have been suggested by several people. So, I may repost later when I get a better hanlde on them. Thanks, Hannah > -Original Message- > From: "Aponte, Tony" <[EMAIL

RE: Analyzing a Trigger for Performance - Ok for Now

Got enough info to start looking around. I am using a third party replication tool , so that's won't be an issue. Thanks for all the replies. Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-50

RE: Analyzing a Trigger for Performance

Make a dedicated server connection, execute the following statement alter session set events='10046 trace name context forever, level 10'; and ship the resulting trace file to Cary. More about the details on http://www.hotsos.com > -Original Message- > From: [EMAIL PROTECTED] [mailto:[E

Install Pro*C

Someone forgot to install Pro*C on our 8.1.7 Sun server. I need to install it. Is there anything that needs to be done after I run the installer? Thanks! R Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network

RE: Analyzing a Trigger for Performance

Title: RE: Analyzing a Trigger for Performance Hi Hannah, Have you looked into the DBMS_PROFILER and DBMS_TRACE packages?  They can be used to trace PL/SQL execution and performance.  Tony Aponte Home Shopping Network, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[E

Re:RE: Senware AutoDBA

OK, Since we're into a discussion of the pro's and con's of AutoDBA, My basic problem with it is that I really don't like software that tries to "fix" things based on it's idea of the perfect world. Sure I appreciate the scripts, but leave it to me to run them at a time that is more advantageous

Cannot start database -- RESOLVED!

Thanks Scott,Mike,Kevin, and Ruth. I was so shocked to see the "database running" message (when I knew it was not) that I didn't try the obvious. shutdown abort did work. And that caused the semaphore to disappear. I do have an lkDESI file in $ORACLE_HOME/dbs, but I don't have access to see it (l

RE: PL/Sql question

Tom - The developer reports that he tried this but it didn't work. The third position is still a space value. Thanks to everyone for the good replies. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 21, 2002 3:13 PM To: '[EMAIL PROTECTED]

Re: Analyzing a Trigger for Performance

If the trigger does DML, check that it's written to not fire for replicated transactions, just local ones, using DBMS_REPUTIL.FROM_REMOTE. [EMAIL PROTECTED] wrote: > > Hi, > > I had noticed that one of our triggers is performing very badly. I had disabled the >trigger to test replication a

RE: PL/Sql question

Dennis, Try changing your insert statement to: insert into JOBOFFERFACT_LOAD (LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID, MARKETINGCODE, TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME, PACKAGEPRICE, PAIDPACKAGE

RE: :STATEMENT

Title: Message Yes, I thougt the same thing... here is a site that will give clear direction of installing modules   http://perl.about.com/library/weekly/aa030500a.htm   They cover ppm and  perl -MCPAN -e shell     check out all the links on this page  bob 

RE: Catching errors on inserts

Ok Im having a problem with this [from init.ora] user_dump_dest = D:\db_track2data\admin\LTRACK2\udump [recommended from a user on this list] select name, value from v$parameter where name like '%dump%' ; NAME VALUE -

Re: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux

Dharminder, You will need the 9i disks for RedHat and then create a database on the Linux box and export the data or "insert as select" from the Win 2000 database. There is no simple method of going across platforms. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 08/21/02 04:24PM >>> I want to move the

Analyzing a Trigger for Performance

Hi, I had noticed that one of our triggers is performing very badly. I had disabled the trigger to test replication and there was a issue with the trigger. When the developer changed the trigger and enabled it, replication slowed down to one record per second (other tables are being updated,

Re: FW: PL/Sql question

Geez, after re-reading my post, it seems that it didn't make much sense to me, so to clarify... I had a cursor in my procedure that took as an IN param a varchar2 variable. The cursor failed to return any rows because in my where clause I was comparing a char field against a varchar2 variable.

RE: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux 7.

Kumar Ummm . . . are you using any 9i features? I'm assuming you have considered using 9i on Red Hat. Sounds like probably use the 8i export function to create the export file. I'm assuming the data involved is small enough to make export/import practical. If you create a Net8 connection, you

RE: Index move

Seema - My interpretation of your question is that you are asking whether having the indexes for a table on a separate physical would increase performance. Since this was a standard recommendation for many years, I feel it merits a more detailed reply. If you have an OLTP benchmarking situatio

Re: double quotes column name

You missed the 'or' in my sentence. Maybe I should use || ? ;) Jared "Marul Mehta" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/21/2002 01:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:

Re: Catching errors on inserts

udump directory Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 21, 2002 2:43 PM > It is in the session trace file not the alert log file. > Where would I find this file? Many tha

RE: Cannot start database (already running)

Or go into svrmgrl, connect internal, issue a shutdown abort, then startup. Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: Hately Mike [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, August 21, 2002 2:04 PM > To: Multiple recipients of list ORACLE-L > Subject:

RE: Senware AutoDBA

I'll add to John's comments. It took John, Kirti & myself to keep Gaja calm during the presentation. Once we all walked out, Gaja went outside and vented. Their solution is unusual as they believe that performance can optimized by adding hardware to the solution. Thank You Stephen P. Karnioti

Moving Oracle 9i / Windows 2000 Database to Red Hat Linux 7.1 / 8.1.6

I want to move the Windows 2000/ Oracle 9i database to Linux Red Hat 7.1/ Oracle 8.1.6. Please suggest the options. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharminder Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

Re: FW: PL/Sql question

um...just a thought but how about setting marketingcode to char(3) in the PL/SQL code snippet. I ran into this similar problem a couple days ago. Had a var as varchar2 in PL/SQL but in the table it was char. Changed my PL/SQL var to char, cursor in my code worked with ltrim and rtrim functions

Re: Catching errors on inserts

check your init.ora setting for user_dump_dest (I believe). Anjo. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 21, 2002 8:43 PM > > It is in the session trace file not the alert log file. > > > > Where would I find this

Re: Cannot start database (already running)

Did you try shutdown abort? That should do it. But remember to startup restrict, shutdown normal, startup to allow smon to do his thing. HTH< Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 21, 2002 2:33 PM > > Oracle 8.0

RE: drop tablespace including contents

Yeah, that's what I do too. I just wish it wouldn't clobber the stats on the indices after I've so carefully gathered them. We have the 6.2 sapdba, so I don't think it's using dbastatc as much to control when and how it does the stats. Russ -Original Message- Sent: Wednesday, August 21

Re: double quotes column name

I guess this is not the case. 1. create table t("TABLE" Varchar2(10)); 2. select table_name,column_name from user_tab_columns where table_name='T'; TABLE_NAME COLUMN_NAME -- -- T

RE: :STATEMENT

Point taken. I'll redirect the question. Russ -Original Message- Sent: Wednesday, August 21, 2002 1:53 PM To: Multiple recipients of list ORACLE-L It looks like there's a number of people on this list that could benefit from subscribing to the Perl DBI list: http://lists.perl.org/sh

Re: how to reduce SQL*Net more data to client wait event

No,   this is "to client", so it is the result of a query (either to many columns or too many rows returned). Large SQL statements would result in "from client" during the Parse phase and if people keep on parsing the same statement, the client side will keep on sending it to the server. Pars

RE: List of all zip codes,city,state to load into table.

The USPS department called AMS (Address Management Service) sells this data in subscription format - we get it monthly. Don't know cost, and data is provided in ascii file that you the load into a table of your design. We use SQL Loader for the piece we need and it loads (with truncate existing

RE: Cannot start database (already running)

Barb, check for an LK file in your $ORACLE_HOME/dbs directory too. If it's there, delete it. Just another thing to try. Regards, Mike Hately -Original Message- Sent: Wednesday, August 21, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Oracle 8.0.5 Solaris 2.6 HA Cluster 2.1

Cannot start database (already running)

Oracle 8.0.5 Solaris 2.6 HA Cluster 2.1 This is wacky. Any ideas on this one (other than reboot the box)??? I cannot start up this database (claims it's already running). Clearly it is not. No background processes for this instance. The only process I see even remotely related to this database

RE: Senware AutoDBA

FWIW, someone from Senware presented a paper at IOUG 2002 titled 'Performance management from the ground up' (or somthing like that) which was a load of &*$% to say the least. Most of the audience (many on this list) walked out in disgust after the first 10 minutes (Does someone remember the '

RE: Catching errors on inserts

> It is in the session trace file not the alert log file. > Where would I find this file? Many thanks in advance bob > Anjo. > > > On Wednesday 21 August 2002 16:38, you wrote: > > Gogala > > > > Thanks for the tip this seems like just what I'm > looking for, however > > I must be doing

RE: drop tablespace including contents

Mike, I've made the pitch before and will again. Wish me luck. Russ -Original Message- Sent: Wednesday, August 21, 2002 11:39 AM To: Multiple recipients of list ORACLE-L Russ, You have my sympathies. I've been managing SAP databases for the last 7 years, and the last time I let SA

RE: PL/SQl question

I believe it is acting appropriately. You are trying to load a two-"character" byte filed into three-byte "character" field. Loader, if you don't terminate by whitespace or nulls, will add the blank into the field because it is character. Thus, you have two options: 1. Change the field to num

RE: dbms_utility and dbms_stat difference

Hi Cherie, > I can't speak for dbms_utility but dbms_stats is supposed to generate > statistics at both the partition level and at the table level for > partitioned tables, which analyze does not do. A small correction, ANALYZE also generates statisics at partition level and when an "analyze

RE: how to reduce SQL*Net more data to client wait event

Tim,   more specifically could large SQL have been passed across the net ?   Stored procedures could help here.   FWIW.   Mike -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 12:03 AMTo: Multiple recipients of list ORACLE-LSubject:

RE: simple problem

Yup, exactly that's what I meant. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but havin

Re: double quotes column name

> how can we know that this table is created with "" column name When the column name is a reserved word, or appears with lower case characters. Jared "Harvinder Singh" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/21/2002 09:28 AM Please respond to ORACLE-L To: Multiple

UTF-16

So I set NLS_LANG to AL16UTF16? I'd like the note to be more explicit. I thought that would be the value to which I would set the "character set" argument of the create database command. The two are not the same. For instance the "character set" argument of the "create database" might be

RE: :STATEMENT

Title: Message Thanks Bob.  I thought if you pulled the module through ppm that was not necessary.   Russ -Original Message-From: Bob Metelsky [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 11:24 AMTo: Multiple recipients of list ORACLE-LSubject: RE: :STATEMENT

Oracle Applications Hanging

Hi All, I'm using 11.0.3 with 8.0.5 on Windows NT SP4 Every once in a while, the users complain that they cannot login into the applications. At that time I observe that the process WWWLSNR30.exe in the application server is taking too much of CPU(more than 50%). No matter how much time I wa

Re: Encryption of data

But the data would be *very* secure. Jared "Tim Gorman" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/21/2002 12:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Encryption of data I im

Re: Senware AutoDBA

Interesting web site. They claim to eliminate chained rows by rebuilding the tables. I'd like to see how they intend to do that. They also claim that their product can detect corrupt indexes and rebuild them. How hard can it be to detect ORA-1578? This kind of thing is fairly rare, and hardly s

RE: DBA tools on NT - PERL

Bob, I don't have mine either. :( My editor just received a copy on Monday, so they have been printed, and should be shipping now. Jared "Bob Metelsky" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/21/2002 08:23 AM Please respond to ORACLE-L To: Multiple recipients of

RE: Odbc and reserve words

How about defining a view? I know you can escape individual characters but I don't think you can do a whole string. -Original Message- Sent: Wednesday, August 21, 2002 9:49 AM To: Multiple recipients of list ORACLE-L Hi, One of our client has a table with column name "access". Since a

Re:drop tablespace including contents

Ironically, analyzing tables is one of the jobs I leave up to SAPDBA. There are a number of tables that shouldn't be analyzed, ( ~150 on my system ) and the system knows which ones they are. Just schedule the job through transaction DB13 and forget about it. Jared paquette stephane <[EMAI

RE: Cannot start database (already running)

Follow your instincts. Use ipcrm and clear out those shared memory segments. Then it should start OK. -Original Message- Sent: Wednesday, August 21, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Oracle 8.0.5 Solaris 2.6 HA Cluster 2.1 This is wacky. Any ideas on this one (

java.sql.SQLException: Io exception: Connection reset by peer: so

Hello List, Does anybody there know the following error message and how to resolve it? java.sql.SQLException: Io exception: Connection reset by peer: socket write error Environment classes12.zip Oracle 8.1.6.3 Solaris 2.8 Thanks, Mike *

RE: List of all zip codes,city,state to load into table.

Interesting. Apparently, my ZIP in a city of 24K people didn't make the list. I guess you get what you pay for. :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Wednesd

RE: simple problem

Raj, Is this what you meant and what you would get? SQL> get 1 1 select m.id, cast(multiset(select fname 2 from t s 3 where s.id = m.id) as mystrtype) as fnamelst 4 from t1 m 5* group by id SQL> / ID FNAMELST -- -

RE: PL/SQl question

Check the definition of table C. It sounds like it is defined as CHAR(3) instead of VARCHAR2(3). I would also check the PL/SQL for using CHAR instead of VARCHAR2 for storing the value -- the trim should have eliminated this problem if it was put in the right place. Kevin Kennedy First Point

RE: drop tablespace including contents

Thanks Dennis, Yeah, I know how to do the work without the tool, using sqlplus. That's not the problem. Management won't even allow us to use OEM for maintenance tasks, only sapdba. My hands are tied, at least for the moment. Russ -Original Message- Sent: Wednesday, August 21, 200

RE: Oracle 9i Application Server question

Shirley, it sounds like you're hitting bug number 1965439. It occurs because the 9i database is installed when you try to install 9iAS. It's allegedly fixed at 1.0.2.2.2. There doesn't seem to be a patch available. Regards, Mike Hately Oracle DBA -Original Message- Sent: 21 August 2002

FW: PL/Sql question

In response to the questions for more details, here are the PL/SQL code and SQL Loader control file. Everything is varchar2(2), explicitly defined as such in PL/SQL. Thanks for all the nice replies. PL/SQL snippets <...snip...> marketingcodeVARCHAR2(3); <...snip...> FILELOCATION :

RE: Odbc and reserve words

Harvinder You've made my day! I have always fought developers on issues like this. My advice would be for you to use this situation to get the column name changed. I predict that this column will continue to cause you grief. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original

RE: Win2000/8.1.7.3.0/SQL

John - It is available at http://www.hotsos.com/catalog/ Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 20, 2002 7:09 PM To: Multiple recipients of list ORACLE-L Mike, Just one more thing to check before you close this: Can you run a 10

RE: double quotes column name

Harvinder, The column won't be created with a quotation mark as part of its name. Oracle won't allow it. All the quotation mark does is allow the creation of the column in the first place, circumventing the syntax rules. This is not a good thing. I'll lay good odds that it causes problems somewhe

RE: :STATEMENT

It looks like there's a number of people on this list that could benefit from subscribing to the Perl DBI list: http://lists.perl.org/showlist.cgi?name=dbi-users Jared "Bob Metelsky" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/21/2002 08:23 AM Please respond to ORACLE-L T

RE: List of all zip codes,city,state to load into table.

As long as you don't need current data. This page says the file was last updated Jan 8, 1997. In my personal contact manager, I'm still using one I downloaded from quite some time ago. Unless you need real current data, the price is right. (Send the guy $10 though) Stephen >>> [EMAIL PROTEC

RE: drop tablespace including contents

Russ - A couple of ideas for you. 1. Check directly in Oracle before you perform a task with the tool. And check afterward to verify what the tool did. This will make you a better DBA. And in a future job interview, you'll have a more interesting conversation than just saying "duh the only way I

RE: Reasons to upgrade from Oracle 7.3.4 to 8i - DONE

Thanks a lot to all who replied ! The upgrade issue is postponed by the customer ;-( Apparently they'll need to upgrade the O/S as well (they currently use Digital 4.0d , while the earliest version Oracle8i OPS is certified on is 4.0e, and 9i RAC is supported on 5.*). So , now the customer should

RE: Reasons to upgrade from Oracle 7.3.4 to 8i

Yes ,that would be one of my favorite points , but the backup is done by EMC BCV split at the OS / storage level, i.e. this is not an argument too ;-( DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Monday, August 19, 2002 6:28 PM To: Mul

RE: Odbc and reserve words

Harvinder, Why do you want this grief? I would do everything in my power to convince the client to rebuild the table with a different column name. To the best of my knowledge, you have locked yourself into a situation requiring the double quotes. I don't know of any way around it. Maybe som

Re[2]:=?iso-8859-1?Q?A_friendly_reminder_-_AutoDBA_webcast_8

To all, I too often allow the dark side of my personality to rule uncontrollably. The previous e-mail on this subject/vendor was a manifestation of that dark side. I would like to apologize to all for the rantings that were expressed. Please be so kind as to delete the message & flame/cens

Re: Catching errors on inserts

It is in the session trace file not the alert log file. Anjo. On Wednesday 21 August 2002 16:38, you wrote: > Gogala > > Thanks for the tip this seems like just what I'm looking for, > however I must be doing something wrong as no errors are getting written > to my alrt.log > > Im running

Re: Oracle 9i Application Server question

When you say "Oracle 9i Release 1 (9.0.1) and Oracle 9i Application Server version 1.0.2.2.0 " are you installing the two different products into the same ORACLE_HOME ? They have to be seperate Oracle_Homes. 9iAS 1.0.2 is not built on 9.0.1 libraries, it is on 8.1.7 libraries. I believe that y

RE: double quotes column name

Harvinder, The columns created with double quotes show as such in user_tab_columns, i mean they show the name in the same case so... NameDisplayed "Access" - Access "ACCess" - ACCess and so on. and when u query the table use select "Access" FROM. Naveen -Original Mes

RE: :STATEMENT

Title: Message Did you run the perl makefile.pl   cd dir\downloaded\fromppm\eg\.cpan\source\mymodule   make make test   make install     For win32 you have to download and use nmake from microsoft   bob     Hi,   Has anyone played with Perl's SQL::STATEMENT?  I pulled it down with

double quotes column name

Hi, One of our clients has created a table with column name "access" since access is reserved word , they use double quotes. but when i query the table user_tab_columns it is still showing column name as access and not "access" how can we know that this table is created with "" c

RE: Oracle 9i Application Server question

Shirley - By any chance is this a Pentium 4 system? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 21, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Dear List, I am trying to install Oracle 9i Release 1 (9.0.1) and Oracle 9i A

iAS 1.0.2.2.2 and ssoxlad.so an ELF32 instead of ELF64

hello listmates we installed on a first solaris 8 a database 9.2.0.1.0 and on a second iAS 1.0.2.2.2 - it worked fine, until we decided (out of necessity) to configure portal for ldap authentication. the problem is: we have a file called "ssoxldap.so" which is a ELF 32-bit - but we need one

Re: List of all zip codes,city,state to load into table.

Have you check the USPS web site? RBG - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, August 21, 2002 9:13 AM > Hi All, > > Where can I get a list of all zip codes,city,states to load into a table. I > have searched but cannot find an

RE: double quotes column name

This is not a guaranteed method, but the fact that 'access' is stored in the data dictionary is an indicator that they used "" to force the name. Anytime you see lowercase, you can assume that they used "". Of course, if the created it as "ACCESS", my method won't work... Dan Fink -Original

RE: PL/SQl question

Dennis, In your PL/SQL program, did you try the RTRIM(date_field,' ') command? I know that TRIM is new, but I thought it needed additional parameters to tell it what to trim. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, August 21, 2002 10:28 AM To:

RE: dbms_utility and dbms_stat difference

Barbara, I can't speak for dbms_utility but dbms_stats is supposed to generate statistics at both the partition level and at the table level for partitioned tables, which analyze does not do. These are supposed to be better quality statistics. Be aware that there are bugs related to dbms_sta

RE: dbms_utility and dbms_stat difference

Is there an advantage to either of these over "roll your own" (select 'analyze table ' || table_name|| 'compute statistics')? (Besides ease of use.) Since I already have the scripts in place that run the analyze statmement, I'm wondering if it's worth the effort to change the jobs to use dbm

RE: List of all zip codes,city,state to load into table.

Rick, You can purchase what you want from the USPS for something like $300. I have never seen it free. http://www.usps.com/ncsc/ Cheers, Thom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farrell, Thomas M.Mr. NGB-ARNG INET: [EMAIL PROTECTED] Fat City Network Ser

Re: PL/SQl question

Is the field in question in table C defined as CHAR or VARCHAR2? If CHAR that is why it is blank padded. Check datatype of variables in pl/sql Rick DENNIS

RE: PL/Sql question

Sounds like in the table the field c.marketcode is a char(3) instead of varchar2(3). Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of

RE: drop tablespace including contents

Russ, You have my sympathies. I've been managing SAP databases for the last 7 years, and the last time I let SAPDBA control a reorg was 6.95 years ago. It performs some tasks reasonably well, like datafile additions and managing CBO statistics refreshes (especially since SAP wants certain tables

Re: List of all zip codes,city,state to load into table.

Sure, please send it :-))) RC Jan Pruner <[EMAIL PR

RE: List of all zip codes,city,state to load into table.

Rick - I think Barbara is right, to get the info in bulk you'll probably have to pay. A few years ago a friend of mine got a diskette from the U.S. Post Office that was intended to get bulk mailers to use 9-digit zip codes. Might be worth a check. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECT

RE: List of all zip codes,city,state to load into table.

I've heard good things about Quick Address over here in the UK, and see that they may have a US version as well: http://www.postcode.com/us/ HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127

  1   2   >