RE: ORA-12638: Credential retrieval failed URGENT!!!!

Look in C:\oracle\ora81\network\admin\sqlnet.ora for the line SQLNET.AUTHENTICATION_SERVICES= (NTS) This is why Oracle is trying to retrieve user information from the domain. I ran into this when I had a laptop plugged into the network, and I installed Oracle onto it, then tried to access Oracl

Re: advanced replication

Ray, Any kind of replication is a nightmare (oops, challenge!) to administer. Oracle, Quest, EMC, homegrown, whatever. As you add more schemas and objects to the equation you'll need at least person dedicated to it. As for the advanced replication manuals, hmm. The 8i set has 2 - "Oracle8i Repl

RE: A Question on the Basics of PL/SQL

Oracle Corporations Coding Rules 1. The use of functions to return more than one "value" is strictly forbidden though encouraged nevertheless 2. Quod licet jovi. Non licet bovi (What's okay for

SAP Interview Questions

We are looking to hire an SAP Systems Analyst. Can anyone suggest some good questions/answers specific to SAP? I have seen lists of Oracle interview questions so I was wondering if anyone has seen any on SAP? Or, if you just know some good questions/answers, please send them to me. Thanks. --

RE: 9i Open Day (UK Listers)

mais non. Oracle HQ Thames Business Park in Reading. http://www.oracle.com/uk/start/9iopenday Regards Lee -Original Message- Sent: 29 June 2001 14:52 To: Multiple recipients of list ORACLE-L I am sure lots of people will want to meet you now that you have annnouced to the list that

advanced replication

I was beginning to think advanced replication looked like a reasonable solution for an applicaiton. Then I read: Replication environments supporting both multimaster and snapshot replication can be challenging to configure and manage. To help administer these replication environments, Oracle pr

RE: Why are my indexes being ignored?

I'm returning 117 rows. Bill Carle AT&T Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Friday, June 29, 2001 9:50 AM To: [EMAIL PROTECTED]; Carle, William T (Bill), NLCIO Subject:Re: Why are my indexes being ignored? "Carle, William T (Bil

Re: Why are my indexes being ignored?

What is the sql statement that you are executing against this table? Carle, William T (Bill), NLCIO wrote: >Hi, > >I created an index on a table. The table has about 83,000 rows. The >index is a simple index on one field, 35 different values of the index. I >analyzed the table and I analyzed

Two indexes same columns

If there is a primary key on a table (which inherently builds an index), is it still necessary for performance to build a seperate index on the same columns as those identified in the primary key or is the index generated by the primary key sufficient? -- Please see the official ORACLE-L FAQ: ht

db file sequential reads

Hi all, We have SAP application runing on a machine and Oracle 8.1.6.2 instance on an other, the two machines are connected to a gigabyte network. time response of the requests from SAP to Oracle is very long. We investigated with utlbstat and utlestat and we found that we have too much waits o

Why are my indexes being ignored?

Hi, I created an index on a table. The table has about 83,000 rows. The index is a simple index on one field, 35 different values of the index. I analyzed the table and I analyzed the index, trying it both with a histogram and without a histogram. No matter how I do it, it does a full table s

RE: java stored procedures very slow

What about the JAVA_POOL? Never put java in to practice myself, but it may be a place to start.. Mark -Original Message- Sent: Friday, June 29, 2001 01:20 To: Multiple recipients of list ORACLE-L We suddenly seem to have a problem with java stored procedures running very, very slow. T

Re: authid definer

Mark, If I understand this message, you believe that the users of the procedures need direct table grants to use the packages. If so, that is incorrect. Only the owner of the procedures needs the direct grants. The users of the procedures only need execute privileges on the procedures. A goo

MetaDink Returns

Maybe because it's Friday? Fri, 29 Jun 2001 14:10:44 GMT ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at "SURE.SURE_API", line 1291 ORA-06512: at "METALINK.ML2_DOCUMENTS", line 324 ORA-06512: at line 7 DAD name: plsql PROCEDURE : ml2_documents

Re: A Question on the Basics of PL/SQL

Jared Still wrote: > > On Thursday 28 June 2001 18:01, MacGregor, Ian A. wrote: > > Here's a line from the package header for dbms_standard: > > > > function dictionary_obj_name_list (object_list out ora_name_list_t) > > return binary_integer; > > > > The function returns both a b

Re: SGA QUESTION

> > 200MB? I realize simply adding memory is not the solution for fixing a > > poorly tuned database, but on the other hand, if you have a lot of memory > > why not use it? > > > > - Greg -- > Hi Jared, > I think like Greg . Why not use 2-4 gb of 8 gb memory for SGA. ? > If It has bad

Re: audits

Bill, Auditors are likely folks originally trained as accountants and CPA's. This reminds me of the days when I fixed computers for a living. The bean counters decided that $0.25 per board could be saved in manufacturing by not putting test points on the boards. ( A pin soldered to the board

Re: A Question on the Basics of PL/SQL

On Thursday 28 June 2001 18:01, MacGregor, Ian A. wrote: > Here's a line from the package header for dbms_standard: > > function dictionary_obj_name_list (object_list out ora_name_list_t) > return binary_integer; > > The function returns both a binary integer and a table of varchar

RE: OT RE: 24 x 7 on NT?

Title: OT RE: 24 x 7 on NT? Thanks for the link, I love that story:)) KK -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jacques KilchoerSent: Thursday, June 28, 2001 6:28 PMTo: Multiple recipients of list ORACLE-LSubject: OT RE: 24 x 7 on NT

