Accessing DB2 data from Oracle.

Hi all. I need to be able to query data from a db2 database and match he results up to an Oracle statement. Does anyone know if this can be done, and if so, how it can be done? Thanks Clint -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Clinton Naude INET: [EMAIL P

Re: basic question about db_name and sid

SID identifies instance, whereas db_name identifies database. It is possible that two or more instances point to one database. HTH, Krishna - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 25, 2002 6:04 PM > First, it is true th

RE: important question about SID environment variable (NT)

Are you talking about ORACLE_SID? It gets stored in the registry under HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> HOME If you want to set it via environment variables so that it is accessible to all DOS shells for a particular login, you can right click on MY COMPUTER, go to PROPERTIES -> ENVIRON

Re: The future DBAs?

Arup Nanda wrote: Fellow DBAs and other DBA wannabes, Ever wondered the best path into a DBA career? Microsoft offers a brilliant way. MSN Careers at http://editorial.careers.msn.com/articles/nofuture/ suggests some jobs are effectively dead, like farmers and sewing machine operators and how

Re: Usage error in your E-mail to mailing list 'ORACLE-L'

What! Are you an IDIOT?! On Monday 25 November 2002 09:25, Farnsworth, Dave wrote: > HELP > > -Original Message- > [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 25, 2002 10:29 AM > To: Multiple recipients of list ORACLE-L > > > SET ORACLE-L NOMAIL > > -- Forward

Re: The future DBAs?

Wow! Do they offer a detailed plan for your career path from taking orders at LL Bean to storage/networking/data modeling/computer wrangling /SA intimidating/Managerial confusing/Vendor chucking/scripting god/ put-together-an-entire-infrastructure-during-a-break/space eating/ caffeine freaking/Sc

RE: redo log file setup with mirrored drives

Having multiple redo log members has its advantages. The archiver process 'knows' these multiple members and it will optimize the archiving process, but it does not know about the mirrored copies of these logs. The other important thing to know is that Oracle issues a separate write for these lo

RE: converting to the cost based optimizer

Title: RE: converting to the cost based optimizer Raj,  Thanks for a nice post :)   All,   In 8.1.7.4 there is a CBO bug that was recently posted on the Metalink. Bug # 2669913 (CBO PRODUCES DIFFERENT EXPLAIN PLAN USING LIKE 'AR%' AS OPPOSED TO 'ARC%' ). You may want to check it out.   -

RE: how do I calculate the Oracle's usage

Try Statspack ... - Kirti -Original Message- Sent: Monday, November 25, 2002 5:29 PM To: Multiple recipients of list ORACLE-L Even though the name of the statistic is "CPU used by this session," the v$sysstat view contains aggregated data of the statistics of all sessions that have ever

Re: Slightly OT - Who would you take with you...

Robert, As others have pointed out, this can be dangerous! Right now my inbox has about 700+ messages saved from lots of posters, I'd save more but Yahoo has a 6MB limit and I haven't had time to archive off messages... anything that I think might be useful, regardless of the poster. I try to rea

RE: Mass updates to production tables (NULL to non-NULL)

Larry, We are using partitioned tables in our update process, and I did not get enough time to think about the partition exchange solution (I recall you had mentioned this before). I was out of office for too long and Developers had already tested the 'cursor' based approach for these updates. A

RE: Mass updates to production tables (NULL to non-NULL)

How true !! I just ignored the 'writing' part of the parallelized 'reading'. Sorry. Thanks for catching it, Waleed. Our own update process, that I am baby sitting, was on my mind that involves a few partitioned tables... Regards, - Kirti -Original Message- Sent: Monday, November 25,

RE: Mass updates to production tables (NULL to non-NULL)

PDML can be used only on partitioned segments. When PQO is used during an update on a non-partitioned segment, the parallel processes (slaves) work together to scan (read) the segment and find the rows that need to be updated. these rows get communicated back to the master process using the rowid.

RE: basic question about db_name and sid

First, it is true that you can have a different SID than your database name. This is usually not recommended because it causes a lot of confusion, but it is possible and there may be some reason out there to have them different. In that case I wouldn't be the one who can tell you why. The SID

redo log file setup with mirrored drives

Hi: We have oracle 8173 running on Sun Solaris box. The current redo files are: /oracle/oradata/RPT1/redo101.log /oracle/oradata/RPT1/redo201.log /oracle/oradata/RPT1/redo301.log /oracle/u01/oradata/RPT1/redo102.log /oracle/u01/oradata/RPT1/redo202.log /oracle/u01/oradata/RPT1/redo302.log The me

The future DBAs?

Fellow DBAs and other DBA wannabes, Ever wondered the best path into a DBA career? Microsoft offers a brilliant way. MSN Careers at http://editorial.careers.msn.com/articles/nofuture/ suggests some jobs are effectively dead, like farmers and sewing machine operators and how the experts in that

Re: How are rollback segments assigned?

Here's one scenario: 4 transactions, 2 rollback segs tx 1 - rbs1 tx 2 - rbs 2 tx 3 - rbs 1 tx 4 - rbs 2 tx1 and tx3 finish. tx2 and tx4 have not yet committed. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/25/2002 07:39 AM Please respond to ORACLE-L To: Multiple

RE: Slightly OT - Who would you take with you...

You are taking a poll to find out which messages are most important and worth saving? How does that work? I keep messages containing helpful scripts, messages which eloquently and precisely explain and or demonstrate Oracle concepts and programming, messages on areas of which I am ignorant

RE: Mass updates to production tables (NULL to non-NULL)

If you're going the PDML route, don't forget to increase the initrans of the tables and indices, since each Parallel Execution slave will have its own entry into the block transaction list, and this in itself could result in that annoying ORA-01555 error we see. Regards : Ferenc Mantfeld

RE: Mass updates to production tables (NULL to non-NULL)

Kirti, The snapshot too old error you mention really hits home. I guess it's because the error message is somewhat misleading, leading to a knee-jerk reaction for the developer (and some DBA's) to start committing *more* frequently, thus increasing the chances of the 1555 error. 99% of the time, b

