RE: help

HELP !! -Original Message- Sent: 17 December 2001 22:50 To: Multiple recipients of list ORACLE-L You're kidding, right? --- Boag, Merridy [SMTP:[EMAIL PROTECTED]] [EMAIL PROTECTED] wrote: Does this mean that I am no longer on the mailing list? Thanks you for your help Mer

RE: RECOMPILE INVALID OBJECTS

You can use the $OH/rdbms/admin/utlrp.sql even in 7.X. However in this last case you must edit and change where you find type# for type without #. App has a similar procedure. Regards. --- Glenn Travis [EMAIL PROTECTED] wrote: If you've got a big schema (READ: Apps), this will cripple you.

RE: Redo logs lost, old backups

Yes. There are ways to recover the database (of course , unsupported) . let me know the following details by offline, I will be able to help you. What is the current state of the database? What is the size of the redo logs? Was the last shutdown (if the database is down) is immediate or abort?

RE: Calling Host

This is something that has appeared on this list a few times. If you check the archives, I posted an explanation on how to do this using a couple of shell scripts and a stored procedure. Regards, Kev. -Original Message- Sent: 17 December 2001 20:35 To: Multiple recipients of list

RE: RECOMPILE INVALID OBJECTS

I ran the script below : - select decode( OBJECT_TYPE, 'PACKAGE BODY', 'alter package ' || OWNER||'.'||OBJECT_NAME || ' compile body;', 'alter ' || OBJECT_TYPE || ' ' || OWNER||'.'||OBJECT_NAME || ' compile;'

Re: Redo logs lost, old backups

how much money do you want to spend? If you are willing to spend a lot (like $5K for every 8 hours with a minimum of 16 hours -- price might have gone up, it was that about 3 years ago) call Tech Support, ask to speak to someone in Field Support about Data Unloader. This is what it does

RE: Oracle Expert and FK indexes

I didn't do what the Oracle Expert told me to do... no time to experiment. I will ask Oracle Support what is going on, thanks for reminding me. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Shreter, Hilary [SMTP:[EMAIL

return single record

Hi Gurus! i want to return a SQL which will call a function which returns one and only record. like select function(arguments list) from dual; (or something similar to that); I am not supoosed to use ref cursor or object (collection type) or pl-sql table . This funtion will certainly

RE: unused blocks BELOW HWM - Thanks

Hi. This is just to thank all who replied to my post. Based on what I read, I have got two different ways of calculating that number and they seem to produce the same result. thank you all (you know who you are) = __ Do You Yahoo!?

RE: return single record

Hmmm... let me have it clearly ... 1. You want to execute a function using SELECT 2. This function will return only one record. 3. This function will return a *user-defined-record* Well, Oracle doesn't have a problem with 1 maybe 2 but it certainly does have a problem with 3. SELECT can't

RE: Change PCTINCREAE for SYSTEM Tablespace

Kimberly, I would agree with you if an experienced DBA makes the decision to change the storage parameters, and they absolutely know what the benfits would be. Generally speaking though, I think changing anything in the SYSTEM tablespace is bad practice. Tom Mercadante Oracle Certified

RE: Change PCTINCREAE for SYSTEM Tablespace

I agree, I am leaving the SYSTEM tablespace alone. Hands off. Ken -Original Message- Sent: Tuesday, December 18, 2001 7:30 AM To: Multiple recipients of list ORACLE-L Subject:RE: Change PCTINCREAE for SYSTEM Tablespace Kimberly, I would agree with you if an experienced

Re:RE: Change PCTINCREAE for SYSTEM Tablespace

Tom, I agree and disagree with you, respectfully. Oracle does allow some changes to be made to sql.bsq and they always leave the option open to make changes after database creation and I don't see this request as all that odd. But for the most part if you do as recommended and leave the

synonym for a user-defined data type?

We're working with Oracle v8.1.6.2. How can we declare a synonym for a user-defined data type? We would like to create a public synonym for a user-defined data type so that when this data-type is created under one schema it is accessible to all

RE: PL/SQL Cursor

Raj: Here is the code when I run it. Any idea what the problem is? Thanks, Ken DECLARE cursor ok_sos_hist_reg_nbr_cur is select tsh.tm_hist_reg_number, tdh.tm_hist_reg_number, trh.tm_hist_reg_number, d.tm_hist_reg_number from

RE: PL/SQL Cursor

Bind variables. In Feuerstein's book in some of the code he shows the use of the bind variable and in some he doesn't. What is the rule on when to use a bind variable? The book doesn't discuss this. Thanks, Ken -Original Message- Sent: Monday, December 17, 2001 3:41 PM To:

RE: PL/SQL Cursor

Isn't there a semicolon missing at the end of this line? and trh.tm_hist_reg_number = d.tm_hist_reg_number Due to missing semicolon oracle things the statement (of cursor definition) is not yet complete and that's why you get the error. ??? Raj

Encryption - Question about the key

Hi all, I am investigating using dbms_obfuscation_toolkit in my application. Now, I need a key to encrypt and decrypt the key. The question is how to protect the key? The data will be accessed from Forms application, reports, SQR reports, SQLPLUS scripts. I need to find a mechanism to * hide

RE: Change PCTINCREAE for SYSTEM Tablespace

I think even Oracle would disagree with you on that one. While it is unsupported to change anything in the sql.bsq script (except with Trusted Oracle where its required to actually get it to create a database) anything that is changeable after the fact is fair game. As a matter of fact, for all

RE: tns-12545

Some questions for you: What are you using to try to connect to Oracle? Are you trying to use SQL*PLUS or and application that uses ODBC? Is the user who can successfully connect on the same domain as you or different domain? Does you connection go through an oracle names server? Can you post an

RE: help

Yeah, but you can be aged out. -Original Message- Sent: Monday, December 17, 2001 9:15 PM To: Multiple recipients of list ORACLE-L There is no escape. In the buffer pool, no one can hear you scream... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

Re: Change PCTINCREAE for SYSTEM Tablespace

The Oracle8i Admin Guide, Chapter 19, General Management of Schema Objects: Give guidelines for setting storage parameters for data dictionary tables. Setting PCINCREASE to 50 is an artifact from Oracle 6 and early releases of 7 which had a rather limited number of extents. Jared On Tuesday

Re: help

Are you an idiot? Jared ;) On Monday 17 December 2001 23:45, Robertson Lee - lerobe wrote: HELP !! -Original Message- Sent: 17 December 2001 22:50 To: Multiple recipients of list ORACLE-L You're kidding, right? --- Boag, Merridy [SMTP:[EMAIL PROTECTED]] [EMAIL PROTECTED]

