primary key, local partition index - prefixed/non-prefixed

Hi all... I'm messing around with partitioning, and trying to create a primary key index which is locally partition to match the underlying table. Table looks something like this: create table mytable ( id number, last date) tablespace data storage (initial 64k next 64k pctincrease 0)

RE: Setting profile limits?

Title: Setting profile limits? Thanks for the help, or should I say the lack of help :) I took the disdainful silence from all of you, to mean that I had not done enough RTFM. Anyway a little experimentation on the test system and Rachel's 101book managed to clear that problem. Thanks

OT: Urgent PDF to TXT Convert

Hi IT friends, Do you know any 3rd party software (other than Adobe Acrobat) that convert few hundred pages of PDF to TXT. Sorry for the OT but please guys, is quite urgent thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL

Some of you may find this useful

break on proc column QUERY format A40 word_wrapped select substr(KGLNAOWN || '.' || KGLNACNM, 1, 35) proc, KGLNADNM QUERY from x$kglrd where KGLNAOWN != 'SYS' order by 1, kgldepno / If it doesn't stimulate your creativity I can do nothing for you :-). Regards, Stephane Faroult Oriole -- Please

RE: primary key, local partition index - prefixed/non-prefixed

Hi all... I'm messing around with partitioning, and trying to create a primary key index which is locally partition to match the underlying table. Table looks something like this: create table mytable ( id number, last date) tablespace data storage (initial 64k next 64k pctincrease 0)

RE: Urgent PDF to TXT Convert

It might be irrelevant but Ghostgum can read pdf and convert to prn and maybe to txt and it is free. -Original Message- Sent: Friday, January 10, 2003 11:59 To: Multiple recipients of list ORACLE-L Hi IT friends, Do you know any 3rd party software (other than Adobe Acrobat) that

RE: Urgent PDF to TXT Convert

