Re: RMAN Reporting?

Shame on you Ruth. Paper ??? select sum(my data) from Rman_tables; Really, Paper That archaic method of cutting trees and using them :-( Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 16, 2002 10:14 PM

Re: Oracle 8i/HP-UX,Solaris,Windows/Active Directory Question

Forgot to mention: OS - WIN/NT-2000 Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 9:23 AM I am currently busy with the same project. Junk tnsnames.ora for OID. I installed OID 9.2.0.1. I then

how many records will be keep in v$log_history?

how to modify the default vaule for v$log_history? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: alert log suppression

The EXTENT_MANAGEMENT column tells you if they are locally managed or not. If they are local, then the ALLOCATION_TYPE will be either UNIFORM, SYSTEM or USER. The latter means it was originally a dictionary managed tspace that has been converted to lmt. But in any event, the coalesce is just

Dynamic select query

Hi all, I have a table by name shipment with two columns say ship_id and ship_name and data as follows: SHIP_ID SHIP_NAME - --- ABC 1ABCLMN XYZ 23XYZ1112 ABB 123LM I want to select all the columns in shipment

RE: how many records will be keep in v$log_history?

while creating the instance, parameter MAXLOGHISTORY specifies this... my guess is that you have to recreate the controlfiles -- From: Jim[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 4:38 PM To: Multiple recipients of

RE: password

he can't but he can change it to a new one and then put the old back on -Original Message-From: faisal ahmad [mailto:[EMAIL PROTECTED]]Sent: terça-feira, 17 de Dezembro de 2002 4:09To: Multiple recipients of list ORACLE-LSubject: password how can a dba see the

Export From INformix running on unix

Hi List , Can you help please !. Iam converting data from informix to oracle ,i need to export data from informix dbase running on unix to text files that i can load latter into oracle . Does any of you knows the command to do this export !. Thanks . -- Please see the official

RE: Dynamic select query

You should use the INSTR function INSTR(string,substring,[position],[occurrence]) INSTR searches string for substring. position is an integer indicating the character of string where Oracle begins the search. If position is negative, Oracle counts and searches backward from the end of string.

RE: password

Check the post-it note on their monitor? :) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paulo GomesSent: 17 December 2002 10:55To: Multiple recipients of list ORACLE-LSubject: RE: password he can't but he can change it to a new

RE: Dynamic select query

I believe INSTR() function will help here. Good luck, Charu -Original Message- Krishnaswamy, Ranganath Sent: Tuesday, December 17, 2002 11:05 AM To: Multiple recipients of list ORACLE-L Hi all, I have a table by name shipment with two columns say ship_id and ship_name and data

Re: DUAL

Hi, Is the link misspelled? It says Page cannot be found.. Jai Yechiel Adar [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/02 11:34 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: DUAL So listen

RE: Dynamic select query

Ranganath, You can use instr(ship_name, ship_id) 0 Cheers, Neil. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 17 December 2002 10:39 To: Multiple recipients of list ORACLE-L Hi all, I have a table by name shipment with two columns say ship_id and ship_name and data as

RE: Dynamic select query

Try: SQL SELECT * 2FROM shipment 3 WHERE ship_name LIKE '%ABC%'; SHI SHIP_NAME --- -- ABC 1ABC123 DEF ABC1234 GHI 1234ABC K. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: 17 December 2002 10:39 To: Multiple recipients of list ORACLE-L Hi all, I have a

RE: Problem with SQL query

Ranganath, Apologies my reply directly to yourself got bounced for some reason. A couple of questions. How good a filter is the ZPAA.AUFTRAGSPOSITION.TAGESABSCHLUSSNUMMER = :TAGESABSCHLUSSNUMMER line. And is the subquery done simply to ensure no duplicates. Generally you want to drive

Re: how many records will be keep in v$log_history?

MAXLOGHISTORY integer Specify the maximum number of archived redo log files for automatic media recovery with Oracle Parallel Server. Oracle uses this value to determine how much space in the control file to allocate for the names of archived redo log files. The minimum value is 0. The default

RE: New course for 9i - Dumps/Crashes from Oracle University

Title: RE: New course for 9i - Dumps/Crashes from Oracle University I highly recommend these courses. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch |

Re: Dynamic select query

Hi Kris, You can do that using the following query : select ship_id,ship_name from shipment where ship_name in (select ship_name from test where instr(ship_name,ship_id)1); Best Regards Jai Krishnaswamy, Ranganath [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/02 04:08 PM Please

RE: password

nope u can get the encripted password from the oracle dictionáry -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED]]Sent: terça-feira, 17 de Dezembro de 2002 11:34To: Multiple recipients of list ORACLE-LSubject: RE: password Check the post-it note on their

Recall: Dynamic select query

Thomas, Kevin would like to recall the message, Dynamic select query. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Dynamic select query

I think using LIKE is faster. where ship_name like '%ABC%' Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 17, 2002 6:45 AM To: Multiple recipients of list ORACLE-L Ranganath, You can use instr(ship_name, ship_id) 0 Cheers, Neil.

RE: Dynamic select query

Another way to perform the same task: select * from shipment a where ship_name like (select '%' || a.ship_id || '%' from dual); I wonder how efficient this is compared to using the INSTR() function. Regards, Charu -Original Message- Kevin Sent: Tuesday, December 17, 2002 12:45 PM To:

Re: RMAN Reporting?

Ha ha. You tell me how to group the records together so they can be added, electronically or manually, and I will be glad to do so... Ruth Gramolini [EMAIL PROTECTED] wrote: Add them together! Or are we so in need of a technical solution that weforget the pencil and paper?Ruth- Original

Unable to load shared libraries libskgxp8.o

Hi All, After installing oracle on Red Hat 8.0, when I try to run svrmgrl, I get the eror failed to load shared libraries libskgxp8.so. LD_LIBRARY_PATH and SHLIB_PATH both are set to $ORACLE_HOME/lib. After looking up this error on Metalink, it seems to be a linking error. I did the

RE: DUAL

The link is not wrong. Note, however, that a hard return split it into two. Also, I think the word Yechiel Adar was meaning to use was : deleterious :harmful often in a subtle or unexpected way deleterious effects deleterious to health -Original Message-

An Oracle list _just_ for system administrators?

All, I've gleaned a great deal from this list, but my actual interest in things Oracle revolves around the Application Server. I don't want to be a DBA or programmer, as much fun as it (hah) looks. Is there a list devoted to the topic of System Administration for Oracle? Brian Dunbar System

RE: password

And you can use it to change it to your convenience and later get this encrypted password IN without the knowledge of the user.. Regards Jai Paulo Gomes [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/02 06:08 PM Please respond to ORACLE-L To:Multiple recipients of list

Re: Leading spaces in dbms_output.put_line

Hi Steve, Try using : declare a varchar2(20):='JAI'; begin dbms_output.put_line(chr(9)||a); end; Regards Jai Steven Haas [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/02 01:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: Capacity Planning -- Expecting the DB growth !!!

Reddy - Step number one is to immediately begin collecting size data. For most sites, storing a weekly count of the number of rows in each table is sufficient. Usually combine it with regular ANALYZE TABLE or DBMS_STATS executions. This will be your basis for making projections. Then get to

RE: password

unless, of course, you are using the profile and password history, in which case you can't reuse the password for x times --- [EMAIL PROTECTED] wrote: And you can use it to change it to your convenience and later get this encrypted password IN without the knowledge of the user.. Regards

Re: Export From INformix running on unix

Hi Walid Do you know the Oracle Migration Workbench? We did the same migration(informix to oracle) using thats tool. Adriano Freire. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 9:23 AM Hi List , Can you help

Re: Unable to load shared libraries libskgxp8.o

Hi!!! Look at your lines: /bin/sh: line 1: cc: command not found this tells you that you need the C compiler... look for it at: /usr/ucb/bin or try with the find command! the next one: the AR assembler is trying to get the config.o file... review that you really have set your

Larry E's new toy ?

http://www.computerworld.com/hardwaretopics/storage/story/0,10801,76748,00.html Enjoy :) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Syntax ? For MTS_DISPATCHERS

All I cant seem to get the syntax correct on the MTS_DISPATCHERS= in the initSID.ora It seems no matter what I use I get a ORA-00101: invalid specification for system parameter MTS_DISPATCHERS (last 2 lines) When I try to restart the db from svrmgrl Ive checkd all online docs and even

Re: Export From INformix running on unix

Thanks Adriano , This Informix verion is too old 6. something ,i can use Oracle Migration bench with it ,so i though of exporting data from informix it self.

RE: DUAL

Title: RE: DUAL That's it. I'm inventing my own dummy table. CREATE TABLE dummy (DUAL varchar2(20)); -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Monday, December 16, 2002 10:04 PMTo: Multiple recipients of list ORACLE-LSubject: Re: DUAL So

Re: Syntax ? For MTS_DISPATCHERS

Here's the line out of my init: mts_dispatchers="tcp,20" (I'm on 8.0.5, Solaris) Barb Bob Metelsky [EMAIL PROTECTED] wrote: AllI cant seem to get the syntax correct on the MTS_DISPATCHERS= inthe initSID.oraIt seems no matter what I use I get a ORA-00101: invalid specification for system parameter

RE: Syntax ? For MTS_DISPATCHERS [solved]

On offline suggestion seemd to have corrected the error Apparently it was a combination of me removing MTS_LISTENER_ADDRESS= (1521) And removing the quotes from the sid MTS_SERVICE=MYSID The db started, I will begin querring the V$ Im wondering if I need MTS_LISTENER_ADDRESS= (1521) ???

Re: Unable to load shared libraries libskgxp8.o

It appears that you didn't install the Linux development tools. Run the pkg manager, and install the dev tools. ( cc, ar, ld, etc ) Jared Panicker, Thankam S. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 04:53 AM Please respond to ORACLE-L To: Multiple

Re: password

You can't. faisal ahmad [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/16/2002 08:09 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:password how can a dba see the password of a user. The new

db block Size for Indexes Tablespaces in 9.2 ?

What is the Best Practice for DB_BLOCK_SIZE for Index Tablespaces Undergoing High Volume of Insert , Update , Selects ? Why ? Any Docs , Links for the Same ? NOTE - This is for a Hybrid Application Benchmark undergoing 2000 Banking Transactions per second approx. OLTP Transaction sample =

RE: Syntax ? For MTS_DISPATCHERS

Title: Message I should have indicated the OS this is win2kpro Ive just pasted in your syntax into the initSID.ora and tried to start the db with svrmgrl and get the same behavior mts_dispatchers="tcp,20" ORA-00101: invalid specification for system parameter MTS_DISPATCHERS If I

Returning a Java object to PL/SQL

I'm on Oracle 9iR2 and after crawling through the documentation I am beginning to think this can not be done. Can your return a Java object back to a PL/SQL procedure/package? I have a class that has a method that will return an extended version of java.io.FileOutputStream. I won't need to do

RE: Dynamic select query

Even better: where ship_name like '%' || SHIP_ID || '%' Jared Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 04:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:

RE: password

How, Oracle does not publish the password encryption algorithm, and I don't believe anyone has cracked it. Jared Paulo Gomes [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 04:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL

RE: password

Hmm... Well maybe you *can* crack oracle passwords. I've just ordered the full version of this product. ( $4, I don't think I need to bother the purchasing department ). I'll let you know how it works. Jared Mark Leith [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 06:23 AM

RE: Unable to load shared libraries libskgxp8.o

I did install the binutils package. Is cc anot included in that? Thanks Sumathy -Original Message- Sent: Tuesday, December 17, 2002 12:09 PM To: Multiple recipients of list ORACLE-L It appears that you didn't install the Linux development tools. Run the pkg manager, and install the

RE: password

How about select username, password from dba_users; USERNAME PASSWORD -- SYSD4C5016086B2DC6A SYSTEM D4DF7931AB130E37 This is part of the becomeuser script where you

Re: password

From DBA_USERS. :-) I think you replaced encrypted with decrypted. JP On Tuesday 17 December 2002 18:04, you wrote: How, Oracle does not publish the password encryption algorithm, and I don't believe anyone has cracked it. Jared Paulo Gomes [EMAIL PROTECTED] Sent by: [EMAIL

