Re: Finding out last 10 records

2002-08-15 Thread Jared Still
Rownum is not necessarily useless for this kind of query. In versions of Oracle (8i+) where an inline view can include an order by, it can be rather useful. Top 5 salaries: select ename, sal from ( select ename, sal from scott.emp order by sal desc ) a where rownum 6 Jared On

Re: RE: Dba tools on NT

2002-08-15 Thread Jared Still
As with any language, it's assumed that the developer will attempt to learn the language. :) This is pretty simply stuff, and very readable to folks with smattering of Perl knowledge. Jared On Wednesday 14 August 2002 20:38, Grabowy, Chris wrote: How many developers can maintain that

Re: RE: Dba tools on NT

2002-08-15 Thread Jared Still
Rachel, This snippet is reading data from a previously opened handle to a table. The 'print' statement prints a quote, the contents of the array ref $ary delimited with ,, and closes with quote and a newline. Maybe not readable if you've never programmed in Perl, but pretty simple stuff with

Re: It took more than an hour to update 10,000 records

2002-08-15 Thread Suhen Pather
Gogala, SQL Server is childs play. General Database Admin is pretty easy and most literate people can pick up skills quite fast. Watch out for this cos it can attract many cowboys doing tasks that you may not want them to. Lots of GUI driven functionality. And definitely no competition to

Re: It took more than an hour to update 10,000 records

2002-08-15 Thread Jack van Zanen
Similar here, Start practising your mousing skills :-) Jack Mladen Gogala

RE: rman examples scripts

2002-08-15 Thread Jack van Zanen
They are indeed 8i Looked briefly at 8.0 and decided to wait for RMAN 8i. 9i is not yet installed on my UNIX playground although I'll have a linux PC running 9i soon. I am waiting for your book to finish and it'll be the next one I'll buy, so it better contain heaps of example scripts :-) Thx

RE: utl file limitations

2002-08-15 Thread John Kanagaraj
Kathy, This is probably not documented, but you can have multiple lines of UTL_FILE_DIR _anywhere_ as _long_as_ you bunch them all up without any gaps / lines inbetween them (in which case the last set overrides the previous ones). I have the following in a 7.3.4 Db, all at the end (and I bet

RE: Query with a Remote Table over a DB-Link

2002-08-15 Thread John Kanagaraj
Hemant, It -Original Message- Sent: Wednesday, August 14, 2002 9:54 AM To: Multiple recipients of list ORACLE-L I had always understood that a query which joins a remote table to a local table would pull the entire remote table over and then do the join locally. However, the

RE: ORA-4030 Out of Process Memory

2002-08-15 Thread John Kanagaraj
Samir, Does ulimit -a indicate anything? From my Solaris 8 system: $ ulimit -a time(seconds)unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes)8192 coredump(blocks) unlimited nofiles(descriptors) 256 vmemory(kbytes) unlimited Also look

RE: Oracle Arm Twisting?

2002-08-15 Thread John Kanagaraj
I agree with Catherine. Oracle Apps (esp. 11i and bleeding edge versions) generate about 5 - 6 TARs a day at times at my current client. However, as far as other 'simple' applications are concerned, where the DB is just a simple repository (of say usernames and passwords for a Web server), full

RE: Query with a Remote Table over a DB-Link

2002-08-15 Thread John Kanagaraj
Hemant, It looks like even 7.3 was able to treat a remote query differently - cut and paste from 7.3 Tuning guide below. Although it does not specifically state this, the 'fragmenting query' seems to indicate this FWIW! John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970

Convert PL/SQL to Java

2002-08-15 Thread Barry Deevey
Good morning, Does anybody know of a utility that can convert PL/SQL code to Java code?? Thanks in advance for any replies. Barry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Barry Deevey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: Oracle Arm Twisting?

2002-08-15 Thread CHAN Chor Ling Catherine (CSC)
Hi John, Are you on Oracle Payroll as well ? If yes, is the Oracle Payroll as buggy as Oracle Human Resources ? The vendor is trying to persuade us to go on Oracle Payroll and I am hoping that the management will say NO. Regds, Catherine -Original Message-

