RE: Export question on excluding certain schema

Raj - Assuming you are using an export parameter file (file.prms). Instead of the FULL=Y parameter, use OWNER=(USER1,USER2,USER3, . . . Unfortunately export doesn't offer the capability to say full except for mdsys, ctxsys, if that is your question. You can also do a full export and then

RE: Replication question

Thanks, John. Do you know what mechanism causes the internal triggers to fire? Are the internal triggers created by catrep.sql, or by DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT for each table? Does the RDBMS have to determine whether --- John Weatherman [EMAIL PROTECTED] wrote: Paul, The

RE: Export question on excluding certain schema

Title: RE: Export question on excluding certain schema Dennis, I received a reply from Kirti that by tweaking catexp81.sql file we could just achieve that. This is possible because all we have to do is tweak a view that dictates what will be exported. It looks like that will solve my

RE: Replication question

The jobs are used to propogate the captured transactions. The transactions are captured by the packages called by the internal triggers. PAX, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, September 05, 2002 10:28 AM To: Multiple

RE: Replication question

I once noticed this code which is executed (for each column?) when you create a table. Would it be related to replication? BEGIN 2. /* NOP UNLESS A TABLE OBJECT */ 3. IF dictionary_obj_type = 'TABLE' THEN 4.

RE: Export question on excluding certain schema

Raj - Great! That one is beyond me, but Kirti is certainly the expert, so were I you, I'd try his suggestion. Good luck. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 05, 2002 10:23 AM To: Multiple recipients of list ORACLE-L

RE: Replication question

Paul, Dispite being internal the triggers are triggers just like any others. INSERT, UPDATE, DELETE all fire the package (all the transactions you want to move). I have NEVER been clear on the relationship between these triggers and user defined ones, sence you suposedly can't control the

RE: Export question on excluding certain schema

NO! NO! NO! Please... I am not an expert. I just remembered this trick that I learned from the real experts (like Anjo, X$KGopal ...) I simply passed on what I had learned from others. Cheers! - Kirti -Original Message- Sent: Thursday, September 05, 2002 12:08 PM To: Multiple

RE: Export question on excluding certain schema

Title: RE: Export question on excluding certain schema Also, by default, in Oracle 8.1.6 MDSYS and CTXSYS are already excluded from the export, so no editing of catexp.sql is needed to do what the original poster wanted to do. # grep MDSYS $ORACLE_HOME/rdbms/admin/catexp.sql u$.name

RE: Export question on excluding certain schema

Title: RE: Export question on excluding certain schema Thanks for the info. Learned something new. Dennis : That proves I am no expert ;) - Kirti -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 05, 2002 2:29 PMTo: Multiple

RE: Export question on excluding certain schema

Title: RE: Export question on excluding certain schema Missed that too ... Thanks Jacques Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect

Re: Unix Question

-- Pawan Dalmia [EMAIL PROTECTED] My var partition is 99% full of which there are lot of files in /var/tmp directory. Can i delete this files ? Probably. Older ones are a better bet: cd /var/tmp; find . -atime +7 -type f | xargs rm -f; Question is what job leaves files behind

RE: import question

Do not believe him :) -Original Message- Sent: Monday, July 29, 2002 10:38 AM To: Multiple recipients of list ORACLE-L If the Export has been taken with DIRECT = Y, meaning that the SQL Evaluation buffer has to be bypassed then Import would not generate the Redo buffer while

Re: rman question(allocating channels)

Joe, I have the same situation. I my case I used 2 channels, and so around a 25-30% decrease in thebackup time for a 30gb database. Once I increased it to 3 channels the payback was minimal. It also became very cpu intensive, so I kept the setting at 2. - Original Message -

Re: rman question(allocating channels)

Rman channels are like processes, and you can have multiple channels writing to one disk and reading from one disk in a restore, If your server has the horsepower, then multiple channels will increase the speed of backups and restores, HTH, Ruth - Original Message - To: Multiple

RE: rman question(allocating channels)

Joe, We only write out to tapes, so one channel equals one tape drive, each extra channel goes and gets another drive. Not too sure about disks, I guess it depends on I/O bandwith. Two channels will be faster than one, if the disk can cope with the input from two channels then maybe it

RE: rman question(allocating channels)