RE: Export From Informix running on Unix

You can use dbexport to export Informix data in a text file and use SQL-Loader to insert records in Oracle tables. For more information on Informix's dbexport command type dbexport -. The dbexport exports the whole database. If you want to export individual tables, you can use unload to

RE: password

Jared, This seems to be a 'brute force' dictionary based attack, as I believe the Oracle password is a one-way trapdoor (just as UNIX). I don't think this will be able to crack a strong password created from say a combination of the first characters of an arbitrary sentence. John Kanagaraj

Re: password

I think, you need not crack it, just use it to create own hash and compare it with PASSWORD from DBA_USERS. But HOW to use it? JP On Tuesday 17 December 2002 18:04, you wrote: How, Oracle does not publish the password encryption algorithm, and I don't believe anyone has cracked it. Jared

Re: Capacity Planning -- Expecting the DB growth !!!

Check the link Kirti has posted (orapub). Is capacity planning only on the database size ? In my mind it also includes : Transaction description (online and batch) Transaction frequency (online and batch) Transaction window Networking requirements Number of users (all and

RE: db block Size for Indexes Tablespaces in 9.2 ?

Title: RE: db block Size for Indexes Tablespaces in 9.2 ? Can you specify db_block_sizes at the tablespace level in 9? *blink* -Original Message- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 8:29 AM To: Multiple recipients of list ORACLE-L

RE: password

I thought (for a micro-second, and very smug I was too) that we'd be more-or-less safe from crack attempts as we're going to be using in 9iAS R2's Active Directory bit to authenticate from our AD servers. But, thought I, the AD implementation on Oracle is a sub-set of master LDAP - they're not

RE: password

oh this is very scary especially that price did you try out the demo? I'm still in catch-up, deal with crises mode so I haven't had a chance Rachel --- [EMAIL PROTECTED] wrote: Hmm... Well maybe you *can* crack oracle passwords. I've just ordered the full version of this product. (

RE: password

If you are too cheap for $4.00 then there is this one http://www.trantechnologies.com/pass_cracker.zip I found it in the comments for Oracle Password Cracker 1.6 on www.download.com Greg -Original Message- Sent: Tuesday, December 17, 2002 1:14 PM To: Multiple recipients of list

Re: password

Wrong, I took my first Oracle class with a woman who had cracked the algorithm. At the time, I didn't know enough to ask her for it. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 12:04 PM How, Oracle does not

Re: password

I don't know if 'crack' is the right word. It just tries words from the dictionary until it finds one that encrypts to the same value. Keith - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 11:09 AM Hmm... Well maybe

RE: Unable to load shared libraries libskgxp8.o

No, you need to install the development tools, as per my previous email. Panicker, Thankam S. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 09:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:

Re: db block Size for Indexes Tablespaces in 9.2 ?

I can't point to a paper or article on that, but based on tests I have done, the block size of index tablespaces for a high volume transaction system should be lower than the table block sizes. 2000 tps with 25 changes each does not sound like a really huge transaction rate. You could set the

Re: DUAL

I've seen that when I was a developper ...using Oracle 6/vax vms and Sql*Forms 2.3. There was 2 rows in dual. Since dual was heavily used when programming in Forms2.3, it cause a big problem as no users were able to log in (the menu was using dual). It was in the stock exchange department of a

RE: Oracle 8i/HP-UX,Solaris,Windows/Active Directory Question

Yechiel, We weren't able to get OID replication to be stable for more than a few weeks under 9.0.1. After a week or two, it would just flake out like it needed to make more than 10 or 20 connections to the DBs and it halted. The only solution was to bounce OID -- not the DBs, just the LDAP

Re: RMAN datafile allocation to channels

My condolences on 8.0.5, you should patch to 8.0.5.1 for better a much better rman. Actually we are on 8.0.5.1. What are the differences in rman between these versions? I think that every channel is used for each datafile. When one datafile has been completely backed up the channels are

RE: password

Interesting. Does CHANGE_ON_INSTALL have the same hash value for every version and every instance? Not being much of a hacker (anymore) I would think that with only one algorithm and several known passwords (you can generate them yourself), this wouldn't be much of a challenge to real hackers.

RE: password

This program does not reverse-engineer or decrypt Oracle passwords. It does a dictionary forward brute-force hack. So, if the user's password is not in the list of pre-defined words then the password is never revealed. This just encourages DBAs to enforce password management. See the

RE: password

It's one way encryption. So you can loop on all the permutation for AA to ZZ and apply the encryption code and compare the output to the dictionary content. If it matches, then you got the password. I thought about doing this five years ago, but decided against it. I thought I will be

RE: password

it's definitely a one-way encryption on the password, I forget where I read it but I do know that's true. I think that in addition to a strong password, if you lock an account after x failed attempts then they'd have to be REALLY lucky to guess it on the first few tries. Rachel --- John

RE: password

Bob, That no longer works as of 8i if you enforce the password history... you'd have to change the password a number of times to get it back to what it was. Rachel --- Bob Metelsky [EMAIL PROTECTED] wrote: How about select username, password from dba_users; USERNAME

Re: password

The best defense is to lock the account if there are over x number of failed logon attempts. Then they have to guess in just a few tries. You can also reduce the change that it will work by enforcing password complexity. Or at least it would take a long time. Make sure people have a number and/or

RE: Capacity Planning -- Expecting the DB growth !!!

Hello All, It should include all as you said , but since I do not belong to a capacity planning group in my shop , I mostly concentrate on the DB growth . I have taken Sales as business object to correlate with the DB size . I think in our case both of them are directly proportional. ( Business

RE: password

It's brute force attack,and relies on a dictionary. Only weak passwords will be cracked, like common words etc. I don't think you need to worry at all if you enforce passwords that must contain numeric besides characters etc. Richard Ji -Original Message- Sent: Tuesday, December 17,

RE: DUAL

I remember when you had a weird application problem, one of the first thing Oracle support ask you to check is the dual table to see if it's got more than one row in it. Don't know if they are still doing that. Richard Ji -Original Message- Sent: Tuesday, December 17, 2002 1:26 PM To:

RE: password

Ari, If the algorithm is any good, the cracker should find SHO3LAC3, as that is a weak password. Unix crackers would pick this up. Jared Ari Kaplan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 10:44 AM Please respond to ORACLE-L To: Multiple recipients of list

RE: password

Exploit is, I believe, the proper term. http://www.tuxedo.org/~esr/jargon/html/entry/exploit.html ~brian -Original Message- Sent: Tuesday, December 17, 2002 12:29 PM To: Multiple recipients of list ORACLE-L I don't know if 'crack' is the right word. It just tries words from the

RE: password

Yes, it's a dictionary based cracker. Could be useful for checking for weak passwords. For $4, I'm going to see what it does. :) Jared John Kanagaraj [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/17/2002 10:08 AM Please respond to ORACLE-L To: Multiple recipients of

slow query help

Hi, This is the query bothered us very much recently. It run at least 15 min. and sometimes crashed the temp tablespace. Do you have any idea how to make it run better. Our developer tried used two cursors to compare the result, but the result is not optimized. We tried used last name and first

RE: password

I don't think the x failed attempts lock will do anything. Because in this case they are not brute forcing it by trying to log in. It assumes you have access to the one-way encrypted(hashed) passwords and brute force on that. Just like you got hold of the /etc/shadow file on Unix and run

RE: password

OK...then put in some punctuation marks SH03LAC3#JAREDFORPRESIDENT!209 is probably safer ;) -Ari -Original Message- Sent: Tuesday, December 17, 2002 1:29 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Ari, If the algorithm is any good, the cracker should find SHO3LAC3, as that

RE: Larry E's new toy ?

DO you think if Larry has enough E toys that an F for failures may finally be seen? Perhaps C for closouts. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original

Re: RMAN datafile allocation to channels

They cleaned up some of the spurious errors and made it very stable. 8.0.5 was very flaky, after 8.0.5.1 is became a very usable product. I have been using it since I started with Oracle, 8.0.4. I am now on 8.0.6.3. It is very stable. Regards, Ruth - Original Message - To: Multiple

RE: DUAL

Those guys retired... ;) They ought to put that stuff in that RDA script :) - Kirti -Original Message- Sent: Tuesday, December 17, 2002 1:40 PM To: Multiple recipients of list ORACLE-L I remember when you had a weird application problem, one of the first thing Oracle support ask

