Re: RTFM/ SUPPORT, etc WASRe: Index Constraint

There ain't no substitute for doing your own research, then asking for help when you need. Personally, I sometimes find SQL*Net baffling. There must be a hundred different ways to setup the listeners, names, tnsnames.ora, sqlnet.ora, tracing, MTS, yadda, yadda, yadda. I still ask questions,

RMAN NETBACKUP recovering from say 6 MONTHS ago

I want to alternate host my database to 6 months ago: The media manager only keeps 2 months of data online and when i recover until etc.. the job hangs and then finally gives up, obviously as the tape is not inside: My question is how does Netbackup know which tape to load, or how do I know which

RE: Wrong Results Bug in Oracle 8.1.7.1

Ian Not sure its related, but I had a similar problem recently on 8.1.7.0 - a query returning the wrong number of rows - but in this case it was throwing an ora-7445 after a few reruns and the table had both function-based and IMT indexes. OWS came up with 'Stack trace matches bug 1561106 which

RE: Wrong Results Bug in Oracle 8.1.7.1

Any chance its doing a INDEX DESC or INDEX MAX/MIN in the plan? They're are two culprits I've seen in the past that cause 'peculiar' result set to come back hth connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: Accounts payable. But this is not a Peoplesoft problem, but an Oracle one.

Re: Slow disk-to-disk - [W2K OT]

Seßn, Check the settings on the net card. Compaq has a bug on some versions that will reset the card to 10m and half duplex when you reboot the system. Ron ROR mª¿ªm [EMAIL PROTECTED] 06/09/02 06:13PM Sean, Goto sysinternals.com and get their monitoring tools. (free) You can log all IO

RE: Slow disk-to-disk - [W2K OT]

I agree with Ron. This has happened to me. Make sure the card is specifically set for full-duplex. Dave -Original Message- Sent: Monday, June 10, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Seßn, Check the settings on the net card. Compaq has a bug on some versions that

ColdFusion and Oracle

Group, I have an Oracle database 8.1.7.2 on Sun Solaris 5.0. We have another server running ColdFusion. The ColdFusion log has the following representative message (the Unable to instantiate ... - is the same): Fri Jun 07 11:23:33 2002,Oracle Error Code = 0PUnable to instantiate environment for

RE: Index Constraint

Hello, FYI, RTFM does not stand for 'Read the Frigging Manual'; we need to be precise in our replies to questions. Unfortunately, Hamid, I can not say in the list, what the 'F' really stands for, but you should be able to guess. Also, the use of the word 'Frigging': Mladen - I believe that only

RE: set command

Title: RE: set command Guys, Building scripts from SQL generating SQL in Oracle on Unix. I know that there are set commands so that Oracle does not put CR or LF in the middle of a long command. Does anyone know these off the top of their head? Thanks, Paula set array...? set maxdata...?

Replication question

Simple question, but I can't seem to find the answer in the oracle docs: Let's say I insert a record into an updatable snapshot, and then I update the same row. When I refresh the snapshot, will the same two DML operations be played back in order to the master, or will it only replicate a

Large enqueue waits.

Hi to you all, High enqueue locks. This morning before I got to work there were a group of users who appeared to be hanging at times when they should have been performing updates to certain tables. I tracked it down to what I suspect is high enqueue lock times. [details are below. I

RE: set command

Hi Try: set lines(ize) to something outrageous long and set trimspool on. Jack Paula_Stankus@doh.

RE: Complex Integrity Checking

Title: RE: Complex Integrity Checking Again I do not see anything here saying that the child session (Autonomous TX) will see the changes made by the parent TX. If you implied this in your message, then we are in agreement. regards, Waleed -Original Message-From: Aponte, Tony

RE: Complex Integrity Checking

Title: RE: Complex Integrity Checking Sorry for the delayed reply (I type with 2 fingers.) The section starts on page 685. rip Database Changes Now, this is were things get interesting - database changes. Here, things can get a little murky. Database changes made, but not yet

RE: set command

Title: RE: set command How about set linesize? --Walt Weaver Bozeman, Montana -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 7:58 AMTo: Multiple recipients of list ORACLE-LSubject: RE: set command Guys, Building

RE: Large enqueue waits.

Did you look to see if you had any blocking locks occurring at this time? RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration Author: Oracle9i New Features  Mastering Oracle8i    Clark Griswold: Eddie, has anyone ever told you

Re: Large enqueue waits.

Mike, Enqueues are locks on database objects. When it happens again, you can check to see what objects are being waited on. select s.username username, e.event event, s.sid, e.p1text, e.p1, e.p2text, e.p2, e.wait_time,

SHARED SERVERS

Hi I am wondering one of my database shared server process is taking much CPU.Let me know what could be reasons please?I added 2 more shared servers but still first shared server process is taking upto 25% of CPU? Any suggestion for prevention would be great. Thx -Seema

9iR1 to 9iR2 Upgrade Bug

All, I've been away for a week or so. I don't see this mentioned here, if it has been please forgive the repeat. If you migrated a database from 8i to 9iR1, and are now looking at migrating to 9iR2, you need to review note 197737.1 on Metalink for a nasty bug that might be waiting for you. If

RE: Complex Integrity Checking

Title: RE: Complex Integrity Checking I once had an instructor that said "a test is worth a thousand pages of documentation." If you have access to the book, give the sample a try. Regards, Tony Aponte -Original Message-From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]Sent:

RE: Wrong Results Bug in Oracle 8.1.7.1

Title: RE: Wrong Results Bug in Oracle 8.1.7.1 We had a similar issue, although it always resulted in an ORA-600. It was with descending indexes as defined in the Peopletools repository. We had to set _IGNORE_DESC_IN_INDEX=TRUE (and _DB_FILE_NONCONTIG_MBLOCK_READ_COUNT=1 to comply with the

RE: Install: 9i on 2000, TNS Listener service not installed

I've got 9.0.1 on my WinTuke WS SP2 box and the listener service installed correctly. Not that it helps you any, but I thought you should know that it worked for someone. GL! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech

Re: set command

Title: RE: set command Oracle doesn't place anything. SQL*Plus does. If you generate scripts from SQL*Plus: set linesize ... -- Alexandre - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monday, June 10, 2002 3:58 PM

RMAN

Hello All, I have been working on a strategy to implement a RMAN based backup and recovery strategy. Can anyone please suggest me if there is a way to force the RMAN to write the backups to a machine other than the one on which target database is present? Thanks for your help. Surendra --

how to you stop an export?

how do you stop an command-line export? press CTL-C countless times and ususally just stops the current table . . . usually end up killing the entire session. was hoping there's a different way? thx bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill

RE: RMAN NETBACKUP recovering from say 6 MONTHS ago

Title: RE: RMAN NETBACKUP recovering from say 6 MONTHS ago Netbackup has a repository that keeps track of what files are on which tapes, dates, sizes, volumes, serial number, etc. Depending on how you are restoring the files, Netbackup gets a request to get a file name (as it is know on

RE: set command

Title: RE: set command set linesize alone doesn't help - but will try it with set trimspool -Original Message-From: Alexandre Gorbatchev [mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 12:48 PMTo: Multiple recipients of list ORACLE-LSubject: Re: set command Oracle

RE: RMAN

Surendra The criteria I recall for RMAN to write to disk is whether you can create an Oracle tablespace on that device. For example, NFS-mounting a disk on another machine should work if you configure NFS correctly. Of course, you need to be aware of how large the network pipe is to the

Re: how to you stop an export?

Hi, by my experience, press CTL-C is enougth. :-) Ciao - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 10, 2002 7:08 PM how do you stop an command-line export? press CTL-C countless times and ususally just stops the current table

RE: Complex Integrity Checking

Title: RE: Complex Integrity Checking I would not be happy to have such instructor! -Original Message-From: Aponte, Tony [mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 12:08 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Complex Integrity Checking I once

RE: how to you stop an export?

Hello, On HP-UNIX (11.0), a CTL-\ will generate a core dump, that effectively kills the export. Then all you need to do is remember to remove the core dump (rm core) and the aborted export .dmp file. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax-

Re: RMAN

Hi. you must share the remote filesystem or make RMAN able to write on DLT. :-) Ciao - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 10, 2002 6:53 PM Hello All, I have been working on a strategy to implement a RMAN based backup

RE: RMAN

Dennis, Thanks for your quick reply. Thanks for your suggestions. Yes, a while ago I am also forced to conclude that properly configured NFS is the only option. But I am not sure when I would be able to do that. For the time being I have decided to use the extra space avaialble on my target

Job Scheduler in 9i

Anyone run into any problems with the job scheduler in 9iR1 not kicking off jobs when they are scheduled? We have a situation where a given job (runs every 4 hours or so) will be kicked of successfully 2-3 times, and then on the 4th time the scheduler does not kick it off, next_date is not

RE: Install: 9i on 2000, TNS Listener service not installed

Thanks In my 9i Install, the tool to create the service was Net Manager and it was under Configuration and Management Tools. At 08:33 AM 6/10/2002 -0800, you wrote: I've got 9.0.1 on my WinTuke WS SP2 box and the listener service installed correctly. Not that it helps you any, but I thought

RE: set command

Title: RE: set command Paula, TRIMSPOOL will only remove the trailing characters in an output file. Normally, the output is padded withblanksup to the length defined by LINESIZE. I don't think TRIMSPOOL will help, but I could be wrong. How long is the command you are trying to output?

RE: how to you stop an export?

CTL-\ rm core - Kirti -Original Message- Sent: Monday, June 10, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Hi, by my experience, press CTL-C is enougth. :-) Ciao - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday,

