RE: Oracle 8.1.7 and 5.1A Cluster

erm.. problem solved from the Tru64 mailing list. Solution below in case anyone else runs into it. The WINNER is Raul Sossa --- Thanks a million Raul! Raul helped us with a paper published by TUSC www.tusc.com named Oracle Parallel Server on Compaq Tru64 Unix using Cluster File Systems.

RE: doubts reg : Tablespace

Oracle Manuals my good man, Oracle Manuals ... -Original Message- Sent: 28 November 2001 17:10 To: Multiple recipients of list ORACLE-L hi, what is the exact use of making the 'status' online or offline at the time of creation of tablespace. can objects of two diff users be

average log write size and stripe size

Hi List, I have two RAID1 volumes with stripe size 8K (according to the Compaq'sRAID Configuration Utility, butstrange term for mirroring though). These volumes are dedicated for storing online redo logs only. We use file system (ext2). The average log write size is about 12K. Will I get

Re: Standby Database

Quick question, long answer... You are not only making sense, you have hit the primary issue with the Oracle standby database directly on the head. With DataGuard in 9i (or 8i on HP-UX or Solaris only), you can *try* to retrieve redo log files. You could also do it manually - with any version.

Re: backup unix script

grace wrote: hi gurus, I found this unix script ... can any tell me what this means? sqlplus - sys/msd filename.dat ! does anyone have a unix script to perform a database backups? Best Regards, Grace Lim Suy Sing Comm'l Corp. (632)-2474134 Your Unix script seems to take as input

RE: Delete slowing..

Title: RE: Delete slowing.. Hi, Perhaps you check the Indexes against that table, you can drop the index first, you may consider a TRUNCATE TABLE command if you not need the rollback option. Sinardy -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf

RE: OCP tests

Title: RE: OCP tests Hi Samir, I think the Exam Cram books from Coriolus are OK. They do not cover everything, they are slightly inaccurate sometimes but they compress and summarise what you need and they are relatively cheap (£21 UKP) compared with others. I have an article on my web site

RE: Connection question?

Title: RE: Connection question? Harry, I am not sure that BEQ connections use the standard listener at all. In fact on VMS systems you cannot make an internal connection if the bequeath listener is not started (BEQLSNR START|STOP|STATUS). Once you start that listener then you can connect

Re: Urgent - error ORA-24327

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 02:00 If you have more than 300 or 400 connections, should consider MTS. not really they already use the connection pooling of WebLogic, so doing it twice won't really

RE: Crontabs and Oracle

Thanks David, and everyone else for all your help. Unfortunately, I've done all this, specifying the variables etc and it still doesn't appear to like it much! I don't know whether it's because it's written in the CSH and not for KSH...I'll keep looking. Thanks again, Kev. Some mornings it

Re: Standby Database

K Gopalakrishnan wrote: If you want to Zero data loss in standby you can copy the online redo logs thru an external C program. You can copy the online redo log files when the LGWR is writing to it. The program should read the log files without locking. You can use the fixed table

RE: Longest SQL statements!!!

I would have just thought that it would be exceptionally inefficient and more practical to divide it into chunks or procedures. More easily maintained etc. -Original Message- Sent: 28 November 2001 17:22 To: Multiple recipients of list ORACLE-L Are there any implications on how long

Re: 9ias Vs IIS

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 06:03 Thanks for you inputs. I'd like some concrete data on Security issues with IIS. Do you know of any sites for this ??? You know how it is, I can't just go to

RE: How to compare files on the server with local machine

Hi Wendy, Is the server NT, Unix or ??? Is the client NT? If the client is NT and can map to the server, 1 option would be to write a batch file to loop through all the files, do a FC.exe on each file, check the errorlevel and copy the file if different. Another option would be to use a

MS SQL Server to Oracle Problem

Hi all, I am trying to Import a database Design and Data into Oracle from MS SQL Server 2k. All tables have been imported excepting for one. Error message: ORA: 01754: a table may contain only one column of type LONG What should I do to be able to import the table into Oracle? Thanx in

RE: Delete slowing..

I think the condition used to delete the records for table is not matching with the indexes of that table. check the indexes properly and the delete statement also accordingly and make sure that the condition/column which is given to delete is present in the index. -Original Message-

Determinants of control file

Title: Determinants of control file Hi all, The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., But after creation of control files, where should i get details about these parameter values?... i checked in v$controlfile and v$database... i didn't

PL/SQL problems

Hallo, I would like to know how to solve this problem: When this procedure runs, which makes an insert into table pbk.prisregister, it inserts the same value in field substitut where there exists a substitut. Please help me with this? It should be null in that field in case thre is a

Question! ORA-12571

Hi all, I have been out of the Oracle loop for awhile now, and I think that's why I ma having triuble with simply installing the server. No matter what I do, after the installation succeeds, I cannotcreate a new database. I always get the error ORA-12571: TNS Packet Writer Failure. I have tried

RE: OCP tests

Title: RE: OCP tests Hi John, Thanks so much for ur reply. I visited ur website and had a good idea of what to look for towards preparing the exam and how to go about it. Also, the treatment of Logminer was very useful for me too. I do not much experience in PL/SQL too...in our

RE: Delete slowing..

Hi all, Thanks for your responses on this - I had most of them in mind - but there were a couple out there (PCTUSED/PCTFREE and child table FK/indexes) that I hadn't thought of. To give you a little more info on this - and let you know what I know so far: This is on an 8.0.6 database running

RE: Determinants of control file

Title: Determinants of control file Hi Nirmal, Use alter database backup controlfile to trace; You can find these details in the trace file, that will be dumped to your udump destination. HTH Srinivas. -Original Message-From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL

failed to extend rollback segment ??????

Hi I have created a test table and I have inserrted about 5 recoeds in it. when I want to delete even one record ofthis table receive the following errors: ORA-01562: failed to extend rollback segment number 3 ORA-01650: unable to extend rollback segment R02 by 64 in tablespace RBS and

Re: PL/SQL problems

[EMAIL PROTECTED] wrote: Hallo, I would like to know how to solve this problem: When this procedure runs, which makes an insert into table pbk.prisregister, it inserts the same value in field substitut where there exists a substitut. Please help me with this? It should be null in

RE: 9ias Vs IIS

One of the best examples of the IIS security problem would be the recent [EMAIL PROTECTED] virus! That thing spread like the plague, and was a REAL pain in the ar$e to get rid of! Web servers STILL have problems with this virus - even today! Proof of the pudding is in our web logs, which run on

Enable the partitioning option in database?.

Title: Enable the partitioning option in database?. -Original Message- From: Nirmal Kumar Muthu Kumaran Sent: Wednesday, November 28, 2001 4:56 PM To: '[EMAIL PROTECTED]' Subject: enable the partitioning option in database?. hI GURUS' How can i enable the partitioning option in

Re: 9ias Vs IIS

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 13:26 You never hear much about security patches in Apache or OMNI HTTPD or some other web server.. which does not mean they're more secure it just means that the

RE: Duplicating a Database and Changig SID

Hi! Before I tell you procedure, be aware that when you make a clone of your database DBID remains the same, which is a problem if you use RMAN for you backups. Steps are: 0. On your database issue: alter database backup controlfile to trace resetlogs; 1. Backup your database.

RE: failed to extend rollback segment ??????

Your Rollback Segment is NOT large enough. You don't have to shut down the DB just yet. You can remove ALL your test data without an INSERT (which creates RollBack entries) by using TRUNCATE TABLE x where 'x' is the name of your Table. Martin -Original Message- sinavalda Sent: 29

Re: failed to extend rollback segment ??????

It might be still creating the records, Also I suggest you truncate the table rather than delete the table its usually quicker and then delete after the truncate Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services

Comments on RMAN

What is the general consensus from the list on using RMAN? Pros? Cons? Any previous experience with problems as a result of using RMAN versus cold and hot backups. I would appreciate your inputs. Thanks in advance. Belinda K. Taylor Database Analyst, Database Support Database Application

RE:Determinants of control file

you can user Alter database backup controlfile to trace and then can have a look at all the desired parameters which was set while creating the database Binay --- Hi all, The determinants(size) of control file are maxdatafiles, maxlogfiles. maxlogmemebers, etc., But

Re: Delete slowing..

Be aware that at least for V7.3.4.5 the SQL ALTER INDEX index_name REBUILD automagically COMPUTES STATISTICS even if you are using CBO. Mark Leith wrote: Hi all, Thanks for your responses on this - I had most of them in mind - but there were a couple out there (PCTUSED/PCTFREE and

RE: Standby Database

There may be some solutions available at the hardware level as well.. For example-SRDF on an EMC cabinet... and define the online redo logs/archive logs as part of the data transfer.. But there are performance problems with that as well. greg -Original Message- Sent: Thursday,

RE: Please Help - user details of the sql statement being run not being found

Viraj, Do please read the manual on Outer Join theory. Also be consistent with your Column Alias usage. Martin -Original Message- Luthra Sent: 29 November 2001 06:35 To: Multiple recipients of list ORACLE-L not being found Okay I am answering my own problem, but for the :- 1st

RE: 9ias Vs IIS

Try the cert website they may have some incident data http//:www.cert.org HTH Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.Mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238

RE: 9ias Vs IIS

So which would you rather use? That's what all this boils down to.. Would you rather use a less secure (yes I *DO* believe it is less secure) larger target, or the alternative that is stable and less of a target? I know what my choice is.. -Original Message- Dimitrov Sent: 29 November

Statistics not updated

Hi DBAs The DB is 8.1.5 on Solaris under CBO. The statistics for some of the tables are getting updated after issuing analyze table. I tried with dbms_utility also but no result. What could be wrong? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: Siebel - ODB.

Title: RE: Siebel - ODB. Lisa, One arguement I lost regarding business rules (foreign keys) in the application, rather than in the database was that it made the application "database independent", not relying on database tools that might exist in one database but not another. In theory,

RE: Please Help - user details of the sql statement being run not being found

Viraj, I actually wrote this query yesterday for a collection for our tool: select s.sid SID, s.serial# SERIAL, s.username USERNAME, a.address ADDRESS, a.buffer_gets BUFFER_GETS, a.executions EXECUTIONS, t.piece PIECE, t.sql_text

Re: Comments on RMAN

I have used rman exclusively for all backups since I started with Oracle. It was very buggy before 8.0.6 but after that it is very stable. It is well worth learning, I can send you some articles about is if you would like. You can't send attachments on the list. Regards, Ruth - Original

RE: failed to extend rollback segment ??????

This query may be helpful; particularly the t.used_ublk column Kurt Wiegand IBM Global Services Cable Wireless Communications, Vienna VA 703 760-3619 -- page 10-30 from DBA admin class -- current activity -- select s.username, t.xidusn, t.ubafil, t.ubablk, t.used_ublk, s.sid from v$session

Re: Comments on RMAN

Belinda, We are using RMAN in conjunction with Netbackup, Veritas on Sun Solaris 2.6 and Oracle 8.0.4, 8.1.5, and 8.1.7.x databases. RMAN is a bit of work to set up. The lower-level RMAN commands are a bit cryptic and take some getting used to. However, once you get your scripts set up and

RE: MS SQL Server to Oracle Problem

What is stored in the SQLServer table? Maybe you could look at creating the field as some form of LOB? Maybe the data will fit in to a large VARCHAR2 field? With databases like Access and SQLServer you can have multiple columns in a table of datatype MEMO or whatever the SQLServer equivalent is -

RE: Standby Database

Excellent post Don! This one's going straight in to my special folder :P -Original Message- Granaman Sent: 29 November 2001 08:05 To: Multiple recipients of list ORACLE-L Quick question, long answer... You are not only making sense, you have hit the primary issue with the Oracle

RE: Comments on RMAN

Ruth, I'd be interested in those articles if you don't mind? Cheers Mark -Original Message- Gramolini Sent: 29 November 2001 13:05 To: Multiple recipients of list ORACLE-L I have used rman exclusively for all backups since I started with Oracle. It was very buggy before 8.0.6 but

RE: Delete slowing..

Does this mean that if you are running in RULE, you shouldn't REBUILD indexes, but drop and recreate them? You learn something new every day.. Cheers Mark -Original Message- Mengler Sent: 29 November 2001 12:41 To: Multiple recipients of list ORACLE-L Be aware that at least for

RE: enable the partitioning option in database?.

Title: RE: enable the partitioning option in database?. i didn't find the directory ORACLE_HOME\rdbms\lib itself... there is one directory jlib, but in that there is no 'make' file my system is ora817 on win nt. any help pls. -Original Message- From: Molina, Gerardo

Re: Standby Database

Ditto this. Pretty much exactly what I suspected, but I was certain someone here had dealt with this already and might have better insight. Thanks, Ed - Original Message - Excellent post Don! This one's going straight in to my special folder :P -- Please see the official

RE: 9ias Vs IIS

Just do a search for IIS security issues on google, also check out Gartner's web site. There was an article about a month ago where Gartner actually recommended to stay away from IIS for shops that are not already running it ... Sunny Verghese [EMAIL PROTECTED] on 11/28/2001 11:03:37 PM

Re: Delete slowing..

Hi Mark, It actually shouldn't matter if you are really in RULE, but in Choose, where you expect to have and NO STATS performing using RBO by default, you should issue the command analyze index index-name delete statistics After rebuilding the index. Hope this helps, John [EMAIL

Re: Comments on RMAN

I thought I had another one but I can't find it. It was done by Michael Abbey of Pythian Consulting of Ottawa, Canada. His presentaion was entitle something like 'If you don't use rman now you will' and explained how rman uses oracle internals to avoid problems. Regards, Ruth - Original

RE: Standby Database

This sounds good, but I have a couple of questions. How do you guarantee that you won't lose any committed transactions? I mean, the C program could lag behind the LGWR since it's only reading it without lock and it's copying the online redo over to a remote machine. So for a busy database,

Re:RE: Siebel.

Henry, I am sorry to have to admit it, but my experience with third party software is that all of them don't want to imbed their referential integrity into the database. I like you also believe it is because they do not have any kind of data model, never mind a 'proper' one Although the

RE: Delete slowing..

Not necessarily. You could rebuild and then analyze and delete the statistics. -Original Message- Sent: 29 November 2001 14:25 To: Multiple recipients of list ORACLE-L Does this mean that if you are running in RULE, you shouldn't REBUILD indexes, but drop and recreate them? You

RE: CROSS TAB QUERY

Title: RE: CROSS TAB QUERY What Oracle version? Also, is the requirement for pure SQL or can there be some PL/SQL? Tony Aponte -Original Message- From: Moses Ngati Moya [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 3:15 AM To: Multiple recipients of list

RE: Comments on RMAN

Mark, If you have already received the papers from Ruth, could you pl. forward them to me ? I would really appreciate it. thanks Santi -Original Message- Sent: Thursday, November 29, 2001 5:55 AM To: Multiple recipients of list ORACLE-L Ruth, I'd be interested in those articles if

RE: Statistics not updated

Are you seeing 'UNABLE TO EXTEND TEMP TABLESPACE...' in your alert log? -Original Message- Sent: Thursday, November 29, 2001 6:05 AM To: Multiple recipients of list ORACLE-L Hi DBAs The DB is 8.1.5 on Solaris under CBO. The statistics for some of the tables are getting updated

RMAN, Netbackup question

Hi all, I have a question regarding RMAN working with Netbackup. Is it possible to kick off multiple streams to write to the tape? I tried through RMAN to have 4 channels, but they are queued at the Netbackup Server. I want them to go in parallel. Now, it seems that for the Class Type

Re: Comments on RMAN

Someone on this list recently referenced the paper Is RMAN Really Worth the Trouble? By Tim Gorman of SageLogix, Inc. It's fairly interesting. I don't have a soft copy, just a hard one. I can't remember where I found the copy I printed. I think if you search for it with Google, you will

GRANT REFERENCES

Hi All, I am trying to GRANT REFERENCES on a table that resides on a different database, on a different server. Is this possible and how do I go about doing it. TIA E.

RE: ORA-03113

Title: RE: ORA-03113 Why don't you want to want to take all the oracle processes down? I thought that's what you wanted to accomplish with shutdown immediate? Go ahead and issue Mladen's command and restart the database. It's the only way you can bring it down if you can't connect with

RE: Email through trigger

Title: RE: Email through trigger UTL_SMTP. -Original Message- From: Aldi Barco [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 11:05 AM To: Multiple recipients of list ORACLE-L Subject: Email through trigger Hi Listers, What is the oracle procedure / package

RE: backup unix script

I believe the it is as follows: Run SQL*Plus | THIS SHOULD NOT BE HERE | | database username | | | database password | | | | Redirect output to file filename.dat | | | | | Read input up to the

RE: Comments on RMAN

thanks Ruth. Santi -Original Message- Sent: Thursday, November 29, 2001 6:46 AM To: Multiple recipients of list ORACLE-L I thought I had another one but I can't find it. It was done by Michael Abbey of Pythian Consulting of Ottawa, Canada. His presentaion was entitle something like

ORA-03113

Hi All! I tried shutdown immediate and get ORA-03113. Now I can't connect to database. How I can take instance down? On this HP box 10 different databases. This command was posted some time back by Mladen: ps -fu oracle|grep -v PPID|awk '{ print $2; }'|xargs kill -9 It's will take all oracle

Email through trigger

Hi Listers, What is the oracle procedure / package to send an email through store procedure or trigger ? Tia. Aldi _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official

RE: RE: Siebel.

Another factor is that when RI was first introduced, people tended to overuse it and then performance was bad. I don't think this is such a problem today, but I think many ERP packages were either developed before RI was common to all SQL databases, or were discouraged by the initial problems.

RE: Multiple instances - Sun Solaris: shmsys and semsys settings

here is the excerpt from my /etc/system file, we currently have 12 instances on it. Be sure to apply the logic in the comments and not the actual values that I used. The settings will make sense to your SA. The logic comes from reading many papers on the subject (I have them around here

Re: Win2K Drive Mapping Question

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 28, 2001 19:03 Anyone know how to map more than 26 drives on Win2K workstation? I trying to map 36 servers to a workstation. for Win2k u could do this by using Distributed FS

RE: ORA-03113

You could always start a bit nicer and kill pmon, wait a couple of minutes to see if the others are brought down. They usually will as Oracle recognizes the instance failure. -Original Message- Sent: Thursday, November 29, 2001 8:35 AM To: Multiple recipients of list ORACLE-L Why

RE: ORA-03113

grep, then, for the instance you DO want to take down. or, ask Mladen again. I understand he likes taking things down! ;-) -Original Message- Hi All! I tried shutdown immediate and get ORA-03113. Now I can't connect to database. How I can take instance down? On this HP box 10

SYS vs SYSTEM

8.1.7 on W2000 select owner, table_name, tablespace_name from dba_all_tables; When I log into sqlplus as SYS is runs. When I log into sqlplus as SYSTEM I get the error table or view does not exit. What is happening here and how do I fix it? Thanks, Ken -- Please see the official ORACLE-L

RE: Siebel - ODB.

Title: RE: Siebel - ODB. Of course a well designed database should (??!!) be used by multiple applications. So ideally, constraints which are data driven (long term) would be in the database, and constraints which are application driven (business rules) would reside in the application. But

RE: Standby Database

Title: RE: Standby Database /begin_plug I usually don't do these kind of posts... but I've seen a lot of activity on this topic lately. What is really the problem we are trying to solve here? Maybe we are using the wrong tool. If you are looking for data protection in the event of a

RE: RE: Siebel.

Just curious, but which of the major RDBMSs don't have RI? Henry -Original Message- Sent: Thursday, November 29, 2001 10:55 AM To: Multiple recipients of list ORACLE-L Another factor is that when RI was first introduced, people tended to overuse it and then performance was bad. I

RE: RE: Siebel.

Another good one is when they change the application from flat files to an RDBMS.. And then continue to forget all about relational database theory.. Love it!! -Original Message- [EMAIL PROTECTED] Sent: 29 November 2001 14:50 To: Multiple recipients of list ORACLE-L Henry, I am

RE: Comments on RMAN

You can find this on Tim's web site www.evdbt.com Barb -- From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 8:35 AM To: Multiple recipients of list ORACLE-L Subject: Re: Comments on

RE: backup unix script

my, that's attractive! ;-) -Original Message- Sent: Thursday, November 29, 2001 11:15 AM To: Multiple recipients of list ORACLE-L I believe the it is as follows: Run SQL*Plus | THIS SHOULD NOT BE HERE | | database username | | |

Re: RE: ORA-03113

If I'll apply this command it's will take all oracle processes down for every instance in this box? Thanks. [EMAIL PROTECTED] 11/29 10:35 AM Why don't you want to want to take all the oracle processes down? I thought that's what you wanted to accomplish with shutdown immediate? Go

RE: SYS vs SYSTEM

Hi Ken, My guess is that you need to set up sys.dba_all_tables with a public synonym. HTH Van -Original Message- Sent: Thursday, November 29, 2001 11:50 AM To: Multiple recipients of list ORACLE-L 8.1.7 on W2000 select owner, table_name, tablespace_name from dba_all_tables; When

Snapshot Problems

Good Day. I have a problem with recreating some snapshots. I would like to add to the current set of snapshots. They were created in the following manner: create snapshot snap_test as select * from test@test_DB; They are executed nightly in the following manner: execute

Oracle DBA Team Leader Needed in Milwaukee

Oracle DBA Team Leader Years Exp: 5+ years Location: Milwaukee, WI Compensation: Competitive Package Prod Offered: Financial Services Candidates local to the Greater Milwaukee area preferred but all will be considered. This is a full time staff position so no sub-contractors or third parties

RE: Comments on RMAN

Did anyone else get an error while trying to open the RMAN pdf file? David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide Inc. 4815 Emperor Blvd., Suite 110 Durham, NC 27703 Tel. (919) 941-4645 Fax (919) 474-0735 Email mailto:[EMAIL PROTECTED] Web

RE: GRANT REFERENCES

I haven't done it with the REFERENCES privilige but with others the following will work: 1. create the same user account with the same password in the other database. 2. grant the appropriate permissions to that user. 3. refer to the table with @servicename or create a synonym with the

RE: Comments on RMAN

Title: RE: Comments on RMAN It's here, halfway down http://www.evdbt.com/library.htm -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:35 AM To: Multiple recipients of list ORACLE-L Subject: Re: Comments on RMAN Someone on

RE: Statistics not updated

No. -Original Message- Sent: 29 November 2001 15:30 To: Multiple recipients of list ORACLE-L Are you seeing 'UNABLE TO EXTEND TEMP TABLESPACE...' in your alert log? -Original Message- Sent: Thursday, November 29, 2001 6:05 AM To: Multiple recipients of list ORACLE-L Hi DBAs

OT : 9ias Vs IIS

- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 14:40 So which would you rather use? apache Would you rather use a less secure (yes I *DO* believe it is less secure) larger target, or the alternative that is

RE: Standby Database

Title: RE: Standby Database Shareplex is a great tool, i have heard anecdotally. Of course, it ain't cheap, either. Both facts need to be addressed. Is there any interest in sharing that kind of sales information? For, say, a Sun 6500, 12 processors, 8GB RAM, "shareplexing" to

RE: CROSS TAB QUERY

Title: RE: CROSS TAB QUERY I gave it a whack and came up with the following solution (I needed the distraction). For demo purposes each statement build upon the previous ones. But first a little reality. There are some problem boundaries that can be declared. The first one is that there are

Re: SYS vs SYSTEM

Van M. Etheridge wrote: Hi Ken, My guess is that you need to set up sys.dba_all_tables with a public synonym. HTH Van -Original Message- Sent: Thursday, November 29, 2001 11:50 AM To: Multiple recipients of list ORACLE-L 8.1.7 on W2000 select owner, table_name,

Re:RE: RE: Siebel.

Sounds like the path NAI's predecessor took with Support Magic. WHAT A MESS Dick Goulet Off to buy a new shovel, wonder why? Reply Separator Author: Mark Leith [EMAIL PROTECTED] Date: 11/29/2001 8:45 AM Another good one is when they change the

RE: RMAN, Netbackup question

Richard-I've seen ti done before.. But I can't remember the details. I had a couple of guys on my team at a previous shop do it. Greg -Original Message- Sent: Thursday, November 29, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Hi all, I have a question regarding

RE: RE: ORA-03113

Title: RE: RE: ORA-03113 Yes, you are right. If you have multiple instances change the command to something like this, assuming your sid name is SID ps -fu oracleSID|grep -v PPID|awk '{ print $2; }'|xargs kill -9 Try it without the xargs kill -9 to verify it's choosing what you need.

RE: RMAN, Netbackup question

I think you need to configure your NetBackup class to handle multiple streams. -Original Message- Sent: Thursday, November 29, 2001 11:23 AM To: Multiple recipients of list ORACLE-L Richard-I've seen ti done before.. But I can't remember the details. I had a couple of guys on my

RE: Email through trigger

The package is UTL_SMTP Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Aldi Barco Enviado el: Thursday, 29 November, 2001 11:05 AM Para: Multiple recipients of list ORACLE-L

RE: Listers meeting at OOW

OK I'll be there too but I'm not local anymore :-) See Ya! Loco in Montana, Steve Orr -Original Message- Sent: Wednesday, November 28, 2001 1:26 PM To: Multiple recipients of list ORACLE-L Hi all, Are the locals driving down to SF from parts of the Bay Area? (methinks we will have

RE: RE: ORA-03113

Title: RE: RE: ORA-03113 Lisa, ps -fu oracleSID - command would not work. The reason is when you -u option with ps, it looks for the user by name mentioned. In this case, there would not be any user by name oracleSID (most likely). All the oracle processes would be owned by the user

RE: 9ias Vs IIS

Try sans Also do a search in google for isn news or for IIS hacking or IIS security, I'm sure you will come up with something. Yahoo, C|Net, Wired, Register also have articles on IIS, I am convinced. You can also go to www.microsoft.com/security http://www.microsoft.com/security and do a graph

RE: enable the partitioning option in database?.

I should have mentioned that my comments were for UNIX platform. I recommend calling Oracle Support to see if there are equivalent commands for NT platform. Gerardo -Original Message- Sent: Thursday, November 29, 2001 6:30 AM To: Multiple recipients of list ORACLE-L i didn't find

  1   2   >