Re: Oracle Real Application Clusters

Is it possible to download the ORAC software from some site, if so where from..?

Re: Port usage?

Don Oracle is doing the normal ting : it is using port 1521 for calls to find the listener and then calling back on another port to spread the load over multiple port's. This is done a port has a limited queue to hold in- and out- coming messages. If you what to use Oracle listener and

RE: oracle or mssql

goodmorning everybody who responded to my basic question : thanks summary professional : use oracle enterprise edition semi professional : use oracle standard edition / mssql enterprise edition in all other cases mssql standard edition -Oorspronkelijk bericht- Van: Mohammad Rafiq

how many async_io processes to invoke? - AIX ora 7.3

list, to give async_io a boost, i increased the minimum server parameter in AIX to 15 (from 2) .. now while doing a ps -Al i see only 4 kproc which are busy !! rest has ZERO excution time infront of them.. !! how do i determine the optimum number of minimum async_io servers for a db which

Re: Port usage?

we had the same problem and we found that oracle use the standard port only to make the initial connection. All the traffic after that is done on different ports. So you need to open the range that oracle use in the firewall. Yechiel Adar Mehish - Original Message - To: Multiple

RE: Download Oracle 7.3.4

Although, you should *apparently* be able to load the 7.3.4 version of SCO on Linux - or maybe that's just an urban myth! Yes, i remember installing the first version of 8 on Linux (hey I had some time on my hands) and it was a bit of a nightmare - back to the days when Oracle had 2 hits on

Re: Port usage?

the firewall should use sqlnet proxy. most firewalls support it and if this one doesn't scrap it! only the initial connection is made on port 1521. [EMAIL PROTECTED] 10/24/02 05:44AM we had the same problem and we found that oracle use the standard port only to make the initial connection.

Suse 7.1 Oracle 8.1.7

Good day to everyone * After installing 8.1.7 on Suse 7.1 there is glibc patch from technet that has to be applied... No problems here... But, after applying 8.1.7.4 patch do I have to run glibc patch once again? * Does Suse 7.1 (and it's utilities tar, gzip...) together with ext3 file

secure connection

Hi, how can I be sure that the connection between our web server and Oracle Server to be secure. What's the best method to accomplish this? Any good links for Oracle Nwtwork Security. Any help would be greatly appreciated. Murat -- Please see the official ORACLE-L FAQ:

RE: Deploying a 6i Form to the web

There are a number of technical articles on Metalink re. this. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique

Oracle Server with Linux client

We are having a client machine with Linux as OS. Our Oracle server is installed on Windows NT. Does Linux support Oracle Developer 2000. If so how do we connect our linux client with oracle server ? Is there any difference in configuration of Net 8 (tnsnames.ora) If yes then pls give the

what is purify

ORA-01008:not all variables bound

While executing the following database trigger (update) we are getting the following error message ORA-01008:not all variables bound. We are working on Oracle 8.0.3 We have written this trigger to get the column name,old and new values of fields of a table (locmast) while updating. We do not

Re: Oracle Server with Linux client

On Thursday 24 October 2002 14:49, you wrote: We are having a client machine with Linux as OS. Our Oracle server is installed on Windows NT. Does Linux support Oracle Developer 2000. I don't know. If so how do we connect our linux client with oracle server ? Download Oracle for Linux and

RE: what is purify

Now in a dump, Oracle see's something called purify and want us to disable it to see if that makes a difference. Never heard of purify - what is this?? A product which checks memory allocation - that you are not writing at an address location you have freed or that you have no memory leak.

Re: DB monitoring using SNMP MIBs

Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group

Re: Oracle Real Application Clusters

On Wed, Oct 23, 2002 at 03:19:21PM -0800, Tim Gorman wrote: A couple of anecdotes to consider: a.. Some folks from the Oak Table forum (www.oaktable.net) recently (last July) constructed a 10-node cluster of Linux laptops right on the conference floor at Oracle Open World in Copenhagen,

SGA larger than 4GB

This is a multi-part message in MIME format. --=002_Dragon320551784160_= Content-Type: text/plain; charset=GB2312 Content-Transfer-Encoding: quoted-printable hi, list friends: About SGA , shmmax, ISM on solaris Sun Solaris 7 64bit oracle Unix Kernel Parameter: /etc/system set

RE: Oracle Real Application Clusters

Title: RE: Oracle Real Application Clusters If I remember right we had some problems with gsd and nfs ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't

Re: Oracle Server with Linux client

On Thu, Oct 24, 2002 at 04:49:28AM -0800, [EMAIL PROTECTED] wrote: Does Linux support Oracle Developer 2000. -- Look on metalink under Certify Avaiability. Linux is not listed. === Ray Stell [EMAIL PROTECTED] (540) 231-4109

RE: Theory v Practice

Thanks for all your comments (especially the ones that made me laugh). Now at least I have some input from experienced people to put before my boss. Craig -Original Message- From: Craig Healey Sent: 23 October 2002 18:45 To: Multiple recipients of list ORACLE-L Subject: Theory v

RE: DB monitoring using SNMP MIBs

MIB, hey I saw that movie too. ;o) -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at