Have a look at www.planetpdf.com in pdf tools section HTH! Aleem -Original Message- Sent: Friday, January 10, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Subject:OT: Urgent PDF to TXT Convert Hi IT friends, Do you know any 3rd party software (other than Adobe

RE: Urgent PDF to TXT Convert

LD-Getter (http://www.pdftoall.com/index.htm) HTH Mark -Original Message- Hatzistavrou Giannis Sent: 10 January 2003 10:34 To: Multiple recipients of list ORACLE-L It might be irrelevant but Ghostgum can read pdf and convert to prn and maybe to txt and it is free. -Original

RMAN with OmniBack on NT

Hi all, do you have good papers or good links where I can read "detailed" information concerning how to setup rman with omniback on nt. I am also very delighted to hear your comments concerning this set-up Rgds and thanks, JoshuaGratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt!

RE: Urgent PDF to TXT Convert

If it's a one-off job, then would a simple cut--paste do the trick? Good luck, Charu -Original Message- Xing Sent: Friday, January 10, 2003 10:42 AM To: Multiple recipients of list ORACLE-L Hi IT friends, Do you know any 3rd party software (other than Adobe Acrobat) that convert few

Simulate Database Writes

Instead of making Actual Database Writes is it possible to Simulate Such Writes by using a suitable program in order to Check the thruput of a newly configured RAID Storage Box ? Nature of Application - Hybrid If so What should be the Size of the Writes ? Our DB_BLOCK_SIZE is 8K Is there a

Re: RE : RMAN Repository

way back when, I wrote my own set of scripts to handle backups. As each datafile was backed up, I wrote the full path name to a text file. At the end of the backup the text file was written to tape as well. As I did restores, I read the text file. then I used that file to let me know which file I

Re: Urgent PDF to TXT Convert

Hi Do you know any 3rd party software (other than Adobe Acrobat) that convert few hundred pages of PDF to TXT. Sorry for the OT but please guys, is quite urgent thanks There are loads of them - including some freeware ones (IIRC). Just do a Google search on pdf2txt and you'll find a selection

truncate system tables.

Hi, just to lighten you up - it's old but good (found on the web) --- Yesterday, All those backups seemed a waste of pay. Now my database has gone away. Oh I believe in yesterday. Suddenly, There's not half the files there used to be, And there's a milestone hanging over me The system crashed

RE: RE : RMAN Repository

But I don't anticipate having to recover from a prior incarnation when I have a perfectly good backup from the last successful backup. I get requests from developers to refresh test databases from production backups that are 30 days old. This is for billing system software, where they need to

Re: Which session is killing performance?

Once you know the thread id (ex. 2496) you can do the following SELECT s.osuser,s.program,s.terminal /* whatever you want to see */ FROM v$session s, v$process p WHERE p.spid = '2496' AND p.addr = s.paddr; Rick

Re: primary key, local partition index - prefixed/non-prefixed

Sean, In your case the PK would need to be on (Last, ID) in order for the index to be Local. Otherwise, it's gotta be Global or else you need to change your partition key. Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929

Re: Some of you may find this useful

ooh lovely! I'm gonna have SUCH fun today, playing with this and the results of a 10046 trace :) --- Stephane Faroult [EMAIL PROTECTED] wrote: break on proc column QUERY format A40 word_wrapped select substr(KGLNAOWN || '.' || KGLNACNM, 1, 35) proc, KGLNADNM QUERY from x$kglrd where

Re: Determine max # of concurrent users at schema level

This is at the instance level. As suspected the only way is through auditing. Thanks Rick Charlie_Mengler@Hom

Re: Simulate Database Writes

There's an outline and sample C program that I wrote about 5 years ago on my web site under http://www.jlcomp.demon.co.uk/block.html Bear in mind that the write has to be at the equivalent of an oracle block boundary, and you need to open the file and write to the file using the same calls

RE: Urgent PDF to TXT Convert

Hi all, Thanks for your reply. I find a command pdftotext from Red Hat Use a script run it very fast all my pdf files are now in text files. Enjoy your weekend :) Thank You Sinardy -Original Message- Sent: 10 January 2003 17:59 To: Multiple recipients of list ORACLE-L Hi IT

partitioning star schema

Hello, We are still struggling with partitioning of star schema fact tables. As of yet, we haven't been able to test/compare any of the following scenarios (because we're not yet legal with the partitioning option), so I am posting in the hope that someone with more partitioning experience will

Re: Tru64 Direct I/O