RE: how to you stop an export?

Hi, If you are running from a UNIX server, kill the job by PID number. Muqthar Ahmed DBA -Original Message- Sent: Monday, June 10, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Hi, by my experience, press CTL-C is enougth. :-) Ciao - Original Message - To: Multiple

RE: set command

set pagesize 0 as well, that stops the heading lines from breaking up your output --- [EMAIL PROTECTED] wrote: set linesize alone doesn't help - but will try it with set trimspool -Original Message- Sent: Monday, June 10, 2002 12:48 PM To: Multiple recipients of list ORACLE-L

Re: Any tool available for identifying junk code?

I like the then use coffee-machine information part. --- Stephane Faroult [EMAIL PROTECTED] a écrit : Sandeep Kurliye wrote: Hi Guys, Sorry, if this sounds bit awkward or unrelated to this mailing list. Can any one of you please let me know whether there is any tool

Nologging index tablespaces?

Have any of you changed your index tablespaces to NOLOGGING? Offhand it seems like a possible performance increase and less redo, but at the expense of having to remember to rebuild the indexes in a recovery. And I don't like to have special things to remember in a crisis. Dennis Williams 20% OCP

RE: RMAN[2]

sorry ... there is another way install RMAN on the remote machine and connect to the remote database with sql*net ;-) Ciao - Original Message - To: [EMAIL PROTECTED] Sent: Monday, June 10, 2002 6:29 PM Hi. you must share the remote filesystem or make RMAN able to write on

RE: Job Scheduler in 9i

We had the same situation and then we use cron that never fails. Now, we don't trust dbms_job ... I had a TAR open on that, but can't access it now. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com

RE: Asinine security in Oracle, Part Deux

Yes ... http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/server.920 /a96521/audit.htm#13622 Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal

RE: Wrong Results Bug in Oracle 8.1.7.1

We had this same problem last year. The answer was to upgrade to 8.1.7.2 which came with its own set of bugs which required we go to 8.1.7.3. We had run for months in production before we ran into the bug. Once we hit it, there was no way to avoid it. The only option was to upgrade. I don't

Asinine security in Oracle, Part Deux

So, there I am, following up on past MetaLink forum articles, when I noticed one about auditing DBA actions. This, of course, is not supported by Oracle. Why would anyone want to audit a DBA? After all, a DBA never makes mistakes, right? ;) The answer from Oracle was that auditing SYS would

RE: set command

You can also add set feedback off This will stop any row counts from appearing at the end of the query. Plus you can set sqlprompt '' This will change the standard SQL prompt to nothing. This way the SQL that returns at the end of the query . Its anoying . -Original Message-

Re: Nologging index tablespaces?

Dennis, We have set particular indexes to nologging when building them. These are indexes that we drop every night for our warehouse load. It is a hassle because whenever we clone this database to our QA box, those nologged indexes get corrupt and we have to rebuild them. Takes us three

Re: Wrong Results Bug in Oracle 8.1.7.1

These types of problems can sometimes be resolved with an index rebuild, btw. hth, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily

RE: Asinine security in Oracle, Part Deux

Yay! Thanks! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 2:13 PM To: Multiple

Re:RE: Job Scheduler in 9i

Raj, WARNING: Cron has been known to fail around here leaving one heck of a mess behind. The primary culprit is when you have a power failure. In our case the power failure lasted more than 8 hours. When the computer restarted the cron job's time had passed it would not start for another

RE: I/O bound on tablespace for one partition

Title: Message What OS Stripe Width would you Consider Ideal for respective Types (OLTP Batch) of Applications ? What is your nature of Application ? Any Good Docs Links on the Same ? Thanks -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Friday, June