RE: utl file limitations

2002-08-15 Thread Connor McDonald
This is fully allowed and support - it works with just about any of the multi-value parms. On more recent versions of Oracle you can see the parameters in this was using v$parameter2 even better - in 9.2, the utl_file_dir is no longer required. hth connor --- John Kanagaraj [EMAIL PROTECTED]

RE: SSO - and nothing else

2002-08-15 Thread Markus Reger
thx for replying - to make it more precise: we were looking for a way to install an oracle product - called iAS-1.0.2.2.2-portal's SingleSignOn - without installing the portal features. This would be even less than the minimum installation of the iAS 1.0.2.2.2. Actually we thought about a

Query Optimization of the future...

2002-08-15 Thread Deshpande, Kirti
Interesting article on Query Optimization research.. http://www.computerworld.com/databasetopics/data/software/story/0,10801,7316 4,00.html - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services

RE: How To grant execute to user on DBMS_LOGMNR package - Resolved

2002-08-15 Thread johanna . doran
Hi Joe, Its 8i, but the problem was that I was not qualifying a package constant. So, it found the package, but not the constant. I thought I had sent a resovled message to the list, sorry about that. Thanks, Hannah -Original Message- From: [EMAIL

create oracle db before or after

2002-08-15 Thread Ron Rogers
List, server Alpha ES40 O.S. OpenVMS 7.2-1 Oracle 8.1.7 rel 3 We are starting to migrate our database from a Novell server with Oracle 7.3.4 to the OpenVMS platform and I have a question that needs answers or suggestions. The sysadmin has set up the required OS parameters that I could

RE: Oracle Arm Twisting?

2002-08-15 Thread Jay Hostetter
Catherine, We all feel your pain. My only suggestion is to test heavily. For every hour of patching that we have, we have several hours of pre-req research and testing on another server. You simply can't run this software without a whole separate environment for testing patches. Is

RE: Why use a Unix Pipe to uncompress a file?

2002-08-15 Thread Loughmiller, Greg
We used it to migrate databases... For example.. We would export, compress and send it to a pipe via RSH on a different box... thin that pipe would be used as std input into an import process. The data never hit disk except into the new database. greg -Original Message- Sent:

Rolling sums (?)

2002-08-15 Thread Jack van Zanen
Maybe having a bad hairday but following code will give me for every period number the sum of all work in progress for the period plus the previous 12 periods. Basically it takes the period number from the current record and sums a column of that record with the previous 12 periods. year period

Re: Query Optimization of the future...

2002-08-15 Thread Tim Gorman
Good post, Kirti! Quote... "Oracle Corp. says its customers are moving toward data stores of huge size and complexity, spread over multiple locations. The company says its products will not only evolve to handle those kinds of jobs, but will also do them extraordinarily well. "Over the

RE: Oracle Arm Twisting?

2002-08-15 Thread Jack van Zanen
11iA:-) Here you can all talk about the good old days from before Oracle Apps 11i that you could go home at decent times and not had to install/test patches 25 hours a day. They meet twice a decade when the 11i DBA's can take time off from their holiday grin.. Jack (not 11i DBA)

FORMS_DDL

2002-08-15 Thread Moses Ngati Moya
What's the equivalent of FORMS_DDL in PL/SQL? I have tried to use DBMS_SQL.EXECUTE(proc) to execute DDL commands in vain. All I want is to Create USers from an application. In forms I would use DECLARE name varchar2(20) := 'Moses'; pword varchar2(20) := 'nevermind' state varchar2(200) :=

Re: Amount of redo

2002-08-15 Thread Yechiel Adar
Hello I do not think that you can estimate the amount of disk space required for archive log without turning archive log on and checking each day to see how much space you already used. To all who replied: I think that you missed his comment that currently he is NOT working with archive log on.

Re: Oracle Arm Twisting?