I have been running 8.1.7.2 on Tru64 5.1 on a SAN. However, the Database Server and the Application Server [Apps R11] are the only servers on the SAN {and that's why I say SAN in quotes !} I had set _tru64_directio_disabled=TRUE in my database in June 2002 [after having upgraded from 8.0.5 in

RE: Tru64 Direct I/O

Thanks, Stephen I'll pass this along to our SA's. We will be migrating to the Compaq SAN; upgrading our controllers to fiber (HSG80's ?) but we have 2 older 8400's as production primary failover, and yes, they both have access to the same disk farm, though not concurrently (currently).

RE: partitioning star schema

Typical canned answer is try to partition by a numeric. We partition by a date when we can. I'm torn between the order of one and two, but that is more personal preference. I generally try to partition by the fields that make joins run best and the ones that make maintainence better if I

RE: RMAN with OmniBack on NT

Joshua - I think several people on the list use Omniback, but I can't be sure if there are significant differences on NT. Since I don't see where anyone has replied to your question, I'll mention that Robert Freeman's book Oracle9i RMAN Backup Recovery has a chapter on configuring HP OmniBack II

RE: ORA-29702: error occurred in Cluster Group Service operation

Title: RE: ORA-29702: error occurred in Cluster Group Service operation I wonder if it has something to do with the Clustered file system based on a couple of error messages... In the messages-I see reference to the iofence-timer. Just a thought greg -Original Message- From:

RE: Some of you may find this useful

That's pretty cool :) Thanks for sharing it, Stephane. - Kirti -Original Message- Sent: Friday, January 10, 2003 4:04 AM To: Multiple recipients of list ORACLE-L break on proc column QUERY format A40 word_wrapped select substr(KGLNAOWN || '.' || KGLNACNM, 1, 35) proc, KGLNADNM QUERY

RE: Which session is killing performance?

Thanks for everyone's suggestions. Hopefully I'll get some time next week to look at the figures. Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of

BCHR Tuning

Here's an excellent real life example of why BCHR is not a good tuning metric and you should focus on reducing I/Os. A simple fix for a query and here is the resulting email to the client, who understands that BCHR is not good. A little techie humor... I have good news and I have bad

Re: Some of you may find this useful

Stephane, My creativity has been stumulated, simulated, and mutated. What version of Oracle are you using? x$kglrd ...table or view does no exist on 8.1.7 rel 3 Ron [EMAIL PROTECTED] 01/10/03 05:03AM break on proc column QUERY format A40 word_wrapped select substr(KGLNAOWN || '.' || KGLNACNM,

Re: Determine max # of concurrent users at schema level

And your point is? users_max field in v$license is polulated *if* you have set the init.ora parameter LICENSE_MAX_USERS, then this field value is set. This means you can create upto a certain number of users. It does not mean that that many number of named users have connected so far.

Re: BCHR Tuning

Of course it dropped dramatically. That's because you are no longer doing 99% of the buffer gets that you were wasting to begin with. If it drops my resource use and increases my performanc, I'd love to have a BCHR of 1%. (I know that's extreme, but wouldn't it be cool..?) F Here's an

RE: Some of you may find this useful

Ron, did you run it from the SYS account? worked for me using 8.1.7.2 Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 10, 2003 10:50 AM To: Multiple recipients of list ORACLE-L Stephane, My creativity has been stumulated, simulated, and

Re: RE : RMAN Repository

Thanks for the support, Rachel. I was wondering if I was the only one in this want-simple-and-robust-RMAN camp. What you described for cold backups, I used to do for hot backups as well in the pre-RMAN days and do it even now. In fact in a site we use BrightStor backup software from CA, I create a

Re: BCHR Tuning

Dan, I apologize for not detecting the humor at first and giving a serious reply. Either I had some sort of weird window setting emphasizing the goofball portion of the message, or I need to tune my humor detector. (This is not a good sign on a Friday) -rje F Here's an excellent real

RE: Some of you may find this useful

Log on as SYS and run it. I have it on my 8.1.7 DB. Dave -Original Message- Sent: Friday, January 10, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Stephane, My creativity has been stumulated, simulated, and mutated. What version of Oracle are you using? x$kglrd ...table

Re: BCHR Tuning

Classic! --- Fink, Dan [EMAIL PROTECTED] wrote: Here's an excellent real life example of why BCHR is not a good tuning metric and you should focus on reducing I/Os. A simple fix for a query and here is the resulting email to the client, who understands that BCHR is not good. A little

RE: RE : RMAN Repository

Oh yes, yes, yes. You are correct. It *may* work, but it's not guaranteed to work because an RMAN (and OID) transaction can constitute multiple DB transactions in their respective repositories. When I saw that feature of OID, I did some investigating and felt that we would not be at significant

RE: BCHR Tuning

And it is! Quest's Spotlight on Oracle (the new v3.0 has some great graphing) has alerted me nine times this week that the BCHR on my production ERP/MRP system was 0.00%. OF COURSE, I immediately bumped off the 200+ sessions, boosted the buffer cache by 25% and bounced the instance each time I

RE: Some of you may find this useful

Title: RE: Some of you may find this useful what is it that i am looking at after running this query?? pardon the ignorance. chris -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 9:20 AM To: Multiple recipients of list ORACLE-L

RE: fnd_global user_id

This package is auth current user. You will need to either run this as APPS or place an auth definer package around it. Off to get my first pot of coffee... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan

Re: Rman catalog error

alter user RMAN_USERNAME_HERE quota unlimited on rman; Jared BigP [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/09/2003 03:09 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Rman catalog error

Re: RE : RMAN Repository

SQL from text files is possible via external tables in 9i, or via Perl and DBD::CSV ( if comma delimited ) possible, but not my favorite way to access data. :) Jared Arup Nanda [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/09/2003 07:24 PM Please respond to ORACLE-L To:

RE: partitioning star schema

Bill - Since nobody has replied yet, I'll toss in a couple of ideas. What is your motivation for partitioning? Performance? That is what I get from your posting. I think you have good ideas. I'll provide one more that got us a good performance boost. Some queries were often comparing this

Re: primary key, local partition index - prefixed/non-prefixed

Sean, You are defining the index to be local. That means you want the partitioning of the index the same way as the table partitioning. Your partitioning key is (last) on the table, naturally the local index has to be partitioned on the same key, too. When you define a primary key constraint, the

RE: Re: Some of you may find this useful

Stephane, My creativity has been stumulated, simulated, and mutated. What version of Oracle are you using? x$kglrd ...table or view does no exist on 8.1.7 rel 3 Ron Ron, Was on 8.1.7.3 ... sorry to ask for the obvious, but have you connected as SYS or INTERNAL ? Regards, Stephane Faroult

Re: ORA-29702: error occurred in Cluster Group Service operation

Sean, Have you installed the hang-check-timer RPM? If you have installed hangcheck are you loading the hangcheck module? insmod hangcheck-timer hangcheck_tick=TICK hangcheck_margin=MARGIN Scott --- From [EMAIL PROTECTED] wrote: Hello all... I'm running 9iRAC 9.2.0.2 on Linux 2.4.20

RE: Some of you may find this useful

Stephane and other Gurus, Apologies if you think I am a spoilsport.. I executed 3/4 PL/SQL blocks and ran the query after each one. Every time I got the following output. I think 'REPOS' is the OEM repository owner. Two questions: 1. Is this what Stephane wanted us to see? 2. If yes, what does

RE: Some of you may find this useful

Ron, that's a bit of a puzzle because it should have been available since 7.3.2. Which user are you using to query it? Also, anyone, I know what x$kglrd does but anyone have any idea what the RD in the table name means? Read? Row? Data? Dependency? I'm open to suggestions. Regards, Mike Hately

Re: partitioning star schema

Bill, I'm impressed! Most of us follow something similar to the rankings you mentioned - but a very few actually spell it out and put it for the data architects. Now that you have done most of the work, I have a few comments. First, you don't have to worry about legal issues for testing these

RE: Simulate Database Writes

Great article! I'll be nabbing the code to test/compare our new storage systems (whenever it gets approved). :) I few items though: This is the first that I've seen a recommendation for raw on the redo volumes. Are there any issues with having the redos on raw if the archives are cooked? Any

RE: Some of you may find this useful

Thanks for sharing this. Richard -Original Message- Sent: Friday, January 10, 2003 5:04 AM To: Multiple recipients of list ORACLE-L break on proc column QUERY format A40 word_wrapped select substr(KGLNAOWN || '.' || KGLNACNM, 1, 35) proc, KGLNADNM QUERY from x$kglrd where KGLNAOWN !=

RE: RE : RMAN Repository

I actually think RMAN is pretty simple. First, most of the MML vendors offer a product that allows you to monitor the tape read/write process if you are using MML... So that allows you to do the monitoring thing. The problem with shell scripts are numerous. First of all, the person who wrote it

RE: Some of you may find this useful

Read Only Dependencies in the KGL. Best Regards, K Gopalakrishnan -Original Message- Mike (NESL-IT) Sent: Friday, January 10, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Ron, that's a bit of a puzzle because it should have been available since 7.3.2. Which user are you

RE: Some of you may find this useful

Not bad at all . but now I get to ask if there is a way to improve it ... When running the query below, the following was returned : INSERT INTO TEMP_TABLE ( FIELD_1, FIELD_2, FIELD3 ) VALUES ( :b1,:b2,:b3 ) What I would like to know is is there any way thru Oracle to obtain the values

RE: BCHR Tuning

Title: RE: BCHR Tuning Rich, That is the first alarm that I turn off as soon as I establish a new DB connection ... even the operators in our Computer room know to ignore that alarm. 8:) Raj __ Rajendra Jamadagni MIS, ESPN Inc.

RE: Some of you may find this useful

It looks like all of the SQL executed from the named packages. I found two references to the voodoo that is x$kglrd, both from the venerable Steve Adams' ixora.com.au: http://www.ixora.com.au/q+a/0110/31164749.htm http://www.ixora.com.au/scripts/library.htm#package_sql_executions S- On

Re: RE : RMAN Repository

Robert, No one denies that RMAN is a cool product. so was Enterprise Backup Utility when it came out. The difference in opinion is about how RMAN is built and what it takes to maintain it. If it was built upon a simple text file system, rather than Oracle database, it would have been much much

RMAN new version myths

Okay, from a friend within Oracle University (someone whose knowledge I trust).. 1. There are NO plans to eliminate the use of the RMAN Repository! As has been correctly surmised by some readers Oracle is attempting to make it easier to use rman without a repository but it is not going away.

RE: BCHR Tuning

Title: RE: BCHR Tuning Or modify the set up of these tools to take action when BCHR falls.. and that is to execute Connor's script ;) No more blinking red icons... or beepilepsy attacks...;) - Kirti -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL

sql run by users

Dear List, how to know what sql is being run by a user session. The problem is all users use the same application login. TIA sarath __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the

RE: RE : RMAN Repository

I'm not saying RMAN should not be used... I wondered why a database was needed to store the information. It's obviously NOT needed or you couldn't use the controlfiles for the RMAN information. and for what it's worth, no matter how fancy I CAN write a script, I try to write it as plain vanilla

RE: RMAN new version myths

Title: RE: RMAN new version myths Rachel, do you think we need following lists created ... * oracle-l-overheard * oracle-l-debunking-myths * oracle-l-help-idiot Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN

Big Brother is Here

OK, this is a little off topic, but if MicroSlop gets this to work, how long before OEM will have a link into the same technology?? I always thought that the computers were here to server us, not the other way around. Just what I need, an OEM job blowing and my having to fix it from the head!!

Re: sql run by users

Sarath, I use the following sql to find out who is logged in on what terminal and their sql if present. __ set linesize 90 set pagesize 60 COLUMN SU FORMAT A8 HEADING 'ORACLE|USER ID' JUSTIFY LEFT COLUMN OSU FORMAT A8 HEADING 'SYSTEM|USER ID' JUSTIFY LEFT COLUMN STAT FORMAT A8 HEADING

RE: RE : RMAN Repository

I just don't find RMAN to be that complex from a maintenance point of view. The only complaint I have about the repository is the somewhat cryptic names for the tables they use :-) As to the pitfalls of incomplete recovery, I really don't worry about it much and here is why. First of all, I

RE: sql run by users

Here is a script from Lisa Koivu -- WHOS_Running_What -- This will list the current users and the current SQL statements -- From Lisa Koivu - 1/9/03 -- set linesize 200 column username format a15 column idle format a10 column machine format a22 column terminal format a15 column program

RE: Big Brother is Here

Hmmm... Microsoft has already put together a network of more than 100 FM radio stations in the U.S. to broadcast precise time information... http://support.microsoft.com/default.aspx?scid=kb;en-us;131109 -Original Message- Sent: Friday, January 10, 2003 1:46 PM To: Multiple recipients

RE: RE : RMAN Repository

Why is everyone trying to link the Rman repository and it's recovery scenarious with recoverying production databases? The Rman repository is just another Oracle database. It needs it's own backup and recovery plan. Worrying about incomplete recovery of this database in relation to recoverying

Conversion from CLOB to RAW

Here's where I get to ask the most likely simple question. I've inherited a database where it was built using a CLOB to hold XML data but we have now determined that was total overkill and want to move it to a RAW column or other suitable datatype. Looking for conversion issues or other

RE: RE : RMAN Repository

Simple export of the rman user usually does the trick. But then what about the backup of the repository backup.. and so on :) bs -Original Message- Sent: Friday, January 10, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Why is everyone trying to link the Rman repository and

RE: RMAN new version myths

couldn't hurt on the last two at least :) --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: Rachel, do you think we need following lists created ... * oracle-l-overheard * oracle-l-debunking-myths * oracle-l-help-idiot Raj __

RE: Big Brother is Here

So we can now listen to those viruses? ;) - Kirti -Original Message- Sent: Friday, January 10, 2003 12:46 PM To: Multiple recipients of list ORACLE-L OK, this is a little off topic, but if MicroSlop gets this to work, how long before OEM will have a link into the same technology?? I

RE: Big Brother is Here

Title: RE: Big Brother is Here Aha ... a new virus that plays that same 'Nora Jones' songs again and again and again but wait ... that is 96.5 TIC in Hartford, CT and it ain't a virus yet.. Imagine what will happen when FM transmitter gets a BSOD ?? Where is my McAfee Antenna protection

Protecting schema changes

Title: Protecting schema changes In a n-tier system that connects to the database with JDBC, how does a DBA keep developers from modifying the application schema without the DBA's consent or knowledge in a centralized development environment? The developers can have their own personal

#of blocks in extent

How many blocks are allocated to an extend . what parameter decides that . Is it some storage param ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BigP INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego,

Re: Conversion from CLOB to RAW

At 11:30 AM 1/10/2003 -0800, Burke, William F (Bill) wrote: Here's where I get to ask the most likely simple question. I've inherited a database where it was built using a CLOB to hold XML data but we have now determined that was total overkill and want to move it to a RAW column or other

RE: Protecting schema changes

Following is one approach that I had implemented... (oracle 8i and up). The credit goes to Joe Testa for posting it 3 years ago :) - Kirti On Thu, 6 Jan 2000, Joseph Testa wrote: Why would you want to do that, well, i'm at a place where the developers have the schema owner password