RE: Download Oracle 7.3.4

Oooo! I forgot about the SCO. I never tried it but I had read about it. Those were the days eh? -Original Message- Sent: Thursday, October 24, 2002 5:39 AM To: Multiple recipients of list ORACLE-L Although, you should *apparently* be able to load the 7.3.4 version of SCO on Linux -

RE: Oracle Real Application Clusters

Here are the papers I found. A word of caution: these are written by sales critters so as a hard-core techie if you read more than 3 papers your head will explode. http://technet.oracle.com/deploy/availability/techlisting.html http://technet.oracle.com/deploy/availability/techlisting.html

Re: Oracle Real Application Clusters

NetApp is NFS; so are all current NAS products... The phrases NetApp and cheap are *always* used together -- it is their most compelling feature. CFOs love NetApps. For database usage however, they are best used in non-demanding situations (i.e. low I/O volumes). The phrase filer is very apt

RE: Theory v Practice - and business logic...

As this topic just hits my hot button, I'm going to chime in my 2 cents worth in as well. This in spite of the fact that you have already gotten some great responses. I come from an environment where we have distributed data all over creation. IMS, DB2, Oracle, you name it we have it popping up

RE: what is purify

See: http://www.rational.com/products/purify_nt/index.jsp I think this is what they are talking about. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and

RE: DB monitoring using SNMP MIBs

The list could be hard for me to get . unless someone else knows where they are. I will see what I can get. -Original Message- Sent: Wednesday, October 23, 2002 6:19 PM To: Multiple recipients of list ORACLE-L Kevin, This is great! Can we get a list of all the OIDs that Oracle

Re: secure connection

Hire a special company that handle this. We are doing it to see how unbreakable are our servers. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 2:08 PM Hi, how can I be sure that the

Re: Oracle Real Application Clusters

On Thu, Oct 24, 2002 at 05:43:38AM -0800, Jamadagni, Rajendra wrote: If I remember right we had some problems with gsd and nfs ... could you elaborate? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please

RE: Suggestions solicited - Change Column Datatype from Number to

Could you preserve the constraints and indices if you do somthing similar like create table temp as select * from table1 nologging TRUNCATE table table1

RE: Suggestions solicited - Change Column Datatype from Number to

Dennis, That's a good thought, and it works if you don't have grants, constraints or dependencies on the original table. If you drop table1, you lose them all Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Deepak, If there are many columns on these tables, your method may be best.

RE: RMAN - It's Here

I buy lots of books from Bookpool!! :-) I buy from Amazon too but those are normally non technical books. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and

RE: [Q] wield create view error, need help?

Grant privileges on v_$sysstat dist cash

RE: Table Index sizing utility

Rick - I'm sure there are a lot of good sizing programs around. And hey, awhile back I was just as anal as everyone else, struggling to estimate everything to the last K. I've got another idea for you to consider. If you switch to LMTs and autoextend, then you don't need to spend nearly as much

RE: RMAN - It's Here

Rachel, Thanks. Basically I don't like Amazon because of various reasons and my bad experience with them. Besides , we normally buy technical books at our own so everybody try to reduce their cost, Right Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list

RE: RMAN - It's Here