2002-08-15 Thread Yechiel Adar
Allow me to disagree with your opinion on oracle support with regards to the Israel oracle support. We get good advice andgood response time. Yechiel AdarMehish - Original Message - From: Rodd Holman To: Multiple recipients of list ORACLE-L Sent: Wednesday, August

Data Warehouse on Windows

2002-08-15 Thread Sackwitz, Antje
Hi, I was asked to give some hint for the hardware for a data warheouse running on Win 2k and holding about 20-40 GB data. Project will have about 40 small and 7-8 large tables. Users 20. Probably long running queries. Which hardware would you use? How many processors? Which disks? The

8i Security Alert

2002-08-15 Thread Ray Stell
08 August 2002 Security Alert #40: Oracle Net Listener Vulnerabilities Note:207269.1 Products Affected Oracle9i Release 2 (9.2 - all releases) Orace9i Release 1 (9.0 - all releases) Oracle8i (8.1 - all releases)

RE: Oracle Arm Twisting?

2002-08-15 Thread John . Whelan
Licensing is normally complex. Oracle licensing is more complex than most other software. The following is my personal interpretation of the rules. You should double check before taking action based on this interpretation. One option that no one has talked about is swapping your licence.

RE: Grant access to EVERYTHING w/out granting DBA privs.

2002-08-15 Thread Glenn Travis
Thanks to all who responded. This is what I eventually had to do (userid = glenn). System privileges for GLENN... GRANTEE PRIVILEGE WITH ADMIN -- -- GLENNCREATE ANY PROCEDURE NO

Re: Rolling sums (?)

2002-08-15 Thread Connor McDonald
Take a look at the windowing functions under 'ana;ytic functions' in the data warehouse guide...They are very very cool.. hth connor --- Jack van Zanen [EMAIL PROTECTED] wrote: Maybe having a bad hairday but following code will give me for every period number the sum of all work in progress

Re: Query Optimization of the future...

2002-08-15 Thread Ron Rogers
Kirti, The article is interesting and raises a lot of doubt and concern. Normally a companies database has a lot of queries against it that are the same and can be optimized at the source. The application is created and used by the employees with different variables placed in the blanks on the

Re: FORMS_DDL

2002-08-15 Thread Connor McDonald
begin execute immediate 'create user ...'; end; (8i+) hth connor --- Moses Ngati Moya [EMAIL PROTECTED] wrote: What's the equivalent of FORMS_DDL in PL/SQL? I have tried to use DBMS_SQL.EXECUTE(proc) to execute DDL commands in vain. All I want is to Create USers from an application.

Re: Amount of redo

2002-08-15 Thread Jack van Zanen
Beg to differ Try select * from v$log_history at one of your test databases. logswitches are in v$log_history regardless. So number of switches times the size of the logfiles gives you a pretty good estimate. Jack

RE: Oracle Arm Twisting?

2002-08-15 Thread Orr, Steve
To whose advantage is the complexity? It's sorta like automobile leasing... Marketeers obfuscate it or make it hideously complex so they can interpret to their own advantage. But on the flip side I hate it when gov't says they're going to simplify taxation... How much did you make? ... Send it

RE: What's STATSPACK

2002-08-15 Thread Schilling, Ben
-Original Message- Sent: Wednesday, August 14, 2002 9:24 PM To: Multiple recipients of list ORACLE-L Thanks Chaos for your invaluable information. Chuan -Original Message- Sent: Thursday, 8 August 2002 7:34 PM To: Multiple recipients of list ORACLE-L Chuan Zhang£¬

RE: Oracle Arm Twisting?

2002-08-15 Thread Rodd Holman
OK, I was a bit over generalized. Yes, I know Anita knows her stuff as well as most of the senior level support folks. My frustration is with the rocks that take up the first line handling of TAR's. From my experience with them, the only job requirement is the ability to be present.

Re[2]: RE: Dba tools on NT