RE: Protecting schema changes

Title: Message Revoke the create table privileges. -Original Message-From: Webber Valerie H [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: Protecting schema changes In a n-tier system that connects

Thought for Friday .. LINUX Spare capacity ... what to do ..

Title: Thought for Friday .. LINUX Spare capacity ... what to do .. http://slashdot.org/articles/03/01/10/1343224.shtml?tid=133 Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is

Re: #of blocks in extent

INITIAL, NEXT, PCTINCREASE -- if it's not LMT Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 10, 2003 2:54 PM How many blocks are allocated to an extend . what parameter decides that . Is

RE: Protecting schema changes

Val, One option is to provide access via an account that is not the owner of these objects but has all required DML privs but not DDL privs. If you cannot do this, you could always code in a Database level trigger for DDL and rap the Developer's knuckles when they do something out of turn. We

RE: Protecting schema changes

Valerie - Here is what I've been doing. Say the application uses SCHEMA_A. Create schema SCHEMA_B and create all objects in that schema. Grant select, insert, delete, update access for all objects to SCHEMA_A. In SCHEMA_A, create synonyms to point to the objects in SCHEMA_B. Only give the

RE: Protecting schema changes

Title: Protecting schema changes Val, 1). Create a role. Grant select, insert, update and delete of all the tables, views, sequences, procedures, packages and functions used by the application to this role. 2). create public synonyms for the objects in the application synonym. 3). create