RE: unused blocks BELOW HWM - Thanks

Gene - Now that you've gotten your answer, would you mind to post both of the methods that you found to work so that the rest of us could learn? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 18, 2001 7:05 AM To: Multiple

Re: return single record

Hi Raj ! Actually I had similar problems some days back where i was supposed to treturn recordset(more than one) . At that time i created object and collection of object and then using cast operator and the operator i was able to return recodset from function . I could have used that function

Re: Fw: tns-12545

Also see Metalink note 91554.1: Problem Description: = Trying a SQL*Plus connection from a Windows NT/95/98 client workstation to a WINDOWS NT 8.0.x/8.1.x DB server results in the following error code: ORA-12545: TNS: name

RE: unused blocks BELOW HWM - Thanks

Uh, amen. Isn't that the purpose of the list? Or is there a *third* list, one on topic, a second off topic, and a third where all the answers really are? -Original Message- Sent: Tuesday, December 18, 2001 10:55 AM To: Multiple recipients of list ORACLE-L Gene - Now that you've

RE: help

HELP -Original Message- Sent: Monday, December 17, 2001 5:50 PM To: Multiple recipients of list ORACLE-L You're kidding, right? --- Boag, Merridy [SMTP:[EMAIL PROTECTED]] [EMAIL PROTECTED] wrote: Does this mean that I am no longer on the mailing list? Thanks you for your help Mer