Rafiq, I was teasing... I buy books from discount places as well. Including bookpool Rachel --- Mohammad Rafiq [EMAIL PROTECTED] wrote: Rachel, Interesting, I never thought of it. I feel sorry for that if it is reducing royalty of Roberts, but my intention was different and to help

Find Queries by a group of users

Hi all, We were trying to find a way to get all queries by a group of users of the database. Auditing the users lets us know whether they ran a 'select' 'update' etc. but not the full text of the query. This is in 8i. 9i seems to have a view called DBA_FGA_AUDIT_TRAIL which has a SQL_TEXT

RE: Suggestions solicited - Change Column Datatype from Number to

Deepak, If there are many columns on these tables, your method may be best. However, this will generate a lot of redo. You can usually accomplish this with a CTAS nologging, which won't generate redo. If you really don't want to change the location, you can: create table temp as select * from

Re: LOCALLY MANAGED TABLESPACE

Seema, Our production Student Information database (8.1.7 under Win2k) has 40,000 tables and 60,000 indexes. It's a third party app designed for dBaseIV - go ahead and laugh, we do all the time (when we're not crying). Anyhow, we have to regularly clone out the data to a couple of other

RE: System Tablespace and Autoextend

Sam - I haven't made the system tablespace autoextend because I can't easily recover the space if it overextends. I would rather take the risk that something hits an error from a lack of space in the system tablespace. With other tablespaces you can always rebuild the tablespace if you need

Table Index sizing utility

Hi DBAs, Does anyone have a table index sizing utility program/script they can share? Also where can I find out exactly how much storage Oracle allocates for every datatype? I checked the concepts manual but could not find it. Thanks Rick -- Please see the official ORACLE-L FAQ:

RE: RMAN - It's Here

Rachel, Interesting, I never thought of it. I feel sorry for that if it is reducing royalty of Roberts, but my intention was different and to help others to reduce their cost of this book. Besides I am very much satisfied with the services/prices of bookpool.com Regards Rafiq

Re: Full Import/tablespace sizes

Mike, While not necessary, it would be a good idea to precreate the tablespaces. Else, for a clean import the first time, you would need to ensure that the directory structure for the datafiles exists, you have the permissions to create files at the OS level, ensure that files dont already exist

Re: System Tablespace and Autoextend

Sam, Autoextend caused tablespace corruption for me once, but it was over 5 years ago with Personal Oracle 7.3.2.3 on Win95 - not the most reliable OS that Oracle has ever ported to. ;-) We have several 8.1.7 databases here, on both Win2k and HPUX. Autoextend, even on System, has caused no

Re: Flat file generation integrity ideas...

Title: Flat file generation integrity ideas... I do not see how the file can get "scrambled". You write it out ok. The ftp is guaranteed. So what is the problem. I will go along with the suggestion to zip it. It saves on the ftp time and also gives you some protection. Yechiel AdarMehish

Suggestions solicited - Change Column Datatype from Number to Var

We have a need to change the datatype ofseveral columns in a table from number to varchar2.Most of the rows have data in these columns hence a direct 'alter table...' will not work. We plan to create a temp table, move the data from these colums to that table,modify the column datatype

RE: Full Import/tablespace sizes

Mike - Yes, you need to create those tablespaces first. If the tablespace isn't there, import will default to the default tablespace of the username that is running the import. Select bytes from dba_data_files to find the tablespace sizes. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL

RE: LOCALLY MANAGED TABLESPACE

Seema - While you are planning your conversion, be sure to carefully read the paper: How to stop defragmenting and start living: The definitive word on fragmentation by Himatsingka and Loaiza so you really understand how to receive the benefits of LMTs. It is available on http://www.hotsos.com

Re: System Tablespace and Autoextend

Hello Sam I do not know specifically about SYSTEM tablespace but from a bitter experience beware of the 4GB limit. if a datafile on NT/2000 autoextend beyond a multiple of 4GB (8,12...) then that datafile is GONE. We had a production database crashing on this problem and had to call in Oracle

Re: Full Import/tablespace sizes

Full import will rebuild the tablespaces. browse the export file and you will see the commands inside. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 9:25 PM To do an import from a full export of a