RE: Protecting schema changes

Title: Protecting schema changes Super! Is it okay to grant 'select any table' or should it be object specific? I'd think object specific would be more secure. Thanks for your help and have a nice weekend too! Val -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL

Re: Oracle 8 DBA with SAP Tax Tools experience needed- New York

As a bloody foreigner I know the English word cannot which means can not. But connot as mentioned in the job description makes me wonder whether the candidate has (also) to have excellent writing skills or whether he has to have a clean criminal record. I think I'll go outside and roll a bit

Re: STRANGE

It is indeed easy to look up these things yourself. It's much, much harder to find out about women yourself. For my part - I turn 42 this year, of course, and have therefor found the answer - I learned a lot from reading the book "Why men don't answer and women can't read maps" or whatever

Re: sql run by users

I would add one more column client_info v$session into this script. Ron Rogers wrote: Sarath, I use the following sql to find out who is logged in on what terminal and their sql if present. __ set linesize 90 set pagesize 60 COLUMN SU FORMAT A8 HEADING 'ORACLE|USER ID' JUSTIFY LEFT

Re:RE: Big Brother is Here

Not to be cruel to those with AIDS, but does this mean it gets a new definition: Airborne Internet Directory Service?? Dick Goulet Reply Separator Author: Deshpande; Kirti [EMAIL PROTECTED] Date: 1/10/2003 11:25 AM So we can now listen to those