Error accessing package DBMS_APPLICATION_INFO

List, Do you have any idea, can I flush the memory before running the package, I got this error when I wanted to run a package. Here is teh error message: Error accessing package DBMS_APPLICATION_INFO ERROR: ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN

RE: help

Mer, The listserv is just like a mail redirector, it takes any message and send a copy to everyone on its list. If you are receiving the messages, you are on its list of recipients. As long as you get the e-mails... you are on the listserv. Otherwise you wouldn't get them anymore. Don't

RE: unused blocks BELOW HWM - Thanks

Sure, I haven't got around to using the dbms procedure yet, but these are two queries I ended up with. I have checked them on several tables and the results are the same: here, of course, 1 is the table name and 2 is the owner. the tables need to be analyzed before running these queries

RE: unused blocks BELOW HWM - Thanks

Sure, I haven't got around to using the dbms procedure yet, but these are two queries I ended up with. I have checked them on several tables and the results are the same: here, of course, 1 is the table name and 2 is the owner. the tables need to be analyzed before running these queries

RE: Change PCTINCREAE for SYSTEM Tablespace

the default of 50 for pctincrease, like the (before 8.1.6) default block size for database creation of 2k is legacy. It harkens back to the olden days when you couldn't have lots of extents or autoextend. I'd be much more likely to change the maxextents parameter on the SYSTEM tables or to put

Deciding what columns to partition on

We are doing a redesign of our 200-Gig data warehouse in 9i. One of the things we're thinking about is changing which columns we partition on. Currently, we partition exclusively on date fields. This has proven extremely helpful for doing maintenance, purging old data, archiving, etc.

RE: Change PCTINCREAE for SYSTEM Tablespace

I have to agree with Kimberly. Knowing your storage parameters is the way to go. Don't just settle for defaults. Bing -Original Message- Sent: Tuesday, December 18, 2001 7:10 AM To: Multiple recipients of list ORACLE-L I think even Oracle would disagree with you on that one.

hard disk configuration question

We are in the process of buying new hardware, and our original configuration called for 10 18 GB drives in a Hitachi disk array cabinet. We are getting some sales pressure to change this to 5 36 GB disks. Now I was planning to spread our DB out over as many mirrored pairs as possible, or maybe

RE: unused blocks BELOW HWM - Thanks

Naaah, I'm just the proverbial lazy DBA. Gene received many replies, including it can't be done. Since he happened to point out that two of them worked and produced the same results (an excellent sanity check), I thought it would benefit everyone by telling us which ones worked. I realize that we

ACM SIGMOD-papers of interest #2 with demo URLs

Continuing my previous post, here are a few short reviews, some continaining betas/demo URLs. PREFER: A System for the Efficient Execution of Multiparametric Ranked Queries V. Hristidis, N. Koudas, Y. Papakonstantinou This paper deals with the best way to return a result set quickly for

RE: unused blocks BELOW HWM - Thanks

I agree with larry wall on the laziness of programmers (and DBAs, by association?) is a virtue.. -Original Message- Sent: Tuesday, December 18, 2001 2:10 PM To: Multiple recipients of list ORACLE-L Naaah, I'm just the proverbial lazy DBA. Gene received many replies, including it

RE: hard disk configuration question

This guy is full of it. According to Loney Theriault in Oracle8i DBA Handbook ch. 4 - Physical DB Layouts. The minimum recommended is 7 HD's. The ideal is 22. You are much better off with more smaller size drives than with fewer larger sized drives. My $0.02 worth, Ken Janusz, CPIM

Re: Encryption - Question about the key

Welcome to the security conundrum. When it comes right down to it, there has to be someone you can trust to have the keys to the kingdom. Create a separate Oracle account with a single table with one row in it; your key. Create a package containing a function that can use the key to

RE: help

Another idiot! Guess I better stop before the list owner chastises me and I get banished to OT land. Mohan, Ross

RE: hard disk configuration question

Hold on a minute. I run Oracle on my laptop just fine with a single drive. It would also scream with an EMC disk array attached to it. It really depends on the application(s)/user(s) you are supporting. If they can save a bunch of money and the performance impact is minimal there is no trouble

