RE: MySQL in the future?

Jacques, Based on what Matt sent, I'd say your in violation of their license. You've distributed it internally. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, June 20, 2003 4:45 PM To: Multiple recipients of list ORACLE-L Thank you

RE: Look's like Larry's at it again...

Bill can HAVE Mississippi, for free!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, June 20, 2003 4:55 PM To: Multiple recipients of list ORACLE-L I figured he try for something closer to home...say Oragon? Then Bill would want to buy

RE: [Q] Script to generate grant privilege on a table?

-Original Message- From: mike mon [mailto:[EMAIL PROTECTED] Does anyone has script which can check grant privilege on a table and generate output for future usage? If you're looking for a script to show existing grants on a table, you could modify this one (that shows existing

RE: Look's like Larry's at it again...

ORA-GON? Daniel, you are a genius! He could also ammend the constitution to read We, the PeopleSoft Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 20, 2003 4:55 PM To: Multiple recipients of list ORACLE-L I figured he

RE: oracle authentication from windows

All, Oracle has rounded all this discussion up in Note:207959.1 'All About Security: User, Privilege, Role, SYSDBA, O/S Authentication, Audit, Encryption, OLS' which is a jump off point to *lots* of other Notes. John -Original Message- From: Arup Nanda [mailto:[EMAIL PROTECTED] Sent:

RE: Look's like Larry's at it again...

Seriously though, I wondered years ago at what point multinationals are going to pick a deserted island, declare it their country, and set up their own tax laws. Some companies have higher revenues than countries. Patrice. -Original Message- Sent: Friday, June 20, 2003 3:20 PM To:

RE: Partition

Jacques, the version is 9.0.1.1.1. Dennis, Thanks for the confidence I totally agree with you about designing and everything else. Could there be a temporary solution to get successful exports until we embark on this project. we are in a 24x 7 environment. Rgds Ishwar. -Original

MS Access as a front-end to Oracle DB

Hi all: I have been hearing from many people that MS Access is bad as a front-end tool because it tends to do data processing on the clien side instead of the DB side thus moving way too much data over the network. Assuming that this is correct, what is the mechanism of this? If I execute a

Re: controlfile backup obsolete

Sorry, I never used RMAN so far but this point came in my mind. I am surprised why Robert is not giving you a reply. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 20 Jun 2003 09:45:11 -0800 Rafiq that is a good point , but I

RE: Partition

Ishwar One priority might be to get to 9.2. There are reasons Oracle has given 9.0.1 a short decommission date. One idea would be to export with a SQL statement. This would reduce the size of your exports. Also, if you are mostly just adding new data (few updates), you may be mostly just

Re: MS Access as a front-end to Oracle DB

I haven't worked with MSAccess to Oracle stuff lately, but it used to be that the ODBC stuff pulled A LOT of background crap in addition to what was needed for the query. And, yes, Access did a lot of the processing locally. The way I got around this was that I either used passthrough queries

RE: MS Access as a front-end to Oracle DB

Yes, you are misunderstanding it. A simple statement like your will result in only the data required being sent over the network. But if you add in a second table things change, especially if that table is a local access table. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA

(OT) RE: Look's like Larry's at it again...

Ever heard of Sealand, the country formed by an ex-British radio station owner who took over an abandoned World War II military platform built off the coast of the UK and declared it a sovereign country? http://wikipedia.com/w/wiki.phtml?search=sealandgo=Go -Original Message- From:

RE: (OT) RE: Look's like Larry's at it again...

Got this when trying to connect, guess they are on MySQL. :) -- Could not connect to DB on 130.94.122.197 Host 'larousse.wikipedia.org' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' If this error persists after

Re: oracle authentication from windows

Hi Beth OK, I get your point but Arup was talking about automatic connections by setting remote_os_authent to true where you can either set the prefix to OPS$ or use identified externally. For these connections the user should not be prefixed by the domain name in the database. On the other hand

DBMS_OBFUSCATION Toolkit

Title: Message Hello all, Does anyone know if the DBMS_OBFUSCATION toolkit works with CLOB's? I have looked high and low and can't find a reference other than from a third party solutions web site and they say it can't be done and have to use their product. thanks Steve Main

RE: Partition

I agree with Dennis Williams. To know what is the right answer for you, first you should determine why you want the table partitioned in the first place. Is it so that you can easily archive old data by using the alter table drop partition command? Is it so that your queries will benefit from

WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=12

I am seeing WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=12 in the alert log file? there are no blocking locks and at this time the weblogic connection pool cannot get connections to the database but the client connections from sql*client gets connected (sqlplus or toad). What could be the

test - please ignore

test - please ignore -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

FW: Oracle 9i and streaming technology

Got a bit more on what they were doing. One really gets "scared" when Oracle wants to know what you're doing. Maks. -Original Message-From: GregSubject: RE: Oracle 9i and streaming technology Actually streams is a hybrid of several Oracle technologies: Log miner (used to hot

Re: Passwords and authentication

What about SQLNET.ENCRYPTION_TYPES_CLIENT= (rc4_256) SQLNET.ENCRYPTION_SERVER = accepted SQLNET.ENCRYPTION_CLIENT = requested SQLNET.CRYPTO_SEED = The quick brown fox jumps over the lazy dog. in sqlnet.ora - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

Re: controlfile backup obsolete

Thanks rafiq , will hope that the gurus of Oracle smile upon us mortals soon. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 21, 2003 03:14 : Sorry, I never used RMAN so far but this point came in my mind. I am : surprised why Robert

Fw: controlfile backup obsolete above 2 days

Hello list sorry to trouble you all so much, I tried all that I stated below on another database I created, and as long as I don't use an spfile , no problem. As soon as I start using an spfile , I always get my backup shown as obsolete , irrespective of the number of days (the value of n) I

Re: WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=12

Better call Oracle support for this one. These are references to some internal deadlocks and enqueue problems not reported in the v$ views. I think Steve Adams discusses this in his Oracle8i Internal Services book. Search his web site, you may find some more information (www.ixora.com.au). -

Re: Passwords and authentication

That is for encypting password while tranmitting over Oracle Net, the password itself must be entered in clear text. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, June 20, 2003 10:34 PM What about SQLNET.ENCRYPTION_TYPES_CLIENT=

Re: oracle authentication from windows

Arup , the procedure you gave is correct and works fine. I tried it out on win32 with 9.2.0.1.0. But I had to set SQLNET.AUTHENTICATION_SERVICES= (none) in sqlnet.ora My fundamentals are really weak , so please forgive the stupid questions : These steps create a database user who will be

<    1   2