Re: Sr. Oracle DBA Position- Must be 8i and 9i Certified-

It could have been because they were aliens(either the non-US citizen type or the outer space kind, since neither need apply). It had to be said, it had been a while since I made reference to spaceships, etc. Bwahahahhah joe Stephen Andert wrote: I guess the response wasn't overwhelming if

RE: Slightly OT - Who would you take with you...

Are you sure you want to go down this road and get into subjective disagreements with folks over this in front of everybody ? -Original Message- Sent: Monday, November 25, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Robert Freeman Anjo Kolk Cary Millsap Connor McDonald Kirti

RE: Mass updates to production tables (NULL to non-NULL)

I would consider PDML to get the job done faster, provided there are enough resources. Using a cursor seems like a good idea, but avoid fetching across commits. We are going through a similar exercise, adding 1000 to a cust_id field to denote the source of the data, and Developers complained

RE: 1M STRIPE SIZE BEST?

Thanks Cary. For some reason I was only considering large writes, as in a DW. Just hadn't had enough coffee yet. The 2+ makes sense due to Parity. Jared "Cary Millsap" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/23/2002 07:48 PM Please respond to ORACLE-L To: Mul

RE:

Have the other guy do the following: If on UNIX, strings | grep 'CREATE TABLE' > table_names.lst else perform a dry imp run with indexfile= option. If the table existed then the generated file will have CREATE TABLE command (as a comment in the latter case). - Kirti -Original Mess

Re: Mass updates to production tables (NULL to non-NULL)

You may have to worry about chaining. NULL columns use no space, even when they are CHAR() types. If you are planning a counted cursor loop, don't. You can update by rowid ranges (the slightly harder way) but one simple option is: update tableX set col_name = ' ' where col_name is n

Re: LONG's

Mike, Conner pointed out that you could use C. You can also use Perl with DBI and DBD::Oracle if you like, and have someone there that can use it. Why not just convert them to CLOB and LOB? Jared "Hand, Michael T" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 11/25/2002 07:59 AM Please

Re: Slightly OT - Who would you take with you...