Yep its me answering a question for you for a change - I was able to bounce your questionoff of Dinis (our RMAN guru)and he said: ( Yeah I could have pretended that I knew the answer but I don't think you would have fallen for that!) Channels are streams. Basically when you have multiple

RE: rman question(allocating channels)

Joe - 1) Why do you feel writing RMAN backup to one disk is not ideal? Is it the one disk, or disk vs. tape? 2) I would watch the I/O while it is running to see how close you are coming to maxing out your I/O subsystem. 3) I suspect, but haven't investigated, that RMAN defaults are

RE: Unix question: how to display SID and path in prompt

: RE: Unix question: how to display SID and path in prompt Mladen, Your magnificent intuition and superior powers of reasoning have finally failed you. I've never touched VMS. ;) Jared Gogala, Mladen [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/26/2002 01:28 PM

RE: Unix question: how to display SID and path in prompt

Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 7:13 PM To: Multiple recipients of list ORACLE-L Subject: RE: Unix question: how to display SID and path in prompt Mladen, Your magnificent intuition and superior powers of reasoning have finally

RE: Unix question: how to display SID and path in prompt

-- [EMAIL PROTECTED] Obviously. If you had worked on VMS, why would you want to emulate it? Actually the platform had a number of virtues -- file versions not the least, along with separate system access. DCL itself had some nice features, if they'd only added pipes it would've been

RE: Unix question: how to display SID and path in prompt

Subject: RE: Unix question: how to display SID and path in prompt -- [EMAIL PROTECTED] Obviously. If you had worked on VMS, why would you want to emulate it? Actually the platform had a number of virtues -- file versions not the least, along with separate system access. DCL

RE: Unix question: how to display SID and path in prompt

PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Steven Lembark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: RE: Unix question: how to display SID and path in prompt

RE: Unix question: how to display SID and path in prompt

-- Jesse, Rich [EMAIL PROTECTED] Starting in VMS 7.0 or 7.1 (I forget which), you *can* use pipes: $ GREP := SEARCH SYS$PIPE $ PIPE SHOW SYSTEM | GREP ora_ And it gets even better with SET PROCESS/PARSE=EXTENDED on the Alphas... :) Uncle Kenny's ghost can enjoy them; the rest

RE: Unix question: how to display SID and path in prompt

: Tuesday, August 27, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: RE: Unix question: how to display SID and path in prompt -- [EMAIL PROTECTED] Obviously. If you had worked on VMS, why would you want to emulate it? Actually the platform had a number of virtues

RE: Unix question: how to display SID and path in prompt

-- STEVE OLLIG [EMAIL PROTECTED] on 08/27/02 12:23:30 -0800 but the syntax IS annoying and tedious at best. speaking as a *NIX bigot who landed a job with a fair share of legacy VMS work that needs doing. it really pisses me off when i type SHOW SYSTEM/FULL instead of ps -efl on my sun

RE: Unix question: how to display SID and path in prompt