RE: password

you mean I am supposed to take down all those post-it notes? Darn! --- Ari Kaplan [EMAIL PROTECTED] wrote: This program does not reverse-engineer or decrypt Oracle passwords. It does a dictionary forward brute-force hack. So, if the user's password is not in the list of pre-defined words

ioug

I heard back from Julie, she thinks I may get in under the Expert Technical sessions as they didn't allow many alternates there.. so now all I have to do is go around to the people who were accepted and bribe them not to come nah __ Do you

RE: password

I used to work as a Unix security admin and would frequently run password cracking programs against our password files. We found that the really weak passwords were found in the first 5 minutes, ones derived from info in the gecos fields. Better ones, using number/letter substitutions in

OT: OS/2 is officially dead as of Dec 10, 2002

http://www.pcmag.com/article2/0,4149,767456,00.asp Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes

RE: password

Yes that's rite I cant use D4C5016086B2DC6A as the password But... I can SQL alter user bob identified by newpassword ; Log on as bob and make any changes I want then... SQL Update dba_users set password = 'D4C5016086B2DC6A' where user = bob ; Bob doen not know his account has been

RE: DUAL

That's a good idea. You ought to suggest them to put it in. -Original Message- Sent: Tuesday, December 17, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Those guys retired... ;) They ought to put that stuff in that RDA script :) - Kirti -Original Message- Sent:

Re: ioug

blush oops :) at least I didn't say anything too awful okay guys, line up for your bribes :) --- Rachel Carmichael [EMAIL PROTECTED] wrote: I heard back from Julie, she thinks I may get in under the Expert Technical sessions as they didn't allow many alternates there.. so now all I have to

RE: Leading spaces in dbms_output.put_line

Thanks Bruce. That was exactly what I needed. --- Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] wrote: Steve, Have a look at Metalink Doc ID: Note:108091.1 For those without Metalink access this suggests: 1) Use format wrapped at the end of your Set Serveroutput command. This works

RE: password

on a TEST database go ahead and try that you can't update dba_users that way --- Bob Metelsky [EMAIL PROTECTED] wrote: Yes that's rite I cant use D4C5016086B2DC6A as the password But... I can SQL alter user bob identified by newpassword ; Log on as bob and make any changes

Re: slow query help

Joan Hsieh wrote: Hi, This is the query bothered us very much recently. It run at least 15 min. and sometimes crashed the temp tablespace. Do you have any idea how to make it run better. Our developer tried used two cursors to compare the result, but the result is not optimized. We tried

RE: password

Its not an update of dba_users. Its an Alter user identified by values OldPassword, which is also what an export/import uses. Raj Bob

RE: password

I think it's 26^6 There is a big difference between 26^6 and 6^26 let's keep the fun :) Waleed -Original Message- Sent: Tuesday, December 17, 2002 3:20 PM To: Multiple recipients of list ORACLE-L I used to work as a Unix security admin and would frequently run password cracking