RE: Virus again

I beleive there is definately an association, like the dude is still on the list, set up some stupid VB thing tha takes parts of messages and attaches viruses to them and sends them out That's my guess. KK -Original Message- Sent: Thursday, June 28, 2001 7:56 PM To: Multiple recipien

RE: Oracle DBA with SQL Server and Manufacturing Industry

Ron, Is Oracle Financials no longer supported on OpenVMS?. 10.7 financials was definitely OK on VMS although not many sites ran it and I thought 11.0 was out for VMS as well. John -Original Message- Sent: 29 June 01 14:06 To: Multiple recipients of list ORACLE-L We have an Alpha serve

RE: 9i Open Day (UK Listers)

I recieved the offical invite on my doormat this morning. I was wonderring whether to go and I see that it starts at 13:00+ which means I can still go the work in the morning. If I decide to go then a get-together /drinks would be great. - Mike. -Original Message- Sent: 29 June 20

Re[2]: What's lock/unlock mechnism

One can influence the locking of data via the "lock table" command and "for update of" portions of a SQL cursor. As a general rule of thumb I totally discourage anyone from ever using the lock table command. Certainly the process within the server is complicated as needs be, but it is one of the

RE: OCP Discount S36

Here is what the web site says: > Sign Up For a Test Now Register for Oracle certification testing (mention promotional code "S36" to receive your OTN 20% discount) -- There is no mention of an expiration date. Ken > I don't think it does -

RE: 9i Open Day (UK Listers)

I'm definitely there and am staying overnight on the Thursday so will be partaking in a fair few beverages Lee -Original Message- Sent: 29 June 2001 13:31 To: Multiple recipients of list ORACLE-L Hi all UK listers, I was just wondering how many people from the UK on here have act

Re[2]: Pocket Guide

What about O'Reilly's Oracle SQL: The Essential Ref? It's about 370 pages long, covers SQL syntax and a few other things. Has anyone looked at that? Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.or

Re: Influencing commit interval of read-only replication's refresh gr

> Hi, > > does some one know of a way to force the refresh process of a read-only > snapshot group to commit at predefined intervals: by table, by n number of > rows or any other way? The problem that we are facing is that a refresh > group has some rapidly changing tables and the rollback segme

RE: 9i Open Day (UK Listers)

I am sure lots of people will want to meet you now that you have annnouced to the list that you have got chicken pox Where is the meet? - Bracknell I assume, and how do you get an invite? John -Original Message- Sent: 29 June 01 13:31 To: Multiple recipients of list ORACLE-L Hi al

Re[3]: Pocket Guide

Dick, Would you be interested in reviewing an RMAN pocket ref? I'm currently editing the book, and it should be ready for review in a week or two. If you'd be interested in reading it over, let me know. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com

Work around for PL/SQL code

Hi, Let me introduce myself. I am Rangachari Sundar from Chennai India. I have the workaround for the requirement you have posted and here it is vPOSTAL_NO := lpad(replace(trim(recCursor.POSTAL_NO), ' ', ''), 7, '0') ; Trim is not available prior to oracle 8 so if your version is prior to 8 y

RE: PL/SQL

Roland, try vPOSTAL_NO:= lpad(replace(' 55 55',' ',null),7,'0'); select lpad(replace(' 55 55',' ',null),7,'0') from dual hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, June 29, 2001 8:30 AM To: Multiple recipients of list ORACLE-L How

RE: PL/SQL

vPOSTAL_NO:=lpad(replace(nvl(POSTAL_NO,'0'),' ',''),6,'0'); -Original Message- Sent: 29 June 2001 13:30 To: Multiple recipients of list ORACLE-L How can I change this pl/sql code. I want this to happen: I have for instance this blank 5 5 blank 55 which means 55 55

RE: PL/SQL

Roland, Try vPOSTAL_NO := replace(vPOSTAL_NO,' ','0'); lc -Original Message- [EMAIL PROTECTED] Sent: Friday, June 29, 2001 8:30 AM To: Multiple recipients of list ORACLE-L How can I change this pl/sql code. I want this to happen: I have for instance this blank 5 5 blank 55 which me

RE: Oracle DBA with SQL Server and Manufacturing Industry

We have an Alpha server here that we are going to be putting into service next year to run a financial application. Currently the os is OpenVMS and will support an oracle database but not the financials. We will have to change the os to Tru64 to handle the financials. The server is a dual ES40

RE: Invalid packages not being recompiled by Oracle

Paul, >From what I remember, if a package has been marked "invalid" and a user tries to execute it, it DOES get re-compiled at that time, but does not get executed. So the FIRST call to an invalid Package changes it's state to valid. The Second call will actually execute the package. The only

9i Open Day (UK Listers)