RE: Flat file generation integrity ideas...

Chris - If Tom's idea provides you the protection you require, with convenience to boot, then it sounds like you have a winner. I think all the suggestions provide some variety of checksum, a standard computer science technique. What are your requirements? Mainly to make sure the file doesn't get

RE: Flat file generation integrity ideas...

Title: Message Trouble with this is that there is a possibility that a change in the number in the file could result in the same sum. Then you have different data but your checks says everything is ok. Checksums are far more accurate. -Original Message-From: Grabowy, Chris

RE: LOCALLY MANAGED TABLESPACE

Title: RE: LOCALLY MANAGED TABLESPACE Metalink Note: 93771.1 -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Subject: LOCALLY MANAGED TABLESPACE Hi I am thinking to change our few

Full Import/tablespace sizes

To do an import from a full export of a database, do the tablespaces already need to be set up before the import? How can you query the database to get the tablespace name and the total space needed for each tablespace? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RV: Nuestra Profesión Ing. Sistemas

Ups colegas ! @lex Lic. Alexander Ordóñez Arroyo Soporte Tru64Unix BD Oracle Caja Costarricense del Seguro Social Telefono: 295-2004, San José, Costa Rica [EMAIL

RE: Flat file generation integrity ideas...

I will have to keep those in mind, if I ever get back onto a UNIX platform. Right now, I'm sticking to Tom's suggestion because I religiously follow KISS. Thanks!! -Original Message- Sent: Thursday, October 24, 2002 2:19 PM To: Multiple recipients of list ORACLE-L Chris - I would

RE: Flat file generation integrity ideas...

Title: Flat file generation integrity ideas... Chris; I would suggest the following: 1. Generating Check Sums of the files before they are sent. 2.Send the files. 3. Generating an after Check Sum and compare. Here are the steps I go thru to make sure our Oracle Archive Logs are

RE: Flat file generation integrity ideas...

Title: Message (slapping my forehead) Duh. Nice. I like it. Simple but effective. Minimal impact on performance. And easy for the other systems to implement. You da man, Tom, I don't care what Jared and Rachel said about you... Thanks. -Original Message-From: Mercadante,

RE: RMAN - It's Here

Why pay more, Try www.bookpool.com Oracle9i RMAN Backup Recovery Freeman, et al / McGraw Hill / 2002 / 0072226625 Our Price $30.95 ~ You Save $19.04 (38% Off) Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 24 Oct 2002

RE: QUERY?

Title: RE: QUERY? Without a clearer description of what it isn't doing, my WAG is missing permissions on the views or tables. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]]

RE: Flat file generation integrity ideas...

Title: Flat file generation integrity ideas... Chris, have you thought aboutsumming a number column in the record and placing this sum in a trailer record? this way, you have a header and trailer record which helps you be confident that the whole file made it to the target system. and by

RE: Flat file generation integrity ideas...

Chris - I would consider checksums. Many systems have built-in checksum functions. On Unix these are cksum and sum. You could probably write a simple one that would work on your various systems. Search for checksum and somewhere on the Internet is probably sample code for one in a language that

RE: QUERY?

Seema Have you run an explain plan? Your query will likely do a full-table scan of both tables. Are they large? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 11:40 AM To: Multiple recipients of list

Streams

Has anyone started using the Oracle streams feature? I'm wondering how this compares to Advanced Rep. I am guessing this approach will provide better performance but thought I'd check with the list to see if someone can confirm this. Thanks, Dave -- Please see the official ORACLE-L FAQ:

RE: QUERY?

Man, I can't think of a thing that would cause this. I'd suggest running tkprof or somesuch on the query in both environments but it probably wouldn't do any good. Comparing indexes? Nah, forget it. Not worth the time. What else, what else??? --Walt Weaver Bozeman, Montana -Original

RE: RMAN - It's Here

Title: RE: RMAN - It's Here do list members get a I post where you post discount? =) -Original Message- From: Freeman, Robert [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 10:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN - It's Here Just a note that

Re: Oracle Real Application Clusters

On Thu, Oct 24, 2002 at 06:53:27AM -0800, Tim Gorman wrote: NetApp is NFS; so are all current NAS products... The phrases NetApp and cheap are *always* used together -- it is their most compelling feature. CFOs love NetApps. For database usage however, The netapp sales guy I talked with

Re: Trivia question - not of any practical use.

The easiest solution I can think of is to set spool off within the script. Dennis Charu Joshi wrote: Dear Listers, Given below is a script that I execute from within SQL*Plus for WinNT: temp.sql: - set echo off set pagesize 0 set feedback off SELECT * FROM tab WHERE

Trivia question - not of any practical use.

Dear Listers, Given below is a script that I execute from within SQL*Plus for WinNT: temp.sql: - set echo off set pagesize 0 set feedback off SELECT * FROM tab WHERE ROWNUM 10; set pagesize 1000 set feedback on set echo on - While running it always displays 'SQLset echo off'

Oracle Performance Tuning (Book)

Any follks have reviews on the book Oracle Performance Tuning written by Edward Whalen Mitchell Schroter and published by Addison-Wesley? Saw a blurb in the recent issue of Ora Mag. Thanks mkb __ Do you Yahoo!? Y! Web Hosting - Let the expert

RE: Oracle Real Application Clusters

Title: RE: Oracle Real Application Clusters We had the user which owns oracle was nfs mounted across two machines using nfs. i.e. user oraclei home directory was nfs mounted across tow machines. When we used srvctl to start instances occasionally it used to hang when bringing up the 'other

RE: Activating batch file from a trigger on nt

Could you use an external procedure or java call? Metalink Tom Kyte's book have good examples. -Original Message- Sent: Thursday, October 24, 2002 9:29 AM To: Multiple recipients of list ORACLE-L Hello all How can I run startup.bat file when database is up. I tried using the HOST

Re: Theory v Practice - and business logic...

To me this comes under the heading of common sense. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 9:33 AM As this topic just hits my hot button, I'm going to chime in my 2 cents worth

Re: RMAN - It's Here

now now, play nice! --- Freeman, Robert [EMAIL PROTECTED] wrote: Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it.. hm let's see then Tim Gorman

Re: RMAN - It's Here

Where? Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 4:44 PM Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like

RE: DB monitoring using SNMP MIBs

Raj; Here is a link to the SNMP Support Reference Guide that Ray talked about for 8.1.7. I am sure its probably somewhere on your Documentation CD for your version. http://www.cosc.canterbury.ac.nz/docs/oracle/server.817/em.817/a85249.pdf All I did was search the web for Oracle SNMP Support

RE: what is purify

but we did not download or install it. [EMAIL PROTECTED] 10/24/02 10:39:07 AM See:http://www.rational.com/products/purify_nt/index.jspI think this is what they are talking about.RFRobert G. Freeman - Oracle OCPOracle Database ArchitectCSX Midtier Database AdministrationAuthor of several

Activating batch file from a trigger on nt

Hello all How can I run startup.bat file when database is up. I tried using the HOST command in trigger but it does not work. Something like: 'host d:\oracle\scripts\startup.bat' in the trigger. Win2000, Oracle 8.1.7 or 9.2.0. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ:

RE: RMAN - It's Here

Even more interesting is that I never saw the original comment from Rachel... my email to/from Oracle-L seems to really be slow! Thanks Rachel. Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com!

simple ? question

Hi Listers, I am trying to find a way to know the schema name. Say, if I logged in as jjin01@ngd. When I run a program, how can I get the schema name which should be ngd? If I logged in as bkrasnof@pr, in this case, the schema name will be pr. Thanks in advance, Joan -- Please see the

Re: Find Queries by a group of users

Johnson, Auditing, atleast in 8i, wont help. Maybe, if its not an overhead, you could have a logon trigger that enables tracing for those users. Raj

RMAN - It's Here

Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it.. hm let's see then Tim Gorman wrote it. RF Robert G. Freeman - Oracle OCP Oracle Database Architect

Flat file generation integrity ideas...

Title: Flat file generation integrity ideas... I have to create packages that will generate several flat files of data from tables that will be sent to other systems to be processed. I am looking for ideas on how to ensure data integrity in the flat files. For example, the expected record

Re: Activating batch file from a trigger on nt

I solved the problem by: Call a Java function that sends the command to a service that activate the command as a process in NT. This was written by another of my team and can send the command to any computer on the NT network. I think that Joe asked about open window when applying archive logs

db_writer_processes/db_block_lru_latches

I read in Note:97291.1 that db_writer_processes/db_block_lru_latches could be set to match the number of cpus to try to impove db file parallel write waits. Are seperate controllers required for this to be effective? Any good refs on this topic.

Re: Trivia question - not of any practical use.

I don't get that when running on W2K. Are you executing a login.sql or glogin.sql script first? How are you invoking your temp.sql? Using the @ on the command line or redirecting input or typing it in directly? What version of sqlplus? I tried it with 8.1.6. Marc Perkowitz - Original

PDBA toolkit (from Perl for Oracle DBAs) question

Maybe someone beside the author can answer this question: I'm confused about how to connect to a database using Jared's PDBA toolkit. The various utilities specify command-line options -machine and -database. There's a PDBA::CM connection manager module that can be used to specify environment

RE: RMAN - It's Here

because the author's royalties are based in part on what the book sells for? just doing my part to keep Robert's kids fed :) --- Mohammad Rafiq [EMAIL PROTECTED] wrote: Why pay more, Try www.bookpool.com Oracle9i RMAN Backup Recovery Freeman, et al / McGraw Hill / 2002 / 0072226625