2002-08-15 Thread dgoulet
One of the things I love about doing C code is your ability to create libraries and/or DLL's on NT (.so files on Unix, which I haven't mastered yet). When one of our developers asked HOW DO I DO THIS some months ago, we wrote the following code: void main(int argc, char *argv[]) { char

Re: OT: Looking for Contacts in GTA

2002-08-15 Thread paquette stephane
Why leave beautiful Montreal for a place where everything close at 1 o'clock ? ;-) --- David Hill [EMAIL PROTECTED] a écrit : Hi Guys I was just wondering if anybody could help me and send me some contacts or head hunter's in GTA. I'm currently Working in Montreal and am looking to

PL/SQL Editor.

2002-08-15 Thread Place for oracle
Hello, I need a nice PL/SQL editor any advice ? Thx for any advice Regards W.B __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Place for

Hot Backup using EMC /BCV splits

2002-08-15 Thread Nat
Hello, We are on IBM AIX 4.3.3 with EMC and BCVs. Our Unix admin has setup the backups for the database in following sequence to do the Hot backup. 1. Put all tablespaces in the database in Hot backup mode 2. Sleep 5 3. Put all the tablespaces back into normal mode 4. Split the BCV's 5. Mount

Re: Data Warehouse on Windows

2002-08-15 Thread paquette stephane
In a datawarehouse you want to exploit parallelism as much as possible. So you'd better with many processors and independant mount points. As raid 5 is very popular because it's cheaper, you will probably put your data on raid5 but fight to put your redo on non raid 5 disk. Do you have a good

RE: Data Warehouse on Windows

2002-08-15 Thread Bishop Lewis
Don't forget the Oracle/Windows 4GB boundary corruption problem! Lewis Bishop --- Barclays Enable/ISS/OPTS - Oracle OCP Database Consultant Phone - 020 8298 3418 Mobile - 07950 380857 Email - [EMAIL PROTECTED] -Original Message- Sent: 15 August 2002 14:58 To: Multiple recipients of

RE: Query with a Remote Table over a DB-Link

2002-08-15 Thread Hemant K Chitale
It seems that I have been labouring under a misapprehension for some years now ! So it would seem as if each remote database handles it's own portion of the query and returns only the result set to the initiating database. However, I cannot understand the part that says When choosing the

Re: Rolling sums (?)

2002-08-15 Thread Jack van Zanen
Didn't they come in with Oracle 8i? I could not find anything analytical in the online documentation (than again couldn't find the 8.0.5 warehouse guide either) I'm unfortunately on 8.0.5 for this one Jack

Re: Oracle Arm Twisting?

2002-08-15 Thread Yechiel Adar
Well, read this poem: 99 bugs in the programs 99 bugs fixed some bugs install a patch 101 bugs in the program Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 5:08 AM I guess you are not using

RE: It took more than an hour to update 10,000 records

2002-08-15 Thread Grabowy, Chris
Check out the clearance racks at the book stores and CompUSA, etc., as there stocked with SQL Server 7 books...otherwise I would say something like a smart---, but I'm trying to be good today. -Original Message- Sent: Thursday, August 15, 2002 2:43 AM To: Multiple recipients of list

Re: Amount of redo

2002-08-15 Thread Rachel Carmichael
yechiel, I didn't miss the comment, it's not relevant. Archived logs are merely copies of redo logs that have been filled. Whether or not archiving is turned on, redo logs get filled and reused. Oracle tracks the log switches no matter what mode you are in, it just doesn't make the copy of the

RE: RE: Dba tools on NT

2002-08-15 Thread Grabowy, Chris
(reading all the replies from others, putting my feet up) I rest my case... Does that make it two kegs of beer you owe me? -Original Message- Sent: Thursday, August 15, 2002 2:53 AM To: Multiple recipients of list ORACLE-L Rachel, This snippet is reading data from a previously

Re: create oracle db before or after

2002-08-15 Thread Rachel Carmichael
well, if you can hold off on creating the database until the OS changes are done, I would, if only to prevent extra work otherwise after I created the database and before the OS changes were done I would a) backup all Oracle executables b) backup the database c) export the database and

Re:Hot Backup using EMC /BCV splits