RE: Capacity Planning -- Expecting the DB growth !!!

I use DBMS_SPACE to calculate the actual size of all data objects in our SAP databases. The data is collected once a week. Once a month I use the collected data to create an aggregate table via Oracle's linear regression and partitioning SQL operators. Run the projections for the current

Re: DUAL

The same thing happened to me as well. There were 2 rows in dual, and it caused some really strange problems with Oracle Financials. The support tech and Oracle knew his stuff, and had me check it. I have no idea how 2 rows came to be in dual, but it sure was a mess. Jared Stephane

RE: DUAL

It also improves your BCHR! -Original Message- Sent: Tuesday, December 17, 2002 1:45 PM To: Multiple recipients of list ORACLE-L That's a good idea. You ought to suggest them to put it in. -Original Message- Sent: Tuesday, December 17, 2002 3:07 PM To: Multiple recipients of

RE: password

Does CHANGE_ON_INSTALL have the same hash value for every version and every instance? Yes, it does. Check: http://www.pentest-limited.com/default-user.htm This is a pentest list of default Oracle passwords. I've used this to create a perl script that checks for default passwords. It

RE: password

Don't think the db name plays a role in this. But the username does. i.e. user1, user2 share the same password and the hash comes out different. but user1 from two different database share the same password and the hash comes out the same. Richard Ji -Original Message- Sent: Tuesday,

RE: Capacity Planning -- Expecting the DB growth !!!

There is not really capacity planning here. I'm starting a new job as a permanent employee and since my first project is quite small, I've started writing a capacity planning guide hoping the other groups will collaborate. One thing we do is to run statspack each hour on all production databases

  1   2   >