Re: LOCALLY MANAGED TABLESPACE LOCALLY MANAGED TABLESPACE LOCALLY MANAGED TABLESPACE LOCALLY MANAGED TABLESPACE

Why do you always SHOUT in your subject line? Or are you not aware of simple net-etiquettes? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 2:49 PM Hi I am thinking to change our few dictinary manages tablespace to

RE: Flat file generation integrity ideas...

Title: Message Yes, Melissa also mentioned this to me. I will have to look into that function...along withthe million other procedures and functions that Oracle has. At this point, Tom's suggestion seems to be the simpliest/effective/fastest. Any other suggestions? -Original

RE: System Tablespace and Autoextend

I run my SYSTEM tablesaces in autoextend, and have for some time. I run them that way from the point of database creation and have never had a problem. There were some problems with autoextend in earlier versions of 8 (and I think they managed to migrate to early 8i versions as well) with 2GB

System Tablespace and Autoextend

Hello All, I have heard several times that if the SYSTEM tablespace runs out of space and needs to autoextend (assuming autoextend is turned on for the data file), then you run the risk of the database crashing and of data dictionary corruption. I have never personally encountered this problem,

RE: Flat file generation integrity ideas...

Title: RE: Flat file generation integrity ideas... you could also use dbms_utility.get_hash_value ... to compute hash value for the whole row and store that as an additional column. Be syre to use the same parameters on both sides to compute and test, else it will fail the check. Raj