2002-08-15 Thread dgoulet
Nate, We are using EMC and BCV's each night to create both backups and a reporting database. Your SA has it WRONG. 1) Put all tablespaces in hot backup mode 2) sleep 5 3) split the bcv 4) return tablespaces to normal The reason that this is important has nothing in the world to do with

RE: Oracle Arm Twisting?

2002-08-15 Thread Grabowy, Chris
Playing devils advocate, I would have to believe that being the first level of support at Oracle is a tough job. I am not speaking strictly from the technical side but from the dealing with the people aspect. It seems that when it comes to customer service, people want it on a silver platter

RE: Oracle Arm Twisting?

2002-08-15 Thread Rodd Holman
Yes, it meets in the secure ward at the local hospital. Nice men in white coats come and serve you soft foods and liquids. You get a complimentary dinner jacket when you check in. ;-) Rodd On Thu, 2002-08-15 at 07:38, Jay Hostetter wrote: Catherine, We all feel your pain. My

RE: RE: Dba tools on NT

2002-08-15 Thread Orr, Steve
Jared Still, Oracle DBA and part-time Perl defender... 2 full-time jobs!! -Original Message- Sent: Thursday, August 15, 2002 12:53 AM To: Multiple recipients of list ORACLE-L As with any language, it's assumed that the developer will attempt to learn the language. :) This is pretty

Re: RMAN recovery stuck

2002-08-15 Thread Ruth Gramolini
You have to use the backup controlfile to do a point-in-time recovery that is prior to the current time. This may be your probelm. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 12:28 AM The problem is probably in

Re: Rolling sums (?)

2002-08-15 Thread paquette stephane
He's on 8.0.5, Analytic functions are only available in 8.1.x. --- Connor McDonald [EMAIL PROTECTED] a écrit : Take a look at the windowing functions under 'ana;ytic functions' in the data warehouse guide...They are very very cool.. hth connor --- Jack van Zanen [EMAIL PROTECTED]

Re: Query Optimization of the future...

2002-08-15 Thread Rachel Carmichael
Well, he had to say *something* after IBM and Microsoft had such cool things to announce and discuss. Assuming the past record of 3-5 years on average between releases, the next couple releases will take 6-15 years or so. Personally, by that time I'll be expecting artificial intelligence,

Re: Data Warehouse on Windows

2002-08-15 Thread Thomas Day
RAID 0+1. Hardware mirroring. Pentium III, two CPUs and 1G of RAM. And a sysadmin who can set up the RAID (the contracting officer will break my hands if I touch hardware other than the keyboard). Get dual controllers if you can so you can do some worthwhile separating of redo logs and

RE: SSO - and nothing else

2002-08-15 Thread Boivin, Patrice J
I have been assured here by an Oracle person that iAS licenses cover all of iAS... we are verifying internally if that applies to our licenses. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services|

RE: Query Optimization of the future...

2002-08-15 Thread Deshpande, Kirti
Thanks, Tim. I thought it was pretty 'interesting' response from Oracle Marketing ;) - Kirti -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 15, 2002 8:29 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Query Optimization of the

RE: SSO - and nothing else