-Original Message- From: STEVE OLLIG [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Subject: RE: Unix question: how to display SID and path in prompt but the syntax IS annoying and tedious at best. speaking as a *NIX

Re: Unix question: how to display SID and path in prompt

-- Daiminger, Helmut [EMAIL PROTECTED] Hi! In my .profile of the oracle user (we're mostly using ksh here), I have set up the prompt that it gives me the host name and database SID. # always displays host name and Oracle SID as prompt PS1=`hostname`;`echo $ORACLE_SID`$ How can I

Re: Unix question: how to display SID and path in prompt

Title: Unix question: how to display SID and path in prompt Put $PWD in there somewhere. I use ${PWD#${PWD%%*([!/])/*([!/])}} to display the last two directory levels, so my prompt never gets TOO long. The substring extractionof $PWD is ksh specific. You could do it other ways, but this way

RE: Unix question: how to display SID and path in prompt

, August 26, 2002 10:03 AMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B Re: Unix question: how to display SID and path in promptBRBR/FONT/DIV DIVFONT face=Arial size=2Put $PWD in there somewhere. I use ${PWD#${PWD%%*([!/])/*([!/])}} to display the last two directory levels, so my

Re: Unix question: how to display SID and path in prompt

-- Philip Douglass [EMAIL PROTECTED] The substring extraction of $PWD is ksh specific. You could do it other ways, but this way it uses ksh builtins, so it is _fast_ bash and most recent sh imlementations also support the ksh-style variable munging. bash makes it even simpler by adding

RE: Unix question: how to display SID and path in prompt

by: [EMAIL PROTECTED] 08/26/2002 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Unix question: how to display SID and path in prompt Also be aware that when using backticks in your PS1 variable, you

RE: Unix question: how to display SID and path in prompt

/jkstill/tmp ] 10:2-rsysdevdb:dv01:jkstill-3 Jared Curiel, David [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/26/2002 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Unix question: how

RE: Unix question: how to display SID and path in prompt

-L Subject: RE: Unix question: how to display SID and path in prompt Also be aware that when using backticks in your PS1 variable, you are influencing $? as a result. I don't find that to be true with pdksh - PD KSH v5.2.14 99/07/13.2 function go { \cd $1 typeset -Z2 _h

RE: Unix question: how to display SID and path in prompt

-- Curiel, David [EMAIL PROTECTED] on 08/26/02 12:03:20 -0800 Jared Writes: Also be aware that when using backticks in your PS1 variable, you are influencing $? as a result. I don't find that to be true with pdksh - PD KSH v5.2.14 99/07/13.2 And, what's more, you don't need to

RE: Unix question: how to display SID and path in prompt

PROTECTED] cc: Subject:RE: Unix question: how to display SID and path in prompt Jared Writes: Also be aware that when using backticks in your PS1 variable, you are influencing $? as a result. I don't find that to be true with pdksh - PD KSH v5.2.14 99/07/13.2

RE: Unix question: how to display SID and path in prompt

-L [EMAIL PROTECTED] cc: Subject:RE: Unix question: how to display SID and path in prompt Jared, the alias cd='go' line immediately betrays you as a former VMS person. Next thing you know and your aliases will be like set_def -Original Message- From: [EMAIL

RE: Unix question: how to display SID and path in prompt

To: Multiple recipients of list ORACLE-L Subject: RE: Unix question: how to display SID and path in prompt Mladen, Your magnificent intuition and superior powers of reasoning have finally failed you. I've never touched VMS. ;) Jared Gogala, Mladen [EMAIL PROTECTED

RE: Unix question: how to display SID and path in prompt

-- John Kanagaraj [EMAIL PROTECTED] Mladen, Are you confusing this on account of your new-found attraction to the 'go' command in MS SQL Server (formerly Sybase and T-SQL)? :-) I though that 'SET DEFAULT [Dir-name]' was the equivalent of 'cd' in VMS... They have nothing whatsoever to

Re: Simple question on logging..

ALTER TABLE yourtable NOLOGGING - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 14, 2002 4:33 PM Hi Gurus, How can I turn off logging for a table in Oracle7.3 database. Iam planning to reorg thru ctas and want to use

RE: Simple question on logging..

Title: RE: Simple question on logging.. -Original Message- From: Peter R [mailto:[EMAIL PROTECTED]] How can I turn off logging for a table in Oracle7.3 database. Recoverable/unrecoverable is not a persistent attribute in 7.3.4 The unrecoverable option only applies

RE: NLS Question

NLS is defined in database creation. You can check your NLS configuration executing this SQL command as sys. SELECT * FROM SYS.V_$NLS_PARAMETERS; Regards. -Original Message- Sent: sexta-feira, 9 de Agosto de 2002 16:33 To: Multiple recipients of list ORACLE-L All, when running an

RE: NLS Question

Aha, there you are. Since I have to do a Character set conversion pretty soon, I have done a bit of research(read RTFM) on this just today. The message means that since the character set in which the export was done and the charcter set in which the dtabase to which you are importing don't

RE: NLS Question

That's what I though, so if it's not explicitly in my environment, not in the init.ora and not in the create statement itself, where exactly is my nls getting miss-set at creation?! TIA, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Friday,

RE: NLS Question

Thanks, Naveen, I am fortunate in that I am trying to move us from US to WE, WE being a superset of US, so I am not too concerned with corruptions. What does worry me is that I have set my NLS Lang to WE and the database still seems to be building US, which doesn't make lots of sense. Thanks,

RE: NLS Question

Hi John, Thanx for the good luck. What I understand of your problem, is that there are 2 different things. One is Character set and the other is National character set. National Character set determines the data inside NCHAR and Other N-Fields(NCLOB and likes) and character set determines data

RE: Replication Question

So how do I get into the archives? I've got a question I know I've seen answered. Thanks, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services

RE: Replication Question

John - I've noticed that Google queries pull up info from the archives. Obviously you'll get other stuff, but if you can make your query pretty specific it may get you what you need. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 30, 2002

RE: import question

If the Export has been taken with DIRECT = Y, meaning that the SQL Evaluation buffer has to be bypassed then Import would not generate the Redo buffer while Importing back the objects and the relevant data. While Export it just bypasses the SQL Evaluation buffer,make it faster and directly put

RE: import question

Vikas, Where did you find this information? I would appreciate any and all references. Thanks. - Kirti -Original Message- Sent: Monday, July 29, 2002 9:38 AM To: Multiple recipients of list ORACLE-L If the Export has been taken with DIRECT = Y, meaning that the SQL Evaluation

RE: import question

Title: RE: import question If the Export has been taken with DIRECT = Y, meaning that the SQL Evaluation buffer has to be bypassed then Import would not generate the Redo buffer while Importing back the objects and the relevant data. Very interesting, except that I believe you

RE: import question

Hi, I've never seen anything to suggest that exportijng using DIRECT=Y speeded up subsequent imports. I'd be interested to know if this is really the case but I doubt it. The structure of an export file is exactly the same whatever the DIRECT setting. But I've been wrong before ... Things I'd

RE: import question

Title: RE: import question Dan: I believe the SQL on the outbound is eliminated. With DIRECT=Y, the Kernel performs I/O direct to the DMP file versus generating the SELECT statements to retrieve the data and then write out the data. Thats why exports take far less time with DIRECT=Y

RE: import question

From the 8.1.7 docs: Direct path Export extracts data much faster than a conventional path export. Direct path Export achieves this performance gain by reading data directly, bypassing the SQL command processing layer and saves on data copies whenever possible. In a direct path Export, data is

RE: SQLLDR question SOLVED

Thanks for all the help. It turns out there was a problem with the data and the field seperator was part of the data in one of the fields. -Original Message- Sent: Friday, July 26, 2002 10:33 AM To: Multiple recipients of list ORACLE-L I am trying to load data via sqlldr (8.1.6.3 on

RE: SQLLDR question

Terry, I tried the following in 817 and it worked fine: LOAD DATA INFILE * INTO TABLE test REPLACE FIELDS TERMINATED BY ',' TRAILING NULLCOLS ( col1 char , col_seq test_seq.nextval ) BEGINDATA 'one', 'two', (sorry about the first email - fingers slipped!) Do you get an error in the

RE: SQLLDR question

I'm not a sqlloader expert, so take with a large grain of salt. If you are using conventional path, a series of 'insert' statements are executed. This may cause the to be interpreted as the variable indicator. If you are using direct path, it may create a block of rows and then directly place

Re: ANALYZE question

Thanks all for your advice. Will check an option to do estimate. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 24, 2002 7:23 PM At the last Open World I attended a couple of sessions where the general advice

RE: dbms_stats question

Well, the results seem to indicate that the saved statistics are taken before gathering new statistics. When I read the documentation, I see stattab User stat table identifier describing where to save the current statistics. I guess this can be read as save the current statistics in

RE: ANALYZE question

An export has default parameter of STATISTICS=ESTIMATE. If such an exported file is imported , the default import parameter ANALYZE=Y will result in the import utility executing the analyze stmts in dump file. -Original Message- Sean Sent: Wednesday, July 24, 2002 2:33 PM To: Multiple

Re: ANALYZE question

dbms_stats --- O'Neill, Sean [EMAIL PROTECTED] wrote: Apart from explicity running an ANALYZE command against a table, what, if any, other events/actions can cause an analyze to be run on the table? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest

RE: ANALYZE question

No Impact. Analyze would just collect the latest statistics for the concerned table and the next time any query gets fired on this table the optimizer (CBO) would generate the execution plan based on these statistics. I also believe that this would be healthier sign as the CBO is generating

RE: ANALYZE question

DBMS_STATS can be used to analyze tables. Dave -Original Message- Sent: Wednesday, July 24, 2002 4:03 AM To: Multiple recipients of list ORACLE-L Apart from explicity running an ANALYZE command against a table, what, if any, other events/actions can cause an analyze to be run on the

RE: ANALYZE question

PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Subject:RE: ANALYZE question DBMS_STATS can be used to analyze tables. Dave -Original Message- Sent: Wednesday, July 24, 2002 4:03 AM To: Multiple

Re: ANALYZE question

: RE: ANALYZE question DBMS_STATS can be used to analyze tables. Dave -Original Message- Sent: Wednesday, July 24, 2002 4:03 AM To: Multiple recipients of list ORACLE-L Apart from explicity running an ANALYZE command against a table, what, if any, other events/actions can

RE: ANALYZE question

Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 10:55 AM To: Multiple recipients of list ORACLE-L Subject:Re: ANALYZE question This message uses a character set that is not supported

Re: ANALYZE question

| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 24, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Subject: RE

Re: ANALYZE question

recipients of list ORACLE-L Subject: Re: ANALYZE question This message uses a character set that is not supported by the Internet Service. To view the original message content, open the attached message. If the text doesn't display correctly, save the attachment to disk, and then open

RE: ANALYZE question

] -Original Message- Sent: Wednesday, July 24, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: ANALYZE question DBMS_STATS can be used to analyze tables. Dave -Original Message- Sent: Wednesday, July 24, 2002 4:03 AM To: Multiple recipients

RE: ANALYZE question

] -Original Message- Sent: Wednesday, July 24, 2002 9:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: ANALYZE question DBMS_STATS can be used to analyze tables. Dave -Original Message- Sent: Wednesday, July 24, 2002 4:03 AM To: Multiple recipients of list

Re: ANALYZE question

At the last Open World I attended a couple of sessions where the general advice for 9i DB is to use ANALYZE ESTIMATE without specifying ANY value. A few brief comparision tests did show that it got better results than the alternatives tested. As always, YMMV HTH HAND! -- Please see the

Re: Perl Question - Split using |

-- Celine John [EMAIL PROTECTED] on 07/05/02 06:43:25 -0800 After seeing the e-mails about Perl for Oracle-DBAs, I presume, my question wouldn't be completely inappropriate for this list. So if you Oracle Gurus, can help me with this Perl problem, I would greatly appreciate it. I have

Re: Perl Question - Split using |

Don't escape if it's in a variable. Ask yourself why you have to escape it when used literally. Jared On Friday 05 July 2002 07:43, Celine John wrote: After seeing the e-mails about Perl for Oracle-DBAs, I presume, my question wouldn't be completely inappropriate for this list. So if you

Re: Perl Question - Split using |

Hi Celine, After seeing the e-mails about Perl for Oracle-DBAs, I presume, my question wouldn't be completely inappropriate for this list. So if you Oracle Gurus, can help me with this Perl problem, I would greatly appreciate it. I have a problem with split when my delimiter is |.

Re: Perl Question - Split using | - Resolved

Wonderful! Thanks for all who responded. I always count on you guys. --- Andy Duncan [EMAIL PROTECTED] wrote: Hi Celine, After seeing the e-mails about Perl for Oracle-DBAs, I presume, my question wouldn't be completely inappropriate for this list. So if you Oracle Gurus, can help

Re: Perl Question - Split using |

my $HeaderAttributes = abc|defgh|123; $HeaderAttributes =~ s/\|/\\|/g; On Fri, 5 Jul 2002, Celine John wrote: After seeing the e-mails about Perl for Oracle-DBAs, I presume, my question wouldn't be completely inappropriate for this list. So if you Oracle Gurus, can help me with this Perl

Re: Perl Question - Split using |

Well, I guess this is why Andy's name is first on the book. ;) Jared Andy Duncan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/05/2002 08:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re

RE: Forms Question

It is in forms 5 and 6 -Original Message- Sent: Thursday, June 27, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Is it possible to order by a non-base table item in a form? Michael Cupp, Jr. Shonac Corporation 4150 East Fifth Avenue Columbus Ohio 43219 Phone: 614-238-4240

RE: Forms Question

I'm running 6, how would I go about it? -Original Message- Sent: Thursday, June 27, 2002 12:29 PM To: Multiple recipients of list ORACLE-L It is in forms 5 and 6 -Original Message- Sent: Thursday, June 27, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Is it possible

Re: RMAN QUestion

Hi Can autobackup of control file be NOT enabled? If you do full database backup using RMAN you get the controlfile like it or not, isn't it? So i'd say a because with b you don't automatically get the controlfiles Jack

RE: Replication question

-Original Message- From: Lowes, Harry (NESL-IT) [mailto:[EMAIL PROTECTED]] Sent: 21 June 2002 13:37 To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Peter, Great idea, but would you care to share the impact of these triggers on performance? I think it's a good

Re: REPLICATION QUESTION - LOng and strange

Sakthi , Raj wrote: Hi Listers, alright I've exhausted almost all my resources and I am turning to my last resource. We have 3 databases. Database A - OLTP Database B - OLTP Database c - DSS ORACLE 8.1.6.3 ON HP-UX 11.0 Database A has a table which is being

Re: RMAN QUestion

I'll bite I don't have a clue about RMAN and you say it is a trick question. I think control files from time a and time b are the same and should work. At 08:47 AM 6/21/2002 -0800, you wrote: Sorry, posted using wrong subject header, DUH! Use the following Exhibit to answer this question

RE: Replication question

Interesting comments on replication - but something hit me between the eyes. Primary Keys should NEVER, EVER be permitted to be updated, whether you are using replication or not. Its a basic tenent of relational design. We have been using triggers to prevent this for years. peter edinburgh

RE: Replication question

Peter, Great idea, but would you care to share the impact of these triggers on performance? I think it's a good principle to follow, but have always found triggers a little unwieldy for most operations myself. I would have thought this to be the case here, but I'd like to hear your experiences

RE: Replication question

ps. you work with Elmer Cecelio? -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Andrew Sit [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:19 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Dennis et al

RE: Replication question

, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Just a note, Johanna. We put all of our Oracle Replication metadata into separate tablespaces, and had absolutely no problems. Brian -- | Brian

Re: sequence question

Hello Bp If you use the sequence for unique identifiers only, you do not need to worry about this. At most the numbers will go from 1234 to 11234 and continue from there. So what? Yechiel AdarMehish - Original Message - From: BigP To: Multiple recipients of list

RE: RECOVERY QUESTION

Harvinder - If you select from DBA_DATA_FILES, you will probably see those tablespaces as having a MISSING location. Take them offline if you like. Not a big deal, I have run a lot that way on test databases. Of course, if anyone tries to access the tablespace they get an error. Dennis Williams

RE: Replication question

[EMAIL PROTECTED] Sent: Thursday, June 20, 2002 10:33 AM To: Multiple recipients of list ORACLE-L Subject:RE: Replication question Yechel - Wow, what a blow to be struck with the dreaded RTFM first thing in the morning. Thanks Yechiel, I needed that. Actually, I

Re: RECOVERY QUESTION

Harvinder I think u have to restore complete from cold backup and create controlfile including 3 datafiles also and bring back to database and then u can drop tablespaces. OR at current stage.did u status in check v_$datafile and v_$tablespace dictionary table ? Thx -Seema From: Harvinder

RE: Replication question

: [EMAIL PROTECTED]@SUNGARD On Behalf Of Brian McGraw [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Just a note, Johanna. We put all of our Oracle Replication metadata into separate tablespaces

RE: RECOVERY QUESTION

sirry , it should be v$datafile and other table dba_data_files etc.. -Original Message- Sent: Thursday, June 20, 2002 2:17 PM To: Multiple recipients of list ORACLE-L Seema, there is no reference to these 3 tablespace and files in v$database or any other system table

RE: DBMS_SYSTEM.KSDWRT question

Title: RE: DBMS_SYSTEM.KSDWRT question Thanks Tony, I have been told not to use standard auditing ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't

RE: DBMS_SYSTEM.KSDWRT question

Addition: DBMS_SYSTEM.KCFRMS - resets counters displayed by MAX_WAIT in V$SESSION_EVENT, and MAXIORTM, MAXIOWTM in V$FILESTAT views. - Kirit -Original Message- Sent: Thursday, June 20, 2002 2:33 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Raj, Here is a trial run with those

RE: DBMS_SYSTEM.KSDWRT question

Thanks Kirti ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is

Re: Replication question

On Behalf Of Brian McGraw [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Just a note, Johanna. We put all of our Oracle Replication metadata into separate tablespaces, and had absolutely

Re: Replication question

On Behalf Of Brian McGraw [EMAIL PROTECTED] Sent: Thursday, June 20, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Replication question Just a note, Johanna. We put all of our Oracle Replication metadata into separate tablespaces, and had absolutely

Re: INITRANS question

INITRANS reserves block header control blocks for each row potentially locked in the block by a transaction. Find out how many rows there are on average in your data blocks and that is the absolute maximum you need for INITRANS for that object. Of course, in reality you would most likely be

Re: sequence question

Bigp Remember that when you issue sequence.nextval you are incrementing one value and eitheryour process function corrector not that number is used. But, the more important is that if your system crash or you issue an SHUTDOWN ABORT you will loose the sequence numbers cached. Also you can

<    1   2   3   4   5   6   7   8   9   10   >