Then in that case sounds like the 3 opt files are needed. I haven't ever used more than one and all went to one filespace. May have been more than one DB (I don't know, never asked DBA) but each machine had ONE application.
May have to make some changes in Oracle RMAN for this too, DBA should have info on that. David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockledge, FL 32955-4305 PH 321.434.5536 Pager 321.634.8230 Fax: 321.434.5509 [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 10/24/02 11:16PM >>> Then how do I create distinct filespaces for each database as is suggested? -----Original Message----- From: David Longo [mailto:David.Longo@;HEALTH-FIRST.ORG] Sent: Thursday, October 24, 2002 3:46 PM To: [EMAIL PROTECTED] Subject: Re: TDPO.OPT/filespace Question No, not unless you have a reason for doing so. Like if these DB's are for different applications or something like that. It depends on your DBA's requirements and how Oracle and RMAN is setup. More complicated to do it with 3, so don't unless necessary. David Longo >>> [EMAIL PROTECTED] 10/24/02 02:05PM >>> I have 3 Oracle databases (DB1, DB2, DB3) that reside on SERVERA. I'm going to call the client SERVERA_ORA. Should I point to 3 distinct tdpo.opt files so I can create 3 distinct file spaces? 'ENV=(TDPO_OPTFILE=.../DB1/tdpo.opt)' 'ENV=(TDPO_OPTFILE=.../DB2/tdpo.opt)' 'ENV=(TDPO_OPTFILE=.../DB3/tdpo.opt)' Any suggestions would be appreciated. thx. -jgw- "MMS <health-first.org>" made the following annotations on 10/24/2002 03:47:39 PM ------------------------------------------------------------------------------ This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ============================================================================== "MMS <health-first.org>" made the following annotations on 10/25/2002 09:43:29 AM ------------------------------------------------------------------------------ This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. ==============================================================================