Robert, I think your own emails would have to count as one of the "Top 10" people... Don't delete your "sent" folder! I've only been on this list for a short period of time (although I wish I had found it earlier) and I've noticed that there are several consistent posters of answers. I don't th

Re: how do I calculate the Oracle's usage

Even though the name of the statistic is "CPU used by this session," the v$sysstat view contains aggregated data of the statistics of all sessions that have ever logged into your instance since it started. For consistency, they use the same statistic names as are used by the session-level statistic

RE: Slightly OT - Who would you take with you...

Robert Freeman Anjo Kolk Cary Millsap Connor McDonald Kirti Deshpande Jared Still Jeramiah Wilton John Kanagaraj Waleed Khedr Ian MacGregor Rachel Carmichael Tim Gorman Well that is more than 10, there are plenty of others that should be on this list. I have these posters highlighted then sort by

basic question about db_name and sid

the "SID" is a string that identifies where to find the database. It is not necessarily the same as the database name. (here is the url from where i read this http://datavision.sourceforge.net/DataVision/create.html) first, is it true that sid need not be the same as the db name ? because in a ty

important question about SID environment variable (NT)

for NT4.0 ver 8i does a typical oracle install create the environement variable SID ? i just checked, via set command on windows NT. the env variable for SID is not set. though there are other oracle related env variables like path, classpath that point to various files of oracle install etc

RE: Mass updates to production tables (NULL to non-NULL)

It's actually being done for some sort of performance, since NULLs are not indexed. Although now it's suspect, since there are so many NULLs... Thx, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA >

Re:

David, Import with indexfile= and show=y should help. In message <[EMAIL PROTECTED]>, "Ehresmann, David" <[EMAIL PROTECTED]> writes List, Is there anyway to know absolutely that a table is not in an export file? My import bought in 6 tables, but not the seventh ( I don't think it is in the expo

Slightly OT - Who would you take with you...

Board - If you had to choose the 10 top posters here at Oracle-L who provided the biggest input and knowledge, who would they be? Who are the top 10 Oracle Guru's on this news group? I'm asking because my mailbox is FULL, and I have to trash a large amount of the stored stuff thats here. I'm go

RE:

You obviously know how to check it. Plain old egrep can parse the export file for CREATE TABLE too. It sounds like you might need to open up a commodity sized can of this stuff on the guy. http://www.squirtsplace.com/tackypics/wupass.html > -Original Message- > I can't convince this g

Re:

Do an imp show=y which simply shows the contents of the exp file without the rows. This way you can confirm that the table is not there. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 25, 2002 4:41 PM > List, > > Is there anyway

RE:

David; Try the parameter show=Y on the import command. This should show you whats in the export file. example parm file: FILE=('expdat.dmp') LOG=('temp.log') FULL=Y SHOW=Y -Original Message- Sent: Monday, November 25, 2002 3:41 PM To: Multiple recipients of list ORACLE-L List,

RE: BackupExec & Oracle

we use backupexec 8.6 and it does not lock oracle files on NT4 or win2k. if u use the purge options and create a archivelog purge job and u hv some antivirus s/w like norton, then the access times get messed up and backupexec is not able to pick up files properly. netbackup uses rman/ebu. back

RE: Mass updates to production tables (NULL to non-NULL)

What about creating a view with nvl(column_name,chr(32)) for the columns involved? Greg -Original Message- Sent: Monday, November 25, 2002 4:04 PM To: Multiple recipients of list ORACLE-L I've got a real hot project (8.1.7.2 on HP/UX 11.0) that needs to have NULLs converted to spaces on

RE: BackupExec & Oracle

Title: BackupExec & Oracle oh one more thing i failed to mention, recovery is a real pain. it will restore files with a very scre*** up names. it removes all backslashes and makes one whole big filename. u then need to do some surgery on it. it is not as simple as ebu/rman. i think they r do

[no subject]

List, Is there anyway to know absolutely that a table is not in an export file? My import bought in 6 tables, but not the seventh ( I don't think it is in the export). The import bought in the other 544 tables! I have queried under the schema name, after logging in as that user: select table_na

Re: LONG's

Mike, You could look at the COPY command - provided you don't mind the table name changing or living in a different schema. I guess you could do a copy and then an alter table ... rename command. The syntax for the copy command is along the lines of: copy from user/pass@sid to user/pass@sid cre

Re[2]:Anyone else had a Virus alert for Stephane Faroult's

BTW: I just got a message from Steve. Seems tht he uses Linux & Netscraper for mail so I doubt that it started from his end. So, anybody got an idea who the GD spammer on the list is??? Dick Goulet Reply Separator Author: "Bill CONNER" <[EMAIL PROTECTED]>

RE: Two bugs in 9202 (that bit us)

Title: RE: Two bugs in 9202 (that bit us) For the intermedia you can request a one off patch for 9202 ... last I checked it wasn't part of 9203 yet ... Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot

Mass updates to production tables (NULL to non-NULL)

I've got a real hot project (8.1.7.2 on HP/UX 11.0) that needs to have NULLs converted to spaces on three different columns. Each is a CHAR, so I shouldn't need to worry about chaining, since that column's full size has already been allocated in the block, right? But the first column has 1.2M NUL

Re: Anyone else had a Virus alert for Stephane Faroult's email ?

It probably is not coming from where it appears. We have an alias for a group of us that field questions on a particular application. Every once in awhile we get a message that this virus has been found in a message that we have sent (supposedly from this alias). Since we are not sending under that

RE: Klez Worm Info

The Klez worm fakes its from address. Try checking the offending message's header to see whom it is actually from. Things are not always simple. A short time ago, I was asked if I had a virus as someone was receiving multiple copies of mail I sent to either this list or lazydba. I made th

RE: BackupExec & Oracle

If you're using BackupExec to backup the server's filesystems as well as the Oracle DB, make sure it does NOT hit your database files directly. Some Winders admins don't understand that it'll lock the datafiles, redos, controlfiles, etc from the instance, causing all sorts of icky recovery scenari

Re: Anyone else had a Virus alert for Stephane Faroult's email ?

It's not from Stephane's computer (even if he were using a Windows machine). From Symantec's website: "The subject line, message bodies, and attachment file names are random. The From address is randomly-chosen from email addresses that the worm finds on the infected computer." I've never gotten

Re[2]: Anyone else had a Virus alert for Stephane Faroult's email ?

Stephane, Don't sweat it. Klez spoofs the sender in it's email, so it probably came from someone else's machine that had your email address somewhere on it. -rje S> Sorry for the trouble, folks, but I have trouble understanding. When I S> am answering the list, it is either from a Linux machine

Re: Replication Manager

Replication Manager is a part of DBA Studio on OEM with 8i; On OEM with 9i, the DBA Studio is gone; so the replication manager is on OEM Console. I use it, for a quick and dirty look at things. I don't use it to create replication objects etc. However thjat's simply becuase I never used it earlier

Re: Anyone else had a Virus alert for Stephane Faroult's email ?

Martin Kendall wrote: > > My Norton Antivirus reports that Stephane's email re. "How to pass > value from SQL*Plus to Unix scripts?" contains the W32.Klez.H@mm virus > in an "item" called stars-bkgrd. > > Anyone else had same alert ? > > Martin > > ---

RE: BackupExec & Oracle

Title: BackupExec & Oracle Lisa,   One of our database servers is identical to your setup - Win2K/8.1.7.2/Veritas BackupExec. You'll need to create an Oracle user in each database for Veritas to connect to instances and know what tablespaces/datafiles there. Only gotcha is the fact that this

RE: Oracle 10i features

I am confident that we will see some good things out of OEM in the future Knowing who is working on it now, and knowing what they have done in the past, I've got a high degree of confidence ...AND expectation!! :-)) Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Mi

RE: virus

Since I joined this list I've noticed the number of virus's that my email virus scan picks up has grown quite a bit 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, ar

RE: Problem doing RMAN backup of Clone?

Also, Oracle9iR2 has a new utility, DBNEWID, that allows you to change the DBID of a copied database safely. With it you can change: 1. The DBID 2. The DBNAME 3. A combination of 1 and 2. This utility is covered in pages 412-413 of my new RMAN book. Prior to 9iR2, you could also use (CAREFULLY)

Re: Sr. Oracle DBA Position- Must be 8i and 9i Certified-

I guess the response wasn't overwhelming if he is re-posting this again so soon. I wonder if they missed the whole discussion awhile back about the people who never heard from them after sending resumes. I use the frequency of these messages and the quality of the job as a barometer for the con

Re: how do I calculate the Oracle's usage

Wouldn't this only give me the statistics for MY current session? I'm looking for the data on all the running sessions. Gene --- Jeremiah Wilton <[EMAIL PROTECTED]> wrote: > How about you collect the following value from each > instance on the > host, wait a few hours, then collect the numbers >

Re:Anyone else had a Virus alert for Stephane Faroult's ema

Yep, love NAV. At 10:51 AM 11/25/2002 -0800, you wrote: YUP Dick Goulet Reply Separator Author: "Martin Kendall" <[EMAIL PROTECTED]> Date: 11/25/2002 7:14 AM My Norton Antivirus reports that Stephane's email re. "How to pass value from SQL*Plus t

Re: Oracle you have just received a card from .

If the below link is what I think it is, its a sleasy form of spam (as if there is nice form of spam). I received something similar from a friend a few weeks ago. The web site wants you to download some software so that you can "read" a greeting card from your friend. If you read the End Us

Re: my messages are not getting to list. trying to test

Your message was received by the list. At 10:41 AM 11/25/02 -0800, you wrote: ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see t

RE: Two bugs in 9202 (that bit us)

Well that's hardly acceptable for a current release. Is there a BUG filed for this to get the fix in 9.2.0.4 or a one-off patch? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message-

BackupExec & Oracle

Title: BackupExec & Oracle Hello Everyone! I found out on Friday that my backup strategy has been NULL AND VOID out in Las Vegas.  (Read:  Nothing has been written to tape lately.  Thanks, Guys)  I was also notified that "effective immediately" Veritas BackupExec is the software we are using

RE: how do I calculate the Oracle's usage

> > I'm trying to figure out how much of the srever's resources > > (CPU-wise) a database and the application You can try the following. Substitute the name of the database for "ABCD" in the awk command. On a multi-cpu box, the sum can be more than %100. ps -eo %cpu -o args | awk '$2 ~ /AB

DO NOT OPEN EMAIL I JUST SENT YOU!

It's a worm/virus - Do NOT try to view the ecard. JUST DELETE IT Sorry - hope you're well. bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Ca

Oracle-L you've received a greeting card emailed by .

Oracle-L, posted you an ecard greeting. Read your ecard by clicking here; http://www.Friend-Greetings.com/pickup.aspx?code=Oracle-L &id=2511024 Note: Oracle-L, Go get the ecard just emailed. -- Plea

RE: Oracle you have just received a card from .

What is this, flippin' "Virii Day" or what? Scott Shafer San Antonio, TX 210.581.6217 > -Original Message- > From: Jay Earle (DBA) [SMTP:[EMAIL PROTECTED]] > Sent: Monday, November 25, 2002 12:10 PM > To: Multiple recipients of list ORACLE-L > Subject: Oracle you have just receive

instance shutdown problem ? (please help)

John, Off the top of my head. Is correc tinit.ora being used and are Control files in expected locations? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] >>From: john <[EMAIL PROTECTED]> >> Date: Sat, 23 Nov 2002 15:21:26 -0800 (PST) >> Subject: instan

my messages are not getting to list. trying to test

 

Re:Anyone else had a Virus alert for Stephane Faroult's ema

YUP Dick Goulet Reply Separator Author: "Martin Kendall" <[EMAIL PROTECTED]> Date: 11/25/2002 7:14 AM My Norton Antivirus reports that Stephane's email re. "How to pass value from SQL*Plus to Unix scripts?" contains the W32.Klez.H@mm virus in an "it

Oracle-L you have received a greeting card emailed by .

Oracle-L, just emailed you a postcard. Retrieve your greeting by clicking this link. http://www.Friend-Card.net/pickup.aspx?code=Oracle-L &id=2511021 Note; Oracle-L, Go get the card just emailed. -- Ple

RE: HELP ORACLE TO INFORMIX

Title: RE: HELP ORACLE TO INFORMIX Want to quickly move Oracle table to Informix database using Oracle-INformix gateway.  Getting error ORA-02047 when trying to commit every 1000 rows - do we really need to commit after each 1 row

Re: Anyone else had a Virus alert for Stephane Faroult's email ?

I did! Thanks Ana E. Choto Systems Programmer American University e-Operations - Information Technology Phone (202) 885-2275 Fax (202) 885-2224 "Martin Kendall"

Sr. Oracle DBA Position- Must be 8i and 9i Certified-

Great opportunity for a Sr. Oracle DBA with 8i AND 9i certification to join this software industry leader in Charlotte, North Carolina. Base salary is in the 90-120K range and depends on experience. Relocation Assistance is provided. PLEASE Do Not send your resume for this position UNLESS you ha

RE: Anyone else had a Virus alert for Stephane Faroult's email ?

Yes. At my end, it was detected and stripped. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -Original Message- Sent: Monday, November 25, 2002 10:15 AM To: Multiple recipients of list ORACLE-L My N

Re: Anyone else had a Virus alert for Stephane Faroult's email ?

no alert, but the spam filter on yahoo dumped a different message from him into "bulk" mail as it was 122K deleted without opening, just in case --- Martin Kendall <[EMAIL PROTECTED]> wrote: > My Norton Antivirus reports that Stephane's email re. "How to pass > value from SQL*Plus to Unix scrip

Oracle you have just received a card from .

Oracle, recently sent you a postcard. Retrieve your postcard by using this URL. http://www.FriendGreetings.com/pickup.aspx?code=Oracle &id=2511021 Comment- Oracle, View the card just created. -- Please se

Replication Manager

Has anyone used Replication Manager with success? Any feedback on issues you may have run into would be greatly appreciated. Does it come bundled with OEM or is it typically on a separate CD as a Management Pack? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike S

RE: Oracle 10i features

ah, but the people working on it have changed. Gaja Krishna Vaidyanatha John Beresniewicz James Morle to name just a few --- "Johnston, Tim" <[EMAIL PROTECTED]> wrote: > I'm not sure I'd go that far... Old habits (and prejudices) die > hard... > > :-) > > -Original Message- > Sen

RE: Usage error in your E-mail to mailing list 'ORACLE-L'

HELP -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 10:29 AM To: Multiple recipients of list ORACLE-L SET ORACLE-L NOMAIL -- Forwarded by Linda Miller-Coker/JPMCHASE on 11/25/2002 10:19 AM --- Mailing List Admi

9i Lite

I wonder if there are any mailing lists out there for Oracle 9i Lite. Or for that matter, if any of you have used in the past or are using it now and would like to brainstorm once in a while on this topic. I struggle with its administration sometimes. If you can point me in a direction (other than

RE: A way to restore a DB

>From the rest of you message, I would say there is something wrong with the hardware setup of your database. If the setup is such that you can lose an entire database of nearly 4 TB, then your backup/restore speed is the LEAST of your problems. You disk striping and mirroring should prevent the

Re: Modify Table restrictions

Did you mean "constraints"? Check USER_CONSTRAINTS. To remove one: "alter table drop constraint..." Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 25, 2002 10:44 AM > Hello; > > Som

Two bugs in 9202 (that bit us)

Title: Two bugs in 9202 (that bit us) FYI, Oracle 9202 ... If you are using intermedia and have cursor_sharing to anything other than EXACT, oracle will start throwing ORA-600 errors. You can set it to EXACT (the only workaround) at session level if you want, but I recommend to set it in ini

Re: how do I calculate the Oracle's usage

How about you collect the following value from each instance on the host, wait a few hours, then collect the numbers again? You can then subtract the earlier values from the later values, and you'll have a good idea which instances are using more CPU relative to the others. SQL> select value from

RE: Oracle 10i features

I'm not sure I'd go that far... Old habits (and prejudices) die hard... :-) -Original Message- Sent: Saturday, November 23, 2002 9:24 PM To: Multiple recipients of list ORACLE-L Look for it to improve dramatically. I might even try to use it. Jared On Sunday 17 November 2002 06:13,

woohoo virus sent to the list

at least i got it(of course linux says:  "you want me to save that .scr file?"   bwaahhaahahha, linxu rulz.   Jared, it slipped thru because it was a .scr?  masked as a mime type .wav file?   just curious since fatcity is pretty draned good about catching those things.   joe  

RE: Problem doing RMAN backup of Clone?

You can change the DBID as mentioned in other messages. (see metalink doc id 174625.1) If you don't want to change the DBID, you can still backup the database using RMAN; you just can't use the same schema in the same rman catalog database as the original. You can: 1. Use a different catalog dat

Re: Problem doing RMAN backup of Clone?

Use following command to generate new dbid. dbms_backup_restore.zeroDbid(0) Read Note:164870.1 on metalink for complete procedure. HTH -Shaleen - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 25, 2002 7:05 AM > Unfortunately, t

RE: Problem doing RMAN backup of Clone?

Doug, I have successfully tested this method for changing the the dbid {gleaned from Ron Yount's procedure]. Changing the Dbid of copied database: Ron Yount from the Oracle-L provided the following steps if it becomes necessary to change the Dbid of a copied database to allow an RMAN catalog to ba

Re: instance shutdown problem ? (please help)

John If this is a new install then why dont you just do the install again. Otherwise you can use following STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "WMPROD" NORESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 500 MAXINSTANCES 10 MAXLOGHISTORY 3630 LOGFI

Re: Optimizer tuning parameter not working?

Generally you'll changes in the 'cost' figure when playing with Optimizer_index_cost_adj. If you change the permutations figure, you'd probably need to look at 10053 to see the differences going on... Oracle pretty rarely chooses a cartesian product (between tables of any siginificant size that i

Anyone else had a Virus alert for Stephane Faroult's email ?

My Norton Antivirus reports that Stephane's email re. "How to pass value from SQL*Plus to Unix scripts?" contains the W32.Klez.H@mm virus in an "item" called stars-bkgrd. Anyone else had same alert ? Martin smime.p7s Description: application/pkcs7-signature

Re: LONG's

Its called the C compiler :-) If the LONG's are not so long (ie less than 32k) you can get away with just plain old static PLSQL to get at the data, otherwise you can look at dbms_sql hth connor --- "Hand, Michael T" <[EMAIL PROTECTED]> wrote: > OK, so you can't CTAS on tables with LONG or LON

Modify Table restrictions

Hello; Somebody knows how to view the restrictions Of a table, and quit one of the restrictions? Thank you. Francisco Murillo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Francisco Murillo Montoya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-

Re: Do user processes apply against shmmax limit?

... and we butt headlong into another fine myth, that is that the SGA must fit into one segment. On Sunday 24 November 2002 15:53, Richard Ji wrote: > >if that SGA + user processes > shmmax the system will start swapping. > > That's not true. If your SGA is bigger than shmmax, it just means > t

LONG's

OK, so you can't CTAS on tables with LONG or LONG RAW columns, and now I find out that the same restriction exists on Alter Table ... Move.   So, is there any other option to move these tables from one tablespace to another without exp/imp or converting them to LOB?   Thanks, Mike This trans

virus

Somebody is using this list to send a virus, beware ! Jeroen -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Verzonden: maandag 25 november 2002 15:22 Aan: [EMAIL PROTECTED] Onderwerp: De antivirus-scanner op de firewall van Thomas Cook heeft een bericht dat

Usage error in your E-mail to mailing list 'ORACLE-L'

SET ORACLE-L NOMAIL -- Forwarded by Linda Miller-Coker/JPMCHASE on 11/25/2002 10:19 AM --- Mailing List Administrator <[EMAIL PROTECTED]> on 11/23/2002 02:18:44 PM Please respond to [EMAIL PROTECTED] To: Linda Miller-Coker/JPMCHASE@CHASE cc:

  1   2   >