RE: RE: Job Scheduler in 9i

Dick, Thanks, and yes I understand both, but we had really bad luck with dbms_job which would stop working without any errors. OWS was unable to give a quick fix, and eventually it turned out that one of the parameters (I think job_queue_processes) was getting reset or something like that. We

RE: set command

Title: RE: set command Here is what I use. It wraps at the 32768th character. SET PAUSE OFFSET TRIMSPOOL ONSET TRIMOUT ONSET TERMOUT OFFSET PAGESIZE 5SET LINESIZE 32767 -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Monday, June 10, 2002 2:09 PMTo:

auditing sys

according to the docs its in there. Sys Accountability: Heightened user accountability and database security are now possible with the capability to audit all operations done by user SYS(including all as SYSDBA and SUSOPER connections). This is from the 9ir2 new features guide. Haven't

RE: set command

Setting SQLPROMPT to '' is very handy, but there is one caveat. After the query executes, SQL*Plus 'appears' to hang because there is no prompt to indicate where the next command is to be entered(like SET PAUSE ON and forgetting about it...d'oh). I spooled as much as 10,000 characters on a

RE: set command

Title: RE: set command That was it Thanks Rachel. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 1:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: set command set pagesize 0 as well, that stops the heading lines

RE: Asinine security in Oracle, Part Deux

You might want to check out 9iR2. -Original Message- Sent: Monday, June 10, 2002 2:58 PM To: Multiple recipients of list ORACLE-L So, there I am, following up on past MetaLink forum articles, when I noticed one about auditing DBA actions. This, of course, is not supported by Oracle.

RE: Oracle one-off Patch Install util

I've d/ld new versions of RDA and it is much better than it used to be. I got a clean run on Solaris the 1st try! Now to beat them up over the invalid HTML that it creates. There can't be any H3 tags in a PRE block! Of course every browser but Opera overlooks this... Rich Jesse

RE: Wrong Results Bug in Oracle 8.1.7.1

I recall a similar situation with Oracle 7.3 and parallel index creations where the row source and output would get reversed. Index scans would return now rows (The developer called with 'I just created and index and now the data is all gone'). If a FTS works, but not the index, that tells me

RE: Job Scheduler in 9i

Just out of curiosity, are the jobs showing up in dba_jobs_running? I'm wondering if they ever report back as having completed. Brian -Original Message- Robert Sent: Monday, June 10, 2002 1:13 PM To: Multiple recipients of list ORACLE-L Anyone run into any problems with the job

RE: set command

trimspool will remove the trailing blanks and get rid of the padding --- Fink, Dan [EMAIL PROTECTED] wrote: Paula, TRIMSPOOL will only remove the trailing characters in an output file. Normally, the output is padded with blanks up to the length defined by LINESIZE. I don't think

RE: RMAN[2]

I have been doing this only. Still it is trying to write on target machine. Thanks, Surendra -Original Message- Sent: Monday, June 10, 2002 2:04 PM To: Multiple recipients of list ORACLE-L sorry ... there is another way install RMAN on the remote machine and connect to the

RE: Asinine security in Oracle, Part Deux

I am working on notes re. how to secure iAS on Win32 for us here. Pete Finnigan is working with SANS (and Oracle) to put an Oracle security step-by-step guide together. I asked Oracle Canada if, when they talk about Unbreakable Oracle, this includes iAS on NT. No response from the Oracle

Analyze running twice as long after upgrade to 8.1.7.2

We just upgraded our data warehouse from version 8.0.4 to version 8.1.7.2 of Oracle. We run on Sun Solaris 2.6 vith Veritas Quick I/O. We do an analyze compute nightly with a 10% estimate of our large, main fact table. Before the upgrade, the analyze ran for 45 minutes. Since the upgrade,

OEM

Hi Does somone tell me how to check price information about Oracle enterprise manager product? Is OEM available on Unix box also? How to setup email with OEM? Thx -Seema _ Send and receive Hotmail on your mobile device:

grant access to another user's objects?

All, We have a new info security group that is going to do all the object grants on our warehouse. I don't want them to login as schema owners to do this. Until this time, I have been granting access to other user's object by logging in as a dba, creating a procedure in the owner's schema with

Re: OEM

I think basic functionality of OEM comes with either EE or SE database purchase; I've never used OEM so I don't know what basic means. Additional packs for OEM can be purchased additionally, including diagnostics pack, tuning pack, change management pack, and mgmt pack for SAP R/3, and I'm

RE: OEM

it is free which comes along with ur enterprise edition -Original Message- Sent: Monday, June 10, 2002 4:44 PM To: Multiple recipients of list ORACLE-L Hi Does somone tell me how to check price information about Oracle enterprise manager product? Is OEM available on Unix box also?

Re: grant access to another user's objects?

9i R2 allows DBA's to do GRANTS on objects in other schemas. Jack Silvey wrote: All, We have a new info security group that is going to do all the object grants on our warehouse. I don't want them to login as schema owners to do this. Until this time, I have been granting access to

Re: Oracle one-off Patch Install util

Hi Rich Could you please inform me where you downloaded the RDA from ? Metalink or OTN Jesse, Rich wrote: I've d/ld new versions of RDA and it is much better than it used to be. I got a clean run on Solaris the 1st try! Now to beat them up over the invalid HTML that it creates. There

RE: Patch a Patch

Gogala , List QUESTION IN CAPITALS BELOW THANKS -Original Message- Sent: Thursday, June 06, 2002 5:23 AM To: Multiple recipients of list ORACLE-L No. First of all, you cannot uninstall patch 8.1.7.3 because oracle hasn't provided uninstall in any of the recent patch sets. You

OTN discount code.

List, someone pl.. tell me the new OTN discount code for OCP exam?? she is such a pig_headed, insists on the code...damn.. Thanks, Sunil Nookala. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: grant access to another user's objects?

Jack Silvey wrote: All, We have a new info security group that is going to do all the object grants on our warehouse. I don't want them to login as schema owners to do this. Until this time, I have been granting access to other user's object by logging in as a dba, creating a

RE: grant access to another user's objects?

If you are not up to 9i R2, you can always resort to the brute force method that we always had to use. As part of our initial DB Creates for a new project at a previous job, I used to log have to log on as the object owner and perform grants to our DBA's with the Grant option. We used to do

Off Topic, slightly - Crystal Reports internal format

List, I have an 'opportunity' to make some points with end users, if possible. I'm booting the crystal reports users off of my production databases ( including SAP, can you believe that? ). There reports will now run against a reporting server with snapshotted tables. Their reports have

Re: grant access to another user's objects?

Kevin Loney wrote about it as become_another_user.sql starting in the 7.3 DBA Handbook. the problem is, if you use and enforce password history, you can't make the changes because the saved off password won't be allowed to be reused unless you cycle through a bunch of passwords (as many as you

RE: Wrong Results Bug in Oracle 8.1.7.1

Title: RE: Wrong Results Bug in Oracle 8.1.7.1 That's it. The init.ora parameter, IGNORE_IN_INDEX had been set to TRUE, but the indexes had not been rebuilt Ian MacGregor Stanford Linear Accelerator Center ian@SLAC.Stanford.edu -Original Message-From: Aponte, Tony

Re: Off Topic, slightly - Crystal Reports internal format

Jared 1) for the dbname...why not just change the SID in TNSNAMES that the ODBC DSN is using to point to the snap-shotted(?) instance 2) I think private synonyms would be the way to go for the table naming problem. Why did they not just use the same names on the snapshot