Omniback and RMAN integration

Title: Omniback and RMAN integration I've got Omniback 3.5 and Oracle 8.0.5 with RMAN on one machine, along with the Omniback/RMAN integration piece from HP. I run util_oracle8.exe -CONFIG (bunch of parameters) everything looks fine. No appearant errors. I immediately try to run

Re: Deciding what columns to partition on

[EMAIL PROTECTED] wrote: We are doing a redesign of our 200-Gig data warehouse in 9i. One of the things we're thinking about is changing which columns we partition on. Cherie, I am not sure that this really relates to your problem but if I think that you should consider partitioning

RE: help

Naw. Just Ross. and we'd all agree he needs help. -- From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Tuesday, December 18, 2001 12:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: help Another idiot!

Re: Slightly OT : RDA from Oracle

OK, John, you've let the cat out of the bag so I might as well stop trying to remain incognito ;) Yes, indeed I did package RDA although you can tell that my Unix skills aren't that great or I would have chosen a less revealing directory structure. RDA is one of the projects I'll be managing in

Re: Change PCTINCREAE for SYSTEM Tablespace

http://www.ixora.com.au/tips/creation/bsq.htm suggests that a non-zero pctincrease may be viable, with the reasoning being based on deferred rollback segments. Rumour has it, Oracle 9i.2 will have a lmt system tablespace which will make the argument moot. hth connor --- Jared Still [EMAIL

Re: hard disk configuration question

-- Steve McClure [EMAIL PROTECTED] on 12/18/01 11:00:22 -0800 We are in the process of buying new hardware, and our original configuration called for 10 18 GB drives in a Hitachi disk array cabinet. We are getting some sales pressure to change this to 5 36 GB disks. Now I was planning to

RE: hard disk configuration question

Steve, You'll have to do the math, and that's still not a complete answer. By 'math' I mean figure out the maximum throughput of their configuration version the one you really want. Also keep in mind that 5 36 gig disks means RAID 5. Being somewhat familiar with that app, I feel fairly

Re: The code doesn't work in the package

Hi, Thank you for your help. Now it works. At 11:00 2001.12.16. -0800, you wrote: You need to read on up on permissions. privileges that you get thru a role does not work for stored objects, like proces/pkgs. joe Csillag Zsolt wrote: Hi, The following code work as you can see below, but

SQL Loader Load Problem

I have a data file of 11 fields to load into a table of 8 columns. I only have to load 3 of the input fields. How do I handle the extra input fields? I cannot use the DB table column for filler more than once. Can I just ignore the input fields I don't have to load? I am using trailing nulls

Re: hard disk configuration question

I have sun sales giving me the same line. I challenged them to prove it yesterday. I hope to have some data on this soon and will follow up. To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY,

RE: conversion from oracle to sql server

SQL Server comes with DTS (Data Transformation Service). See www.swynk.com for more info or look at SQL Server docs if you have them. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Seema Singh Sent: Tuesday, December 18, 2001 2:30 PM To: Multiple

SQL Loader Load Problem

I have an input file that is delimited and contains 43 fields of various widths. I need to load only 3 fields into a DB table of 3 columns. 2 of the fields are at the beginning of the record and 1 is the very last field in the record. How can I load only these 3 cols and ignore the other 40

RE: Encryption - Question about the key

Believe it or not Jared, one of your script gave me following idea (the wrapper sql for decrypt/encrypt on your site). 1. I have a system users table, I can add a column to store user's key in a column that only that user has access to. 2. Create a DBA owned package to handle

Revert from 8.1.6 to 8.0.5

Looks like we have to revert an 8.1.6 database that was upgraded over the weekend back to 8.0.5, but we need to export/import so we don't lose data from the last 2 days. Anything I need to know? The plan is to export using the 8.0.5 export utility before importing back into 8.0.5. Does this

conversion from oracle to sql server

Hi Any one converted oracle database to sql server database?If yes let me know how please?Do you used any third party tools? Thanks -seema _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com --