RE: Protecting schema changes

Title: Protecting schema changes Seperate the object owner from the account which they use to connect. So they would connect through an account that doesn't actually own any objects but just have enough privilege to access them. -Original Message-From: Webber Valerie H

dw report tool question

Hi Dear List, We have a new datawarehouse project. I didn't involve in this project at beginning. Right now, I was assigned to the group for picking a front end reporting tool. So far I know the manager prefer brio, cognos and business intelligent product. Does anyone familiar with those tools?

Re: Protecting schema changes

We faced a similar problem. We use change control to help manage this. The developers have the schema password in development , but not in UAT (Certification) or Production. We create a run-time userid for their application to use rather than logging in as the schema owner. The run-time userid

Re: Statspack performance problem

Juan Loaize and the guys in ST (Server Technologies) in Oracle Development added some index structures to certain x$-things (and thereby v$-things) in 7.3 and onwards, I think. However, v$sqlarea still has to do a group by, which sucks. v$sql is faster, but has more data, of course. I've

dbms_job interval 10till

Sun / Solaris 2.6 ; Oracle RDBMS v8.0.5.2.1 List: I want to change the perfstat statspack.snap procedure FROM running every hour on-the-hour TO running at 10 minutes till the hour. (On-the-hour is conflicting with another procedure.) I tried to Read The Frustrating Manual, but I can