Hi all UK listers, I was just wondering how many people from the UK on here have actually registered for the 9i Open Day? I think it would be a great chance to get together for a quick drink and put faces to Signatures :) Thoughts? Mark === Mark

PL/SQL

How can I change this pl/sql code. I want this to happen: I have for instance this blank 5 5 blank 55 which means 55 55 (the spaces ar ethe blanks.) and I want it to be like this: 00 How can I change this code to let this happen: vPOSTAL_NO:= lpad(nvl

Re: Invalid packages not being recompiled by Oracle

On Thu, Jun 28, 2001 at 10:56:23AM -0800, Troiano, Paul (CAP, GEFA) wrote: > > We have one package A that refers to package B. If package B's body and > specification are both recompiled by user 1, package A is correctly marked > as invalid. Another user, user 2, then attempts to execute package

java stored procedures very slow

We suddenly seem to have a problem with java stored procedures running very, very slow. Tables are very small...so am wondering if tehre is anything in sga configuration for Java that we are no aware of Any one had this problem? John -- Please see the official ORACLE-L FAQ: http://www.orafa

Re: OAS 4.0.8.2

Here is th full message > owsctl start Please wait while the command is being processed on host unetdb2 ... The ORB process have already been started on host unetdb2. The command is not completed on host unetdb2. ld.so.1: /opt/var/m1/ows/ows/4.0/bin/oassrv: fatal: relocation error: file /opt/va

RE: OCP Discount S36

I don't think it does - it is just the Technet membership code.. -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 10:21 To: Multiple recipients of list ORACLE-L OTN says that you can get an OCT 20% discount on the testw with code S36. However, it doesn't say when thi

RE: Virus again

Well, I just a got a REAL Virus - Chicken Pox!! Just been to the doctors.. You better hope I can't spread E-Chicken Pox :) -Original Message- Sent: Friday, June 29, 2001 01:41 To: Multiple recipients of list ORACLE-L If I get e-mail from the customer with virus I'll inform him/her about

Re: Invalid packages not being recompiled by Oracle

Hi Paul, I agree completely with you and feel your pain. I have a workaround though, if the changes made to your package does not affect the specification(i.e no new parameters, no new functions/procedures) really, for changes only to the package body, You can do a ALTER PACKAGE package_name COM

OAS 4.0.8.2

I am running Oracle 8.1.6. on solaris 2.6 After installing Oracle Application Server I am getting this error on trying to start it > owsctl start Please wait while the command is being processed on host unetdb2 ... Starting ORB process... waiting for ORB to be ready... The command completed s

Re: What's lock/unlock mechnism

Hi, To find out more about the locking mechanism you can try the oracle concepts manual Jack Helen rwulfjeq

help

Hi , I have a doubt in pl/sql.I want to insert 5 rows in a table.I want the user to be prompted for entering data 5 times. But this code prompts the user only one time and inserts 5 times.What should i do to achieve my expected behaviour? declare begin for i in 1 .. 5 loop insert into tmpc value

Influencing commit interval of read-only replication's refresh gr

Hi, does some one know of a way to force the refresh process of a read-only snapshot group to commit at predefined intervals: by table, by n number of rows or any other way? The problem that we are facing is that a refresh group has some rapidly changing tables and the rollback segment is not big

Migrate from Oracle Web 7.3/NT to 8i (AS 9i)/2000

HiI have couple of pages on Oracle web Server included in Oracle 7.3 Server.How can I transfer them to Oracle8 - want to move to Windows 2000 whichdoesn't support 7.3, as far as I know.How do I setup the Web Server - Oracle or Apache? And how to transferhomepages, agents, listener... I have

Re: (No Subject)

Thanks Chao -- On Thu, 28 Jun 2001 23:47:32 chao_ping wrote: >hi, > just do: >'' represent ' > >SQL> create table testtb(a varchar(90)); >Table created. >SQL> insert into testtb values('i love oracle''s money'); >1 row created. >SQL> select * from testtb; >A >-

RE: Venkata's pc is back in line "VIRUS" messgaes again

for those of you on UNIX, write a looping shell script, say 1,000 times which does a mailx to his email account. Just a thought, but if I get one more from him (which incidentally should be triggered by this email) then that is what I considering doing. (I have metioned this to the UNIX S.As and

RE: starting up 8i on Win2000 Problems

hi guys! i was wondering if someone knows about some good resources (documentation and examples) for pl/sql web development using the pl/sql htp, htf and owa_* packages. i would also like to ask a simple but interesting licensing question about the use the pl/sql web interface. starting with ora

RE:

STOP IT !!! -Original Message- Sent: 29 June 2001 05:10 To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: (No Subject)

hi, just do: '' represent ' SQL> create table testtb(a varchar(90)); Table created. SQL> insert into testtb values('i love oracle''s money'); 1 row created. SQL> select * from testtb; A i love oracle's money S

Re: Data dictionary for function

jaimin wrote: > > Hi, > > DBA_SOURCE is the table which stores information about all procedures and > fuctions. > > SQL> desc dba_source > NameNull?Type > --- > OWNER NOT NULL VARCHAR2

<    1   2