Re: found dead multi-threaded server

I've gotten these errors (most notably 16365) on numerous occasions and I'm running 8.1.7.0 I've also gotten this error on 8.1.6 with and without the patchset. The main cause of this error is a half-duplex protocol error and, according to Oracle, tends to be application related.See notes

RE: help

LoL! Jared, you're OUT OF CONTROL today, mate! G -Original Message- Sent: Tuesday, December 18, 2001 2:56 PM To: Multiple recipients of list ORACLE-L Another idiot! Guess I better stop before the list owner chastises me and I get banished to OT land.

RE: return single record

I think using 'the' on the collection would be my second choice after ref cursor. Why does your client doesn't want to use ref cursor? I can't think of anything else, as returning arbitrary data structure would be a problem in select. Raj __

Re: Slightly OT : RDA from Oracle

constraints on what I can do with RDA and one of the major ones is that I can't require any third party products to be used so, sorry Jared, but there's no Perl in RDA's future. And I was just getting ready to ask. :) Ya know, if you used Perl, you could even make this work on Windoze.

RE: Encryption - Question about the key

Title: RE: Encryption - Question about the key Jared + Ragendra, One option that you might have is to use a Host Security Module HSM such as those from Thales or Eracomm (cheaper PC based card ~$2000AUD). Essentially this is a piece of cryptographic hardware connected to your host that

Re: Revert from 8.1.6 to 8.0.5

break out the migration guide, there is(if i remember correctly, since i pretty much play with 9i anymore), a down grade script. check out the migration guide for details. joe Ed wrote: Looks like we have to revert an 8.1.6 database that was upgraded over the weekend back to 8.0.5, but

RE: Encryption - Question about the key

Can someone see any drawbacks? What if a satellite falls out of the sky and hits you on the head? Or your significant other can't stand your face for one more day and whacks you with a frying pan? ( narcissists need not worry ) The point being of course, who will know how to access the data

Re: hard disk configuration question

WRT the 2 internals, We mirror those and load only the OS and OS patches. All other stuff goes on the arrays. That allows us to swap machines if necessary by just exporting and importing the RAID volumes. Rodd Holman On Tue, 2001-12-18 at 14:25, Ray Stell wrote: I have sun sales giving

Re: hard disk configuration question

Although I agree with these recommendations, I don't agree that Oracle is such an I/O hog. Oracle was designed to perform I/O efficiently and generally does so. Poorly-written SQL can create an I/O bottleneck, but it's not the fault of the RDBMS. --- [EMAIL PROTECTED] wrote: You are almost

RE: Encryption - Question about the key

What we do is have the application manage the encryption keys. The DBA therefore only has access to the encrypted data. Being the DBA in this equation, I am exonerated from having easy access to the keys, and therefore exonerated when it comes time to hunt down perpetrators (well, nearly!) :).

Help

Any idea what this means ? Error accessing package DBMS_APPLICATION_INFO ERROR: ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN DBMS_APPLICATION_INFO,PL/SQL MPCODE,BAMIMA: Bam Buffer) Begin * ERROR at line 1: ORA-04031: unable to allocate 4096 bytes of shared

RE: Help

Your SGA has become fragmented. You would not per chance be running 8.1.7 would you? If so I would go and do some searching on Metalink. I see an upgrade in your future. You could try flushing the SGA but if its what I think it is it won't help. A restart will for a while. -Original

Re: Deciding what columns to partition on

On Tuesday 18 December 2001 12:55, Stephane Faroult wrote: I have never found the argument 'you scan a single partition' very compelling when your data is properly indexed. Stephane, This is assuming that you are using global indexes on your partitioned tables. If using local indexes and

Re: hard disk configuration question

I was the DBA for 3 years for the app Steve is working on. It won't be happy on one RAID4 volume with 5 disks. Jared On Tuesday 18 December 2001 12:40, Post, Ethan wrote: Hold on a minute. I run Oracle on my laptop just fine with a single drive. It would also scream with an EMC disk array

Re: Encryption - Question about the key

