Re: driving me crazy

2002-08-01 Thread Yechiel Adar
Title: RE: driving me crazy I think that you will get a better answer if you post the script and the structure of the tables that are used in the view. Yechiel AdarMehish - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent:

Re: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA

2002-08-01 Thread Yechiel Adar
side but they do their functions. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 01, 2002 2:58 PM Hi That's true. You should at least have the option to use (usable;) GUI tools. Just yesterday, I had a developer

Re: Delete performance

2002-08-01 Thread Yechiel Adar
I think that you better delete all indexes that are not used in the selection of the records. Updating the indexes will add a long time to the run. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 01, 2002 4:03 PM

Re: Replication

2002-08-02 Thread Yechiel Adar
Use the KISS principle. Define asynchronous replications on their machines and when they come back and connect to the network the updates will be applied. TEST TEST TEST Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday

Re: 20 Instances 1 Machine

2002-08-02 Thread Yechiel Adar
You also have to consider the OS overhead. Putting 20 instances means hundreds of processes. Just managing all this at the system level can be resource consuming. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 02

Re: FORMS - text_io - dynamic formating

2002-08-02 Thread Yechiel Adar
(once upon a time) application that inserted control characters into the output stream. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 01, 2002 7:38 PM Hi I have used Text_io to export a datablock to csv

Re: Microsoft Txn Server / Locking issues

2002-08-02 Thread Yechiel Adar
user input between them. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 01, 2002 12:41 AM Anybody have any experience with Microsoft Txn Server? I am running into issues with a few Windows2000 servers running

Re: MS win2k SP3 available

2002-08-02 Thread Yechiel Adar
Use OEM Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 01, 2002 3:08 AM -Isn't that an admin's dream? Having all desktops and servers administer themselves? My dumn ass NT admins don't need

Re: There are even more plots to go around.

2002-08-04 Thread Yechiel Adar
Every confession you make goes directly into Microsoft database and will used against you in a court of law. Only internal Microsoft confessions will we written to null but, since null is a Unix invention they will come out if Microsoft will NOT buy the USA. Yechiel Adar Mehish - Original

Re: TRANSLATE

2002-08-04 Thread Yechiel Adar
I think that you need to check also on char(10). End of line usually includes chr(10) and chr(13). Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 31, 2002 8:17 PM try select translate(string,','''||chr(13

Dba tools on NT

2002-08-13 Thread Yechiel Adar
Hello all We are looking on programming and scripting tools for DBA team on NT. Can you, oracle DBA's on NT, tell me off the list what tools you are using for these functions and, if you be so kind, why you choose them. TIA Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ

Who is using a table?

2002-08-13 Thread Yechiel Adar
to the application people an earth shuttering KABOOM :-) ). We need idea how to do it. We thought about auditing of writing a trigger that will log each access to the table but we fear the overhead. Any suggestions, ideas, whatever are welcome. TIA Yechiel Adar Mehish -- Please see

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

2002-08-13 Thread Yechiel Adar
the network time added. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 6:24 PM Hi all, I write a script to update 10,000 records in my database and noticed it took more than an hour to update 10,000

Re: SAN

2002-08-13 Thread Yechiel Adar
10 blocks. This is just from the top of my head but will assist greatly for full table scan of big tables. Also remember that in Oracle before 9i blocks used in FTS are put at the end of lru so are great candidates to be overwritten and you will read them again and again. Yechiel Adar Mehish

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

2002-08-14 Thread Yechiel Adar
Hello David Define index on all fields in the where clause. Full table scan or reading a lot of records by index for each sql statement can cause this. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 6:24

Re: SAN

2002-08-14 Thread Yechiel Adar
extra block read into the controller memory when the computer is doing other jobs. Since tables have usually extents bigger then 27 blocks the saving can be much bigger. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August

Re: Finding out last 10 records

2002-08-14 Thread Yechiel Adar
Check the doc: SQL reference, basic elements of Oracle SQL pseudocolumns. The explanation on rownum gives you examples for your problem. Yechiel AdarMehish - Original Message - From: Santosh Varma To: Multiple recipients of list ORACLE-L Sent: Wednesday, August 14,

Re: Amount of redo