RE: QUERY?

Hi, What error are you getting? Just saying 'not running in production' doesn't give any clue to answer. Regards, Sandeep -Original Message- Sent: Thursday, October 24, 2002 12:40 PM To: Multiple recipients of list ORACLE-L Hi Can some one suggest whats wrong in this query?The same

RE: QUERY?

Different data? Missing indexes? What do you mean Something's Wrong? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, October 24, 2002 12:40 PM To: Multiple recipients of list ORACLE-L Hi Can some one suggest whats wrong in this query?The same query

RE: RMAN - It's Here

Amazon.com, Oraclepressbooks.com, etc... Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you.  

Re:RE: oracle or mssql

As I said, use mssql ONLY if your boss is willing to be strapped into a MicroSlop only platform. If he's even remotely thinking of using a different OS then you can't use mssql. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 10/23/2002

RE: secure connection

Sorry for the mistake. the question was wrong. :( The right question should be : How can I secure the connection between our web server and Oracle Server? Is there any chance to solve this issue with Oracle related solutions or should I use IPsec or smth like that about network security. Murat

RE: secure connection

These days . just hire a 15 year old kid with a computer at home He might do beter than an expensive 'security firm' ... -Original Message- Sent: Thursday, October 24, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Hire a special company that handle this. We are doing

  1   2   >