This sounds great until something doesn't work properly. Bet it's difficult to toubleshoot. Has this setup given you any problems in that regard? Jared On Tuesday 18 December 2001 16:25, Austin, Steve S wrote: What we do is have the application manage the encryption keys. The DBA

RE: hard disk configuration question

Well we had our meeting with the Hitachi Sales critter, and engineer. I discovered that they were trying to push a 5 disk raid array and one hot spare at us, because my IT director was really trying to squeeze them on the price of my 10 18GB disk configuration. After the sales guy and engineer

Re: Help

Your SGA is too small. 'alter system flush shared_pool' will temporarily fix this problem, while booting all of your carefully cached sql out of the pool at the same time. Consider: making shared_pool_size larger making reserved_pool_size larger and pinning some objects in memory

Different clocks for different instances.

Gooday Oraclers, is it possible to have different instances, on the same dB server, operating with different clocks - ie different date/times? Environment: Compaq-Digital Tru64 Unix, Oracle 8.0.6, DS20 --- Kevin Pollard | PODBA (Pretend Oracle DBA) mailto:[EMAIL PROTECTED]

Re: Help

RTFM, but i'm in a decent mood, so i cut paste the explanation from oerr(if you're on windoze, move to unix, then you'll have oerr). 04031, 0, unable to allocate %s bytes of shared memory (\%s\,\%s\,\%s\,\%s\) // *Cause: More shared memory is needed than was allocated in the shared //

RE: Deciding what columns to partition on

Did you consider partitioned IOT? Have fun, Waleed -Original Message- Sent: Tuesday, December 18, 2001 1:46 PM To: Multiple recipients of list ORACLE-L We are doing a redesign of our 200-Gig data warehouse in 9i. One of the things we're thinking about is changing which columns we

Re: Revert from 8.1.6 to 8.0.5

Check out the Chapter on downgrading in the 8i Migration manual The 8.1.6 manual pages are still online at http://otn.oracle.com/doc/oracle8i_816/server.816/a76957/migdowng.htm#15124 You need to remove whatever 8i features you may have implemented that are not available in 8.0.5 Depending on

RE: Help

If you are running 8.1.7.1, it has memory leak problem. Need to upgrade to 8.1.7.2.0. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/18/01 5:50 PM Your SGA has become fragmented. You would not per chance be running 8.1.7 would you? If so I would go and do

RE: hard disk configuration question

Resending the email (it bounced back with a locking problem) at fatcity. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd - Forwarded by CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group on 19/12/2001 11:48 AM - CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group

Re: Different clocks for different instances.

Resending. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd - Forwarded by CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group on 19/12/2001 11:49 AM - Change the TZ variable in the Unix environment and restart the instance. My guess is that it should work. Hemant

[no subject]

Hello Gurus, I am working on a little project using the package utl_http, so far I have had limited success using this package. The below http call fails for some reason, it is supposed to download a page of size ~10K, i.e. 5 pieces of data, but instead it fails, I am not sure why... Any

RE: SQL Loader Load Problem

Ken, If you are using 8i, then you can use the 'filler' fields. In this case the control file would look something like below(considering the fields are terminated by a comma and the table has columns a, b and c) load data infile 'myfile' into table mytable fields terminated by ','

recovery during refresh

Hi lists, I need to refresh a test database from production. (test1 from prod1 db) I took the hotbackup files and online redo logs. I created the controlfile using these files. After that I performed recovery. Here I applied online logs instead of archive logs. (There are 7 grous of online

RE: recovery during refresh

Run the following via svrmgrl or sqlplus alter database backup controlfile to trace; This generates a trace file in udump directory. edit trace file: 1) strip out all lines prior to STARTUP NOMOUNT... 2) change all references to SID to test instance. 3) change all reference to file names to

RE: recovery during refresh

Hi Gerardo, Thnq for responding. My doubt is , if I apply online logs , will it cause index corruptions. (ora - 600 error). In my last refresh , I applied online redo log. I got the message when I apply this log is Media recovery completed. After that I opened the db with resetlogs.