2002-08-15 Thread torben . holm
in ias 1.0.2 you cannot avoid to install portal to do that you need to use ias 9.0.2 where the SSO (to my knowledge) is a separate product. regards torben -- Original Message --Date: Thu, 15 Aug 2002 02:38:18 -0800To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]Reply-To: [EMAIL

Oracle Security Product Management Issues Security Alert!

2002-08-15 Thread Linda . Miller-Coker
This e-mail is a critical, technical alert which is being sent as a service to all MetaLink users. The Oracle Security Product Management team has published the following four alerts on MetaLink: Security Alert #38: Security Vulnerability in Oracle Net (Oracle9i Release 2 Database Server)

Re: RE: Dba tools on NT

2002-08-15 Thread Yechiel Adar
Hello Jared I do not know Perl but it seems to me that your script will put a comma (',') before the first value, which will add a first blank column on input. Feel free to correct me if I am wrong but do not RTFM because I do not have the manuals. Yechiel Adar Mehish - Original Message

RE: Finding out last 10 records

2002-08-15 Thread Jamadagni, Rajendra
Jared, Probably it is not clear from my post, but ROWNUM is still useless WITHOUT an order by. And original poster had no clue on what to order by to start with. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at

RE: Finding out last 10 records

2002-08-15 Thread Abul Fazal
Take the emp table as an example Select rownum, empno from emp where rownum ( Select count(*) + 1 from emp) minus Select rownum, empno from emp where rownum ( Select (count(*) + 1) - 10 from emp) Hope this works Fazal --- Amjad Saiyed [EMAIL PROTECTED] wrote: hi milind iam not sure but

RE: Hot Backup using EMC /BCV splits

2002-08-15 Thread Fink, Dan
Nate, We are looking at the same process. Your Unix Admin is incorrect. The split needs to happen at STEP 2. Otherwise, what is the point of putting the tablespaces in hot backup mode? The split is not instant, in fact we are assuming it will take up to 5 minutes to complete. The only way

RE: Hot Backup using EMC /BCV splits

2002-08-15 Thread Hand, Michael T
Nat, We have a similar backup strategy using a homegrown split procedure on Compaq Tru64. We split while all tablespaces are in backup mode as our's is a controller based split and takes 5-6 minutes. After all, if the split is going to take place after the tablespaces are taken out of backup

RE: ORA-4030 Out of Process Memory

2002-08-15 Thread SARKAR, Samir
Thanks a bunch for replying, John. I had a look at the /etc/sysdef file and it seemed to be exactly the same as yours.so were the ulimit parameters. I have logged a call with Oracle but they do not seem too be very responsive either. Anybody else with any other ideas about what and how to

RE: RMAN recovery stuck

2002-08-15 Thread DENNIS WILLIAMS
Robert, Tim, Mladen, Bruce - Thanks for the excellent suggestions. I will try them today. Bruce - Yes, you have an excellent memory. Not only for the Metalink note, but recalling my posting from a month ago. I was pulled into some other projects and just now getting back to this one, trying the

Re:PL/SQL Editor.

2002-08-15 Thread dgoulet
My favorite is Procedure Builder from Oracle. Toad is OK in my book, but some of our developers like it better. Dick Goulet Reply Separator Author: Place for oracle [EMAIL PROTECTED] Date: 8/15/2002 7:09 AM Hello, I need a nice PL/SQL editor any

RE: SSO - and nothing else

2002-08-15 Thread DENNIS WILLIAMS
Markus - Well, you're really going in deep there. Perhaps someone with direct iAS experience will reply. I'm not aware of a separate list for that product. I can even visualize that you are pioneering on this one. What is your motivation for wanting to just install the SSO portion? Is licensing

Re: Hot Backup using EMC /BCV splits

2002-08-15 Thread Gene Sais
rofl! it should be 1, 4, 5, 2. [EMAIL PROTECTED] 08/15/02 10:58AM Hello, We are on IBM AIX 4.3.3 with EMC and BCVs. Our Unix admin has setup the backups for the database in following sequence to do the Hot backup. 1. Put all tablespaces in the database in Hot backup mode 2. Sleep 5 3. Put

RE: Query with a Remote Table over a DB-Link

2002-08-15 Thread Cary Millsap
You can 10046 level-8 trace the remote side of the query (an after logon trigger works great for this), and then you can see exactly what preparation steps the remote database is requested to perform by the local one. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events:

RE: PL/SQL Editor.

2002-08-15 Thread Farrell, Thomas M.Mr. NGB-ARNG
-Original Message- Sent: Thursday, August 15, 2002 11:09 AM I need a nice PL/SQL editor any advice ? I prefer vi myself but your probably looking for something like http://www.indus-soft.com/winsql/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farrell,

m-view ?

2002-08-15 Thread Roger Behm
Hi All, Anyone know how I could tell if records, in a materialized view, have been added or modified since the last refresh? Maybe there’s some sort of m-view trigger in Oracle that I don’t know about? Thanks in advance, Roger __ Do You

RE: Oracle Arm Twisting?

2002-08-15 Thread Boivin, Patrice J
I keep wondering if the names they use are their real names, or just labels. Some shops have "names" for phone receptionists for example, but the names they use aren't their real names. (e.g. Amy Friend, amie in French means "friend"...) I imagine some places do that for helpdesks as

RE: RE: Dba tools on NT

2002-08-15 Thread Brian McGraw
You know, I miss that 'Part-Time Perl Evangelist' tagline... :) Brian -Original Message- Sent: Thursday, August 15, 2002 9:44 AM To: Multiple recipients of list ORACLE-L Jared Still, Oracle DBA and part-time Perl defender... 2 full-time jobs!! -Original Message- Sent:

RE: Hot Backup using EMC /BCV splits

2002-08-15 Thread John Weatherman
Nate, We are doing this as well on Solaris w/ Veritas. Our series is: 1) Put everything in hot backup mode 2) Split all volumes EXCEPT archive 3) Take everything out of hot backup mode 4) Log switch 5) Split Archive We use this for cloning on a nightly basis and haven't had any issues.

Re:Hot Backup using EMC /BCV splits

2002-08-15 Thread Steven Lembark
-- [EMAIL PROTECTED] Nate, We are using EMC and BCV's each night to create both backups and a reporting database. Your SA has it WRONG. 1) Put all tablespaces in hot backup mode 2) sleep 5 3) split the bcv 4) return tablespaces to normal The reason that this is important has

Re: PL/SQL Editor.

2002-08-15 Thread Jan Pruner
Free OraEdit http://www.dkgadvancedsolutions.com/oraedit.htm JP On Thursday 15 August 2002 17:09, you wrote: Hello, I need a nice PL/SQL editor any advice ? Thx for any advice Regards W.B __ Do You Yahoo!? HotJobs - Search Thousands

RE: Hot Backup using EMC /BCV splits

2002-08-15 Thread Khedr, Waleed
I'm not familiar with BCV but if you are talking about splitting mirrored disks then this should be done while the Tablespaces are in backup mode. If the UNIX admin wants to do it this way then why bother doing step 1,2,3. I've seen this kind of statements EMC will take care ot this but things

RE: SSO - and nothing else

2002-08-15 Thread Scott . Shafer
Nope. To get SSO in 9.0.2 you have to install the _entire_ Infrastructure. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:29 AM To: Multiple recipients of list ORACLE-L Subject:

RE: Query with a Remote Table over a DB-Link

2002-08-15 Thread John Kanagaraj
However, I cannot understand the part that says When choosing the execution plan for a distributed statement, the optimizer considers the available indexes on remote databases just as it does indexes on the local database. . How does the local optimizer know about 1) Remote Indexes 2)

Re:create oracle db before or after

2002-08-15 Thread dgoulet
Ron, First item that would hit me is the version of Oracle that you want to run compatible with that version of the OS? Since I don't know OpenVMS and it's been 10 years since I worked with VMS in general I don't know. You may only need a patch upgrade which would be easy. The second item

RE: RE: Dba tools on NT

2002-08-15 Thread Cary Millsap
Nope. The join() function is smart that way. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Next event: NCOAUG

RE: PL/SQL Editor.

2002-08-15 Thread Scott . Shafer
vi or vim. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Place for oracle [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 15, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Subject: PL/SQL Editor. Hello, I need a nice PL/SQL editor any

Re: Rolling sums (?)

2002-08-15 Thread Connor McDonald
Apologies for not reading your post thoroughly enough.. :-( Cheers Connor --- Jack van Zanen [EMAIL PROTECTED] wrote: Didn't they come in with Oracle 8i? I could not find anything analytical in the online documentation (than again couldn't find the 8.0.5 warehouse guide either) I'm

RE: utl file limitations

2002-08-15 Thread Kathy Duret
The big question is if the tracing I need for 11i (i karumba) will work with this solution. I am waiting for Metalink to check it out. I also plan to test it this weekend on my TEST instance this weekend if I can get it from the users. I also plan on putting in a enhancement request for

Re:RE: Query Optimization of the future...

2002-08-15 Thread dgoulet
Interesting article. Microsoft has been pushing the database is the OS idea for some time, after Uncle Larry went down that dumb path a bit. Looks like their at it again. Hopefully the Judge in the Antitrust case will see the light break them up. Ms. Selinger's name and face rings a bell

RE: Where are bill rates going?

2002-08-15 Thread Grabowy, Chris
My application to McDonald's at the hourly rate of $40.00 has been accepted. This includes medical, dental, and vacation benefits. Due to the great demands for my skills, my new rate is $60/hour W2 ROFLMAO. Since when did you start sending out joke emails?? Sure!! I'll take the job at

RE: Hot Backup using EMC /BCV splits

2002-08-15 Thread Ji, Richard
You are right that the BCV split should occur at step 2. Ask him what's the point for step 1 - 3 if he split BCV at step 4. Is he also splitting the BCV for control file and online redo logs? Richard -Original Message- Sent: Thursday, August 15, 2002 10:59 AM To: Multiple recipients of

Re: Re:Hot Backup using EMC /BCV splits

2002-08-15 Thread Nat
Thanks a lot for all your resposes. The arugment our SA has is, the split that we doing is an instant split and he says Hot backup mode is required only if it is a Normal BCV split. All this argument started when we were trying setup a clone of our production database using the split copy. When

RE: Hot Backup using EMC /BCV splits

2002-08-15 Thread Wong, Bing
Can you tell us what is the size of the database that is using EMC/BCV or other Hardware vendor splits mechanism? Thanks. Bing Wong Open Systems Database Administrator x25721 -Original Message- Sent: Thursday, August 15, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Nat, We

RE: PL/SQL Editor.

2002-08-15 Thread Magaliff, Bill
I like RapidSQL from Embarcadero - but it's a bit pricy for a pretty good and less expensive alternative try PL/SQL Developer from allroundautomations -bill -Original Message- Sent: Thursday, August 15, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Hello, I need a nice

RE: Hot Backup using EMC /BCV splits

2002-08-15 Thread Deshpande, Kirti
You are correct. If EMC was taking care of consistency in *this* case, what is your UNIX Admin achieving in steps 1,2 and 3? He/She simply do not know how Oracle works. There are white papers at emc.com to support you. - Kirti -Original Message- Sent: Thursday, August 15, 2002 9:59

Anyone else get SPAMMED?

2002-08-15 Thread dgoulet
Did anyone else on the list get a spam from www.subcontract.com?? Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: create oracle db before or after

2002-08-15 Thread Ron Rogers
Rachel, Thanks for the feedback. I guess that the Oracle/OS upgrade issue and precautions are the same across all OS's. I am new to OpenVMS and wanted to make sure that there were not any hidden issues. Thanks again, Ron [EMAIL PROTECTED] 08/15/02 10:38AM well, if you can hold off on creating

Re: Anyone else get SPAMMED?

2002-08-15 Thread Ruth Gramolini
Nope! RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 12:08 PM Did anyone else on the list get a spam from www.subcontract.com?? Dick Goulet -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

OT: Where are bill rates going?

2002-08-15 Thread Johan Muller
I just received the following email from a recruiter for a senior DBA production support 6 month contract position (plus tuning and application enhancement thrown into the mix) in the Dallas/Fort Worth metro area. I was submitted for the contract 2 months ago (at $60/hour W2) and subsequently

Re: It took more than an hour to update 10,000 records

2002-08-15 Thread Mohammad Rafiq
Gogala Mladen Although I am not supporting SQL Server but my other colleague does, SQL SERVER has a nice product called Enterprise Manager , a GUI based tool , through which management of SQL SERVER is point and click. Besides BOOKS-ONLINE have a facitity called 'HOW TO' and you can go to

  1   2   3   >