Re: OTN discount code.

It used to be 'OTN20' a while ago but not finding anymore on Oracle sites.(old one was 'S36'). Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 10 Jun 2002 13:33:58 -0800 List, someone pl.. tell me the new OTN discount code for

Limit on length of decode arguments??

Hello all In an effort to clean up data as I'm importing, I need to pass the bad data to decode. It seems onece I pass 250 chars the code fails with SQL*Loader-350: Syntax error at line 93. Token longer than max allowable length of 258 chars The articles on metalink hint on problems

RE: grant access to another user's objects?

REALLY?!??! FINALLY! Perhaps OraCorp has been listening to my rants on this list and on MetaLink feedback? 9iR2 would seem to calm my ire on two security points: 1) DBA is god (Note the small g -- No need to mess w/The Big Guy) 2) Even gods deserve to get audited. Yay! Yay! Yay! Who at

RE: OEM

I think that you get a basic OEM with Oracle, but the add-on packs only work if you have Enterprise Edition. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, June 10, 2002 4:00 PM To: Multiple recipients of list ORACLE-L I think basic

RE: OEM

http://www.oracle.com Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Subject: OEM Hi Does somone tell me how to check price

RE: Oracle one-off Patch Install util

A simple search in MetaLink of RDA download will bring up links for RDA on OpenVMS, Linux/Unix, Windohs, and even OracleRdb. And, yes, the tool is much improved from when I first used it. :) GL! HTH! Rich Jesse System/Database Administrator [EMAIL PROTECTED]