2002-08-15 Thread Yechiel Adar
on. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 2:08 PM Hi List, I want to put my databse in archive mode(Presently it is non archive mode).I want to estimate space that will be required for archive

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

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: 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: DBA tools on NT - PERL

2002-08-18 Thread Yechiel Adar
Title: RE: DBA tools on NT - PERL I am going to buy Jared book. He wrote to me that the book is currently available on Amazon. You can use www.perl.com to supplement tour needs. Yechiel AdarMehish - Original Message - From: Jacques Kilchoer To: Multiple recipients of list

Re: Amount of redo

2002-08-18 Thread Yechiel Adar
I sit corrected. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 4:43 PM yechiel, I didn't miss the comment, it's not relevant. Archived logs are merely copies of redo logs that have been filled

Re: Data Warehouse on Windows

2002-08-18 Thread Yechiel Adar
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: init.ora processes ??

2002-08-18 Thread Yechiel Adar
Another thing to consider is this: From OraPerf: The LGWR needs to scan all processes to find each process that is waiting for the commit to be written. So when you have an excess of process LGWR works harder. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list

Re: ORA-12500 TNS:listener failed -- Intermittent

2002-08-18 Thread Yechiel Adar
Enterprise version. We are on standard version so it did not worked for us. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 15, 2002 11:58 PM Gurus, Oracle Version: 8.0.4 (I know we are way behind) OS: Windows NT

Re: SAN

2002-08-18 Thread Yechiel Adar
The ADABAS/Natural/Predict list server that I know about: http://www.uark.edu/sag-l/faq.html You can also contact me directly and I will help if I can. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 16, 2002 6:03

Re: Data Warehouse on Windows -more

2002-08-19 Thread Yechiel Adar
Hello Aleem This is not a boundary. It is a problem if you use autoextend and the file grows from less then 4Gb to more then 4GB. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 19, 2002 1:48 PM Where can I find

Upgrade from 8.1.6 to 9.2.0

2002-08-19 Thread Yechiel Adar
did you solved it? I also opened a TAR and will send the results when I get them. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: Upgrade from 8.1.6 to 9.2.0

2002-08-19 Thread Yechiel Adar
Thanks Raj I know that I can import/export. I want to convert the existing DB. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 19, 2002 8:48 PM We are upgrading from 8161 to 92. You can export from 8161

Re: Re:Named User Licensing for Oracle Programmer (precompilers)