Re: RE : RMAN Repository

Why is everyone trying to link the Rman repository and it's recovery scenarious with recoverying production databases? How is that? We are talking about the recovery of the rman catalog database only. The question is if the catalog database were to crash and it had hot backup; and the recovery

Re: Big Brother is Here

No, instead of the blue screen of death it will sing the blues...:) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 10, 2003 2:25 PM So we can now listen to those viruses? ;) - Kirti -Original Message- Sent: Friday,

Re: Conversion from CLOB to RAW

Bill, I agree with Michael. You've already got the data in a suitable datatype. Why move it to a cumbersome, soon-to-be-obsolete datatype? You can use DBMS_LOB functionality on LOBs, not on Raw. I'd be so happy if the couple dozen tables in our 3rd party Student Information system that have

Re: dbms_job interval 10till

Barbara Baker wrote: Sun / Solaris 2.6 ; Oracle RDBMS v8.0.5.2.1 List: I want to change the perfstat statspack.snap procedure FROM running every hour on-the-hour TO running at 10 minutes till the hour. (On-the-hour is conflicting with another procedure.) I tried to Read The

Re: BCHR Tuning

Obviously, we don't know what we're talking about. I can see there's a presentation by Rich Niemich at IOUG-A where he'll address all those idiots who are saying you should ignore the Cash Hit Ratio (and who are all just after making big money on their products - I loved that one). Well, to be

  1   2   >