RE: Asinine security in Oracle, Part Deux

There are a ton of things I like about NT. Especially the Win2K incarnation. Production Internet server is not one of them. I get a critical update notice about every week to 10 days. These almost always require a reboot of the server. Some of the vulnerabilities are pretty significant. As nice

RE: RMAN[2]

Surendra - That is inherent in RMAN. RMAN only writes on the target system. I do believe that one is on the exam. Dennis Williams DBA, 20% OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, June 10, 2002 3:24 PM To: Multiple recipients of

RE: grant access to another user's objects?

Jesse - Does the DBA have access to the audit tables? If so, just edit yourself back out. I was reading a book about someone that tracks down hackers on the Internet. One of his security methods is to copy the system logs over to another system every few minutes. He checks to see if the log ever

RE: Nologging index tablespaces?

Cherie Thanks for the input. This would be an OLTP database, with continual inserts/updates/deletes. I guess that CREATE INDEX NOLOGGING would save something in the redo logs. I'm not convinced that having a tablespace containing only indexes set to NOLOGGING would save redo. Since redo

Re: Off Topic, slightly - Crystal Reports internal format

1) for the dbname...why not just change the SID in TNSNAMES that the ODBC DSN is using to point to the snap-shotted(?) instance I'm eliminating tnsnames.ora files on the desktop, so that is out. 2) I think private synonyms would be the way to go for the table naming problem. Why did

Re: grant access to another user's objects?

Pulled this off the other list a long time ago. It was posted by Raj Mithal. --- Try this:- Becoming a User with Password Expiry enabled In Oracle 7.x you could become a user by storing the encrypted password,

RE: grant access to another user's objects?

I'm after the audits as a point of tracking my DDL/DCL as SYSDBA more than for intrusion detection. As you've eluded to, the truly paranoid would add more layers of protection and monitoring via triggers, audit opts, DBMS_JOB/cron jobs, etc. to provide increased accountability and tracking.

RE: grant access to another user's objects?

Jesse - On another list today someone mentioned that auditors were upset that the DBA had access to the application tables (like payroll tables, for example). I was just curious whether this new feature would eliminate the autitors' concern. I trust you, but man, those auditors are tough. Dennis

RE: OTN discount code.

It is still 'OTN20'. Regards Jahan -Original Message- Sent: Tuesday, 11 June 2002 10:03 To: Multiple recipients of list ORACLE-L It used to be 'OTN20' a while ago but not finding anymore on Oracle sites.(old one was 'S36'). Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple

Re: Off Topic, slightly - Crystal Reports internal format

On Mon, 10 Jun 2002 [EMAIL PROTECTED] wrote: 1) for the dbname...why not just change the SID in TNSNAMES that the ODBC DSN is using to point to the snap-shotted(?) instance I'm eliminating tnsnames.ora files on the desktop, so that is out. Sorry...I haven't used onames or OID yet;

RE: grant access to another user's objects?

What part of *DATABASE* Administrator don't they understand? Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/10/2002 04:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE:

Re: Off Topic, slightly - Crystal Reports internal format

Jeff, I can't use the production database name to point to the reporting database. That might mess up the apps that are actually supposed to connect to the production database. :) The name resolution all takes place in the Oracle Names server. As far as recreating the schema to match

RE: Analyze running twice as long after upgrade to 8.1.7.2

Cherie, Any other ideas? I'd like to be able to give our application owners some explanation. If you have access to the ANALYZE scripts, could you modify it to obtain _what_ this session is waiting for and how much (from V$SESSION_EVENT) as well as look at V$MYSTAT to determine the volume

Re: OTN discount code.

Jahan, thanks, i was just getting ready to register for 9i new features exam and the code came in to save me 20% :) joe Jahan Shanai wrote: It is still 'OTN20'. Regards Jahan -Original Message- Sent: Tuesday, 11 June 2002 10:03 To: Multiple recipients of list ORACLE-L It used

Re[2]: how to you stop an export?

You can try to press CTRL-D Hello, Tuesday, June 11, 2002, 1:03:29 AM, you wrote: MA Hi, MA If you are running from a UNIX server, kill the job by PID number. MA Muqthar Ahmed MA DBA MA -Original Message- MA Sent: Monday, June 10, 2002 1:33 PM MA To: Multiple recipients of list

  1   2   >