2002-08-21 Thread Yechiel Adar
components we are using. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 20, 2002 10:23 PM You have that right. :( Thankfully their much less inclined to check than on the database side. Dick Goulet

Re: PL/SQL Editor

2002-08-30 Thread Yechiel Adar
We are using TOAD for the DBA team. For the developers we got PlSqlDeveloper and it works fine. You can check also www.quest.com for the new sql editor that they developed recently. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent

Re: Re[2]: controlling CPU usage through Oracle

2002-08-30 Thread Yechiel Adar
In NT and win2000 you can set Os priorities to the different tasks. If you have the sane facility on aix you can give this db a lower priority so whenever the other databases will need CPU they will get it. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L

Re: Configuring 734 and 817 on same machine.

2002-09-05 Thread Yechiel Adar
Title: Configuring 734 and 817 on same machine. We have 7.3.4 and 8.1.6 working on the same machine with no problems. 7.3.4 was installed first and then 8.1.6. Listener is 8.1.6. Do not forget to shut down ALL 7.3.4 services and processes before installing 8.1.6. Yechiel AdarMehish

Re: Fail Over Options

2002-09-05 Thread Yechiel Adar
I heard that there is a network switch or router that does dynamic translation of IP addresses. So you can always connect to one address and change the translation in the switch/router in case of fail over. This should be transparent to your thin jdbc client. Yechiel Adar Mehish - Original

Re: Function-Based Index not working

2002-09-05 Thread Yechiel Adar
Hello I think that the amount of records you read is also taken into account. If you run a query that selects ALL the records in the tables it is ALWAYS more efficient to do full table scan then to access by index. Yechiel AdarMehish - Original Message - From: Marul Mehta

Re: General Replication question

2002-09-05 Thread Yechiel Adar
and finally did the right thing. Called Oracle support and paid for in site consulting. The guy came over and after 6-7 hours had a script that generate replication for a schema. I put it in production about 1 year ago and no problems since. Yechiel Adar Mehish - Original Message - To: Multiple

Ioug meeting or HOTSOS Seminar

2002-09-10 Thread Yechiel Adar
://bneo15.sba.com/ew/ioug/index3.cfm?clientsess_id=07332332nextpage=cal lpapersconference_id=71 MAYBE (not shouting but a big maybe) I will convince management to spring for one of the two. Which one you recommend? Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: gathering history v$ to predict system change

2002-09-11 Thread Yechiel Adar
Check out the statspack viewer at http://www.statsviewer.narod.ru. I played with it a little and it gives you graphs of the performance data gathered by statspack. I plan to check it more thoroughly in the near future. Yechiel Adar Mehish - Original Message - To: Multiple recipients

Re: methodology to keep only certain programs to connect to

2002-09-11 Thread Yechiel Adar
Hello Joe I implemented today Tom's trigger in one of our test databases and it works fine. I am using it to track which users / applications are connecting so we can notify them in case of scheduled down time or problems. You need to run dbmsrand.sql to add dbms_random package to the

Re: Ioug meeting or HOTSOS Seminar

2002-09-11 Thread Yechiel Adar
If I remember correctly from the OT list it better be a male hand. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 11, 2002 10:48 AM I think it depends on whose hand you have to shake as you enter

Re: Nasty bug in 9.2.0.1 (was: Oracle and Cache Hit Ratio based train

2002-09-11 Thread Yechiel Adar
Title: Nasty bug in 9.2.0.1 (was: Oracle and Cache Hit Ratio based training) You should call your sales persons and start applying pressure for them to provide a correction to 9ir2. I am doing this right now. Yechiel AdarMehish - Original Message - From: [EMAIL PROTECTED]

Re: Copy one user's table to another user's table

2002-09-12 Thread Yechiel Adar
There is also a copy table command in SQL. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 12:30 AM How do I copy all data in one user's table to another user's table? Regards, David

Re: FW: Problem upgrading Oracle 8.1.7 on MS2000

2002-09-12 Thread Yechiel Adar
Old stuff. Happens all the time. Start stopping services on the machine and do retry until it works. You get to services via: startsettingscontrol paneladministrative toolsservices. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent

Re: Re:OT: Misinformation Ranting

2002-09-12 Thread Yechiel Adar
. This thread helped me a lot in telling them to go bark up another tree. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 10, 2002 11:16 PM Jared, What version of the database does this book refer to? I do

Re: Rowid

2002-09-12 Thread Yechiel Adar
When the row is moved to another block. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 5:28 AM what are the cases for a rowid to be changed ? Regards, Prakash. -- Please see

Re: Satisfied customer

2002-09-12 Thread Yechiel Adar
Murphy's law expansion for writers: When a writer receive his new book from print, he will always open it in the place with the worst errata. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 4:08 AM

Re: Restoring RMAN backups to different host ......solved

2002-09-12 Thread Yechiel Adar
If I remember correctly netbackup can restore oracle DB only to the original machine. By setting this environment variable you trick it to think that this is the original machine. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent

Re: RMAN backup to remote dir. - how ?

2002-09-12 Thread Yechiel Adar
Use map network drive on your target machine and define the drive as a directory on your recovery machine. I mean: map drive K on the target machine as f:\backup on the recovery machine. Then backup to drive K. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list

Re: SYSDBA privilege with ORAPWD utility

2002-09-12 Thread Yechiel Adar
Hello Chetan I think that you need to have administrator permission on the NT domain to be able to logon as sysdba. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 11, 2002 2:38 PM Hi List , I have

Re: test - please ignore

2002-09-12 Thread Yechiel Adar
NO Yechiel AdarMehish - Original Message - From: Farnsworth, Dave To: Multiple recipients of list ORACLE-L Sent: Monday, September 09, 2002 5:18 PM Subject: RE: test - please ignore Can you hear me now Good ;o) -Original

Re: Timeout while obtaining an oracle connection lock

2002-09-12 Thread Yechiel Adar
Check out the number of processes init.ora parameter against open connections. You may have run out of available processes. Yechiel AdarMehish - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, September 12, 2002

Re: View Locks

2002-09-12 Thread Yechiel Adar
You are not, but you can call his highness and then HE can kill the sessions. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 11, 2002 5:13 PM How are you going to kill another session without a DBA role

Re:

2002-09-17 Thread Yechiel Adar
for implementation parameters. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 17, 2002 1:23 AM Hi List, If anybody can explain to me what sort of change I have to do on y sql*net it would be a big help: I got

Re: Another Character Set Problem

2002-09-17 Thread Yechiel Adar
To change the character set to another that is not recognized as a superset use: Alter database db-name character set INTERNAL_USE new_character_set This parameter is active for oracle 8.1 and above. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L

Re: Nasty bug in 9.2.0.1 (was: Oracle and Cache Hit Ratio based t

2002-09-17 Thread Yechiel Adar
If you will search Metalink you will see that this bug is generic and not specific to a certain system. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 16, 2002 7:58 PM Guys, the 2429929 apply for Sun Solaris

Re: Shutdown and startup processes

2002-09-17 Thread Yechiel Adar
Hello Willie We are using startup trigger that calls a Java function that sends an MQSeries message to the mainframe. Maybe you could use a Java function that will close and open the scheduler. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

Re: SYSDBA privilege with ORAPWD utility

2002-09-17 Thread Yechiel Adar
Sorry for the late post. I did some research some time ago and found that when connecting as sysdba you are working under user SYS no matter what user you used to logon. So, connect system as sysdba and you are sys. problem solved. Yechiel Adar Mehish - Original Message - To: Multiple

Replication script

2002-09-17 Thread Yechiel Adar
tables in the schema. No guarantee. Works fine for me. Use as you wish but please keep to copyright notice. First script: /* Copyright: Yechiel Adar, Mehish computer services */ /*THIS SCRIPTS ASSUMES THAT THE TARGET DB IS FULL. DO AN EXPORT AND IMPORT TO TARGET DB. TO AVOID CONSTRAINT

Re: Listener load balance

2002-09-18 Thread Yechiel Adar
Hello Ramon I think that you have an error in your parameters. As far as I know (not much) the second network card have a different TCP/IP address. You have to put this address in the added line in listener.ora and add (load_balance=on). (ADDRESS_LIST = (load_balance=on) (ADDRESS =

Re: Listener load balance

2002-09-18 Thread Yechiel Adar
? Tks for your help TIA Ramon - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Wednesday, September 18, 2002 4:09 AM Subject: Re: Listener load balance Hello Ramon I think that you

Re: HELP! CAN't STARTUP REMOTE DATABASE USING SQL*PLUS - BUG?-NADA o

2002-09-19 Thread Yechiel Adar
Title: HELP! CAN't STARTUP REMOTE DATABASE USING SQL*PLUS - BUG?-NADA on METASTINK Hello I noticed that your sqlplus logon connects to an idle instance. That's mean that you are NOT connected to the remote database. You need to set oracle_sid or use connect system/password@database. Also

Re: RMAN implementation strategy

2002-09-19 Thread Yechiel Adar
I want to add another point. After 7 years your tapes can be unreadable. If you use exports you can periodically restore them and backup them to a new tape. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 19

Re: oracle and appliance storage

2002-09-19 Thread Yechiel Adar
Use map network drive and then use the new drive letter for files. Of course, do not forget sharing on the receiving drive. Yechiel Adar Mehish - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 19

Re: sqlplus question

2002-09-19 Thread Yechiel Adar
Tried this. The field length is still 56. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 19, 2002 6:43 PM select substr(ename,1,length(ename)), job from emp; From: Bob Metelsky [EMAIL PROTECTED] Reply

Re: calling a stored procedure from a sitescope monitor

2002-05-22 Thread Yechiel Adar
Chris You wrote I just want to call it and get the one value it returns. I think that procedure does not return values, functions does. If you want to get value from a procedure you have to pass a parameter that the procedure will return the value in. Yechiel Adar Mehish - Original Message

Re: How to drop a datafile from a tablespace quickly

2002-05-22 Thread Yechiel Adar
to the gate to be judged. As Osama awaits his journey to his final very hot destination, he screams This is not what I was promised! An angel replies I told you there would be 72 Virginians waiting for you. What did you think I said? Yechiel Adar Mehish - Original Message

Re: ORA-2085

2002-05-22 Thread Yechiel Adar
At last something that I have experience in. Just do the following: On the target database issue the following: Alter database rename global_name to donot_trigger; We had the same problem. This solves it. The global name has no other influence. Yechiel Adar Mehish - Original Message

Re: partitioning

2002-05-22 Thread Yechiel Adar
Title: Message None It is an option (Means you pay). Yechiel AdarMehish - Original Message - From: Cunningham, Gerald To: Multiple recipients of list ORACLE-L Sent: Wednesday, May 22, 2002 6:38 PM Subject: partitioning Hi all, Does anybody know with

Re: ORA-2085

2002-05-22 Thread Yechiel Adar
the users ( parameter in the application) to the backup machine and they worked without problems, although the global name was different. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 22, 2002 7:28 PM Yechiel

Re: patching 8.1.7

2002-05-22 Thread Yechiel Adar
I think that this db will be among the last to upgrade. Any bugs and (wolla) no more OEM or no more backups and restore. ! Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services

Re: SQL Loader

2002-05-22 Thread Yechiel Adar
How about using external table? You define the table as external having one field. I think that select * from such table will bring you the lines in order and then you can do whatever you want with the data. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE

Re: Data Warehouse Hardware Recommendations

2002-05-23 Thread Yechiel Adar
IBM mainframe. Nothing beats these dinosaurs. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 23, 2002 6:08 AM Our data warehouse box is nearing it's max capacity so we are looking for options for an upgrade

Re: Rename Column in 9iR2

2002-05-23 Thread Yechiel Adar
Upgrade to 9iR2 today. Rename column does not work in 9.0.1. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 22, 2002 9:30 PM If those times are right... its a functionality you should not live without, its

news server

2002-05-23 Thread Yechiel Adar
I am looking for the address of oracle news server. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: ORA-2085

2002-05-23 Thread Yechiel Adar
Been there, Done that, Works in production. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 23, 2002 3:33 PM I'd never have thought that this was possible in Advanced Replication Hemant K Chitale

Re: Data Warehouse experts, a simple question for you| Outdated?

2002-05-23 Thread Yechiel Adar
That's not panicking, just common sense. Too many data warehouse projects went down the drain so you need to learn all you can before starting such project. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 23, 2002 3

Re: so when did you switch from NT to unix for oracle

2002-05-23 Thread Yechiel Adar
Hello Joe I think that the main reason is response time. An NT machine can get only 4 CPUs. If you have all the CPUs and memory and the NT does not carry the load then it is time to consider a change. A change can be to Unix or to clustering. If you are all NT shop then I would consider

Re: news server

2002-05-23 Thread Yechiel Adar
Sorry, I wish that e-mails had a way to attach what I wanted to say. I meant news group on the subject of oracle. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 23, 2002 3:53 PM On 2002.05.23 07:08 Yechiel

Re: news server

2002-05-23 Thread Yechiel Adar
Thanks Joe Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 23, 2002 6:23 PM comp.databases.oracle.server comp.databases.oracle.tools comp.databases.oracle.misc comp.databases.oracle.marketplace I access

Re: Database backup question.

2002-05-26 Thread Yechiel Adar
Title: RE: Database backup question. You missed the last one. He is PHB again. Yechiel AdarMehish - Original Message - From: Whittle Jerome Contr NCI To: Multiple recipients of list ORACLE-L Sent: Friday, May 24, 2002 11:43 PM Subject: RE: Database backup question.

Covert tnsnames.ora to OID

2002-05-27 Thread Yechiel Adar
Hello All How can I covert all the names from tnsnames.ora to OID? I do not feel like entering all this data again, by hand, one by one. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network

Re: Financials Client question

2002-05-28 Thread Yechiel Adar
working with machines that are less then P4. Make them prove their point. !!! Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 27, 2002 10:18 AM We have outsourced implementation and setup of a scaled down

ora-918

2002-05-29 Thread Yechiel Adar
replaced the three IN with 3 = select count() where month in (2,3,4) and it works, but I would like to know why the original didn't. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services

Re: is my table analyzed with compute/estimate

2002-05-29 Thread Yechiel Adar
Hello Very simple. Select sample_size from all_tables. The field contain NULL for unanalyzed tables, 0 (zero) for compute statistics and sample size from estimate statistics. Oracle 8.1.6.3.4 Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

Re: ad-hoc update check

2002-05-29 Thread Yechiel Adar
and put them on low resource group so one Cartesian select will not bring the production to halt. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 29, 2002 12:25 AM Hi folks - I have received a stream of requests

Re: ora-918

2002-05-30 Thread Yechiel Adar
TED] 618-622-4145 -Original Message- From: Yechiel Adar [SMTP:[EMAIL PROTECTED]] Hello list I need help in solving ORA-918: Ambiguous field reference. All the fields are schema.tablename.fieldname. The SQL has 3 inline queries that are the same but with

For real Gurus only

2002-05-30 Thread Yechiel Adar
Hello Gurus I got this link through SAG-L. Have a try. www.quest-pipelines.com/newsletter-v3/Crossword_Puzzles/puzzle0502.html Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services

Re: updated rows count

2002-05-30 Thread Yechiel Adar
before the update: Select count(*) from table where ... Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 3:48 PM Hi All! My client run big update 20,000 statements. I need to know how many rows

Re: how can listener list on two ports for the same db?

2002-05-30 Thread Yechiel Adar
Title: how can listener list on two ports for the same db? Hello Helmut You need to configure the listener to listen on ONE host with 2 ports. The machine name is the same. You separate the connections via tnsnames.ora on the client side. I got a call today that one of our application

Re: So, What is a 'Production DBA'?

2002-05-30 Thread Yechiel Adar
. Boy was he suprised. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 6:51 PM Gene - C'mon ya gotta give us more details. I have heard that most DBAs either come from developers or sys admins, but I can't

Re: Using DUAL

2002-05-30 Thread Yechiel Adar
I am the one that started it. I saw that each select from dual cost about 4-5 buffer gets. Define view on x$dual and select from that view, no buffer gets. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 7

Re: updated rows count

2002-05-30 Thread Yechiel Adar
OPS, sorry I thought that you mean one update that updates about 20,000 rows. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 5:04 PM before the update: Select count(*) from table where

Re: Jr.DBA, Mid level DBA, Sr.DBA

2002-05-30 Thread Yechiel Adar
Salary ! Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 8:08 PM Hello: Out of curiosity how would you classify a Jr. DBA, a Mid Level DBA, and a Sr. DBA? I know how our HR department makes

Re: Jr.DBA, Mid level DBA, Sr.DBA

2002-05-31 Thread Yechiel Adar
senior DBA's maxing out at infinity? :) -Original Message- From: Yechiel Adar [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Re: Jr.DBA, Mid level DBA, Sr.DBA Salary ! Yechiel Adar Mehish - Original

Re: * Certified Oracle DBAs Needed in the Dallas area..

2002-06-03 Thread Yechiel Adar
So, If I am working a long time why should I now quit and move to work with them? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 31, 2002 4:19 PM Great Company located in Greater Dallas, Texas area (Richardson

Re: Jr.DBA, Mid level DBA, Sr.DBA

2002-06-03 Thread Yechiel Adar
Hello Itiu You wrote: Most people use it : We have a saying: zillions flies can not be wrong, eat shit. BTW - We use NT servers. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, June 02, 2002 2:43 AM What's wrong

Re: Archiver process in 7.3.4

2002-06-09 Thread Yechiel Adar
Look in v$database column log_mode. Tested on 7.3.4 on NT. Work also in 8.1.6 and 9.0.1 Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 05, 2002 7:13 PM Anybody knows how to get status of archiver process

Re: I/O contention with external process reading the oracle logs (online redo logs)

2002-06-09 Thread Yechiel Adar
. TIA Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 06, 2002 4:32 PM (online redo logs) NB_ RESENDING in plain text - sorry, Outlook keeps seinding in html no matter what default i set! Hi lists, I am using

Re: I/O contention with external process reading the oracle logs (online redo logs)

2002-06-12 Thread Yechiel Adar
that some of you are using Quest Shareplex. Can you share your reasons, success stories etc? Benchmarks results will be very welcome. TIA Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 06

<    1   2   3   4   5   6   >