Calling a Stored procedure from Java which returns cursor value

Hi all I was running following code in from this list only and I want to call it from java code. Code is CREATE OR REPLACE PACKAGE Apack AS TYPE RefCurTyp IS REF CURSOR; END APACK; / CREATE OR REPLACE PROCEDURE demo_ref ( refcurvar IN OUT Apack.RefCurTyp, choice NUMBER) IS BEGIN IF choice = 1

Re: Automatically startup database

Thanks for your help, I have checked that the Automatic Startup Type as Dave's said is set on the control panel service's. Also as Marin and Igor said to check the registry and this value are set as TRUE for ora_sid_autostart. If I run C>sqlplus internal/ i got thiw error message "Connected to

Re: Fav. Urban Legend...Mem vs Disk

UNIX problem ? If memory is allocated from the HEAP it is never really returned to the OS when we do a free. The free only happens when the process exits. So the question is: Do we need the 200 MB or is it somekind of memory leak ? If we need the 200 MB, remember that we are running on a demand pa

Re: Express Server -- Oracle Financial Analyzer Question

Is the OFA instance an Express Server 6.x database ? Then, it is not an RDBMS issue until 9i when Express server is merged with the RDBMS. I haven't worked with Express Server but... maybe someone who has worked with Express Server can help. Hemant K Chitale Principal DBA Chartered Semiconductor

RE: Remote DB Installation

Sorry I was too quick in sending.   With the telnet, you need some sort of X windows application - liek Reflection X or XWin or something like that.   The Oracle Installator will work via this.     -Original Message-From: Sujatha Madan [mailto:[EMAIL PROTECTED]]Sent: Friday, 22

Re: Remote DB Installation

Just a few options - I'm sure there are others that I haven't listed: 1) VNC from AT&T Labs http://www.uk.research.att.com/vnc/ VNC needs to be installed on client and server. 2) (method I use for Unix/Linux remote installs) SSH w/ X11 tunneling You'll need a local X Server - either buy one t

RE: Remote DB Installation

You need to establish a telnet or ssh connection to the remote server. That's all you need.   -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]]Sent: Friday, 22 March 2002 2:33 PMTo: Multiple recipients of list ORACLE-LSubject: Remote DB Installation I have

Re: refer to SYSDATE function in a CHECK constraint--doable?

HI Roy, As you have already figured out sysdate cannot be used in a constraint. John [EMAIL PROTECTED] wrote: >Greetings all, > >I've got a table with a date field on a 8.1.6.0 db. I'd like to constrain >the values entered into this field to be less than or equal to the date on >which the rec

RE: Accessing databases with different character sets

Hi use should use American.America.UTF8. in the client configuration Ayyapps This communication contains information, which is confidential and may also be privileged. It is for the exclusive use of the intended recipi

Re: ORACLE 9i Database and Oracle9ias application

Actually, there are a number of InterOperability patches for 9iAS 1.0.2.2 with the 9iDB. I'm only running 9iAS 1.0.2.2 against 8.1.7 yet. BTW, if you check the Certification Matrix on Metalink, do not select the product "Application Server (9iAS)" This contains incomplete certification for 9iAS 9

Re: diag.cmd script

Patrice, That you're running diag.cmd and not diag.csh, I assume you are on NT. What version of iAS and Portal are you using. I have used diag.csh (on Solaris, iAS 1.0.2.2, Portal 3.0.9) when we had issues cloning a portal environment some months ago and had learnt to ignore some messages.

Remote DB Installation

I have a possible opportunity to install an Oracle DB (8i or 9i) for a company located in Central America.  I am located in the Minneapolis / St. Paul, MN area.  What tools would I need to install this remotely from MN?  The server would probably be Sun or HP unix.   Thanks, Ken Janusz, CPIM

diag.cmd script

Something strange has happened. This utility, supplied with iAS to test portals, tells me there may be something wrong with my portal. In fact, it can't find the server name for the portal. Meanwhile we can access the portal no problem from a Web browser. I logged a TAR with Oracle to ask them

RE: RE: Intersystems Cache database

"Hospital" is the key. Cache was originally developed in the '70 for use in medical applications, of course, back then it was known as MUMPS before the PR guys got a hold of it. The UNIX types will tell you that any app that has been around for three decades has to have something going for it.

RE: OT : Unix script to monitor log file size/disk space

Hi Radim, We are using Sun Solaris Version 2.6 right now. By this weekend, we'll be upgrading our OS to Version 2.8. I am very interested in your script. Could U send your scripts to me? Thank you so much. Regds, New Bee -Original Message- From: Radim J

Re: Error in procedure with dba_users

I also created a user for this, but with privs: create session, select_catalog_role, and analyze any. Haven't found a reason (yet) to grant DBA or any other privs. However I'm not yet using DBMS_STATS, maybe that requires more(?) "Jesse, Rich" wrote: > > You could try GRANT ANALYZE ANY TO SYS

RE: Error in procedure with dba_users

Tks Jesse, I like that solution, more than I worked it out. tks -Original Message- From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> on behalf of "Jesse, Rich" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 6:13 PM To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTE

RE: RE: Intersystems Cache database

I've heard of them... Some guys at the last place I was at had used it as the back end for a lab results viewer at a hospital in the Boston area... They loved it... They kept telling me how great it was but I never saw it in action... I took most of it with a grain of salt since they were devel

Raw device

Can anyone point me to a FM or explain me what is a raw device, and why not use simple file system instead. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Californ

could not open the forms/reports on the web

I could not open the forms/reports on the web. When I try to run on the web, it asks me to 'open from current location/save to the disk'. Again when I select ''open from current location' it is not opening. Any suggestion is appreciable. I am using Form6i/Report6i against oracle 817 database an

RE: Error in procedure with dba_users

Tks Igor and all that reply, that was my problem. I already solved. tks again Ramon -Original Message- From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> on behalf of "Igor Neyman" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 5:48 PM To: "Multiple recipients of list ORA

RE: Intersystems Cache database

Haha very funny. >From: "Jesse, Rich" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Intersystems Cache database >Date: Thu, 21 Mar 2002 13:58:23 -0800 > >Yeah, like that ain't a plug from someone acting like an Oracle

Oracle/SQL Server DBA Needed in Louisana

Fast Growing Company in the Lafayette, Louisana area (southern part of the state) needs an Oracle /SQL Server DBA. PLEASE DO NOT send your resume for this position UNLESS you already live in Louisana or a surrounding state and have the skills outlined below for this position. DO NOT send your

Re: Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7

Hello all, I think problem solving is an art. No one can know every solutions for every problems. If we don't use a methodical way, in other words if we use TEST-AND-SEE way, we waste our time. We should not jump into problem immediately. For your case: A- Problem: session/db hangs We don't kno

Re: ORACLE 9i Database and Oracle9ias application

Seema Singh wrote: > > Hi > If I want to install oracle 9i Database and oracle 9iAS on same box. > Is it necessary to have diffrent home for both or same? use DIFFERENT home directories > If I use oracle as unix loginname for oracle9i database then can I use same > unix loginname for Oracle 9

Re: Sightly OT: Unix scripting

Yes it's day-of-year. Some Unix doc's list it as "Julian day-of-year". Same difference... Brian Jared.Still@ra

RE: Intersystems Cache database

Experience says that nothing is as robust as the marketing trolls would like you to believe. It is impressive add copy, though. Scott Shafer San Antonio, TX 210-581-6217 "Common sense will not accomplish great things. Simply become insane and desperate." > -Original Message- > From: or

Re:RE: Intersystems Cache database

Anyone else ever hear about them? According to the web site that have '4 million users'. Seems that would have left a mark somewhere at that level. Dick Goulet Reply Separator Author: "Jesse; Rich" <[EMAIL PROTECTED]> Date: 3/21/2002 1:58 PM Yeah,

RE: Error in procedure with dba_users

You could try GRANT ANALYZE ANY TO SYSTEM I didn't want to do that, in case we upgraded via export/import, in which case I might overlook that when SYSTEM got recreated, so I created a new DBA user and granted it the same privs as SYSTEM, plus the one above. We use this new account to do our DBM

RE: Intersystems Cache database

Yeah, like that ain't a plug from someone acting like an Oracle DBA. 1) No signature. 2) Generic e-mail account from a generic mail domain. 3) No recent posts to this list. Probably just a Cache salesman... Rich Jesse System/Database Administrator [EMAIL

ORACLE 9i Database and Oracle9ias application

Hi If I want to install oracle 9i Database and oracle 9iAS on same box. Is it necessary to have diffrent home for both or same? If I use oracle as unix loginname for oracle9i database then can I use same unix loginname for Oracle 9iAS or not? Thx -Seema _

Re: Error in procedure with dba_users

Well, I guess, it means exactly what it says in the error message: user SYSTEM does not have sufficient privileges to analyze some schema (selected in ESQUEMAS cursor). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTEC

RE: Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7

Oracle supports response to my answers was to increase SHMMAX from 128M to 4G and SEMMNS to 2000. Upping the semaphores seems like a good idea, but when I questioned why we should increase SHMMAX to more than 2x the real memory on the machine, the answer was "I had my Unix Guru look at these and

Java permissions

Could someone please tell me how to see the java permissions granted in the data dictionary from dbms_java.grant_permission, something similiar to dba_sys_privs, dba_role_privs, dba_tab_privs? Mike _ Get your FREE download of M

OT: Intersystems Cache database

Hi, Does anyone know about the Cache database? Is it REALLY that robust as they claim to be? http://cache.intersys.com/cache/fb/fb_03.html Thanks. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. --

RE: OT : Unix script to monitor log file size/disk space

Hi, What version of unix do you use ? I use this script on HP. If you want I can send it to you. Radim -Original Message- Ling Catherine (CSC) Sent: Wednesday, March 13, 2002 6:08 AM To: Multiple recipients of list ORACLE-L Hi Gurus, Does anyone have the unix script to monitor disk

RE: Error in procedure with dba_users

Adary, I am creating the procedure as system. I can select the table without no problem. I changed to all_users and worked fine, but the dbms_utility doesn't work. Below is an example. TIA Ramon. CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS CURSOR ESQUEMAS IS SELECT USERNAME

refer to SYSDATE function in a CHECK constraint--doable?

Greetings all, I've got a table with a date field on a 8.1.6.0 db. I'd like to constrain the values entered into this field to be less than or equal to the date on which the record was entered. I figured a table-level check constraint would serve & so I ran: ALTER TABLE TLB_COPIES ADD (CONSTR

RE: Sightly OT: Unix scripting

Terry, I don't see a format like that in the unix date command formats, unfortunately. You may have to test the value and pad the number yourself. I have to do that in a number of my perl scripts. You are lucky you have Unix... Lisa Koivu Oracle Database Monkey. Fairfield Resorts, Inc. 954-

RE: Error in procedure with dba_users

tKS David, that worked. -Original Message- From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> on behalf of "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 12:14 PM To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Subject:Re: Error i

Re: Sightly OT: Unix scripting

I'll show you one way to do it, if you quit calling that a Julian date. :) ( YYDDD is not a Julian date ) $> echo $DATE 2079 $> DATE=$(echo $DATE | awk '{ print substr(""$1,length(""$1)-4) }') $> echo $DATE 02079 Jared "Ball, Terry" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED

Re: Sightly OT: Unix scripting

(all examples are using /usr/bin/ksh shell) You could do it this way: DATE=$(date '+%y%j') DATE=$((${DATE} - 1)) [ ${#DATE} -eq 4 ] && DATE="0${DATE}" But you have bigger problems my friend. What happens if the date is 02001 and you subtract 1. The result is 02000 which is invalid. Since yo

8.1.6

Hi, We are on 8.1.6.0.0 on NT 4.0 and want to apply patches which were fixed in 8.1.6.3.0. We just want to confirm which is the most stable patchset for 8.1.6 . We have feedback that 8.1.6.3.4 is stable and other group recommended 8.1.6.3.8. It will be great to have ur feedback with ur experience

Re: More info on sql query running slow

I agree with /*+ORDERED */ hint suggestion (in combination with inline view). I've seen cases, when inline view itself didn't do the job, but along with /*+ORDERED */ hint proved to be a huge performance benefit. So, try: SELECT /*+ORDERED */ COUNT(a.phy_contract_id) FROM accrued_and_pa

Re: strange tkprof output for SQLs - II

Hello Mogens, I saw this problem whether or not shared pool was flushed for PL/SQLs. Here are my observations for SQLs!!! and PL/SQLs: - Enabling sql trace from current session: When a cursor is closed after their child recursive statements, their recursive statistics parsed after the statement a

Sightly OT: Unix scripting

Environment: Oracle 8.1.6.3 on Solaris 5.8 I am not a Unix Guru by any strech of the imagination, so I can use all the help I can get. I am trying to write a shell script to execute sqlldr of a file whose name includes yesterday's 2 digit year and julian day in the format: file_yyjjj.csv. I ca

RE: kill the procedure Call

Hi Rakesh, Nice notes. However, you haven't mentioned the platform: The 'netstat' command, the tcp parameters mentioned and their configuation vary quite drastically across platforms. Was the original from a HP platform? John Kanagaraj > -Original Message- > From: Rakesh Gupta [mailto:[

Accessing databases with different character sets

We are installing an engineering design application which has its own database and, in addition, needs to access the database of another application. Both are commercial applications where we do not have access to source code. Application A runs on NT and uses a character set of American.America

RE: Rebuilding Index Organised Tables (IOTs)

Hi Jonathan, Even this may not be the case (in my opinion I could be mistaken, my respects for every one). As you know any index is made of branching blocks and leaf blocks. When we build an index, it's mainly to get rid of deleted rows/entries in the leaf blocks and reclaim that space. Also re

Re: Automatically startup database

In fact, you need both: 1) set your oracle service to startup automatically; you need this in order to start Oracle process on NT automatically, but this is not enough to "startup" the database automatically, when oracle process starts. In order to do this, you need to: 2) set registry key ORA_si

RE: Rebuilding Index Organised Tables (IOTs)

Well, you mentioned that there were bugs: > but there are still some nasty bugs with online index rebuilds (which is > what this actually does) so it might be safer not do use the option for an > IOT. Thanks Kumanan > -Original Message- > From: Jonathan Lewis [SMTP:[EMAIL PROTECTED]] >

RE: Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7

Well, unfortunately we haven't solved the problem yet, so I don't have any solutions to share with everyone. We are using Sun hardware, and we have not run diagnostics on the memory. I don't want to dismiss that idea out of hand, but I don't understand how bad memory could be affecting only one

RE: Rebuilding Index Organised Tables (IOTs)

Thanks Jonathan. I'm just going o test it out. Will let you guys know if there are any positive outcomes. Thanks Kumanan > -Original Message- > From: Jonathan Lewis [SMTP:[EMAIL PROTECTED]] > Sent: 21 March 2002 17:08 > To: Multiple recipients of list ORACLE-L > Subject: Re: Rebui

Re: Automatically startup database

- Original Message - > How to make database instance on Win2K automatically startup when the PC up? it is specified in the windows registry check HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 there should be entries named ORA_sid_AUTOSTART for each instance in this ORACLE_HOME (where *sid*

Re: Rebuilding Index Organised Tables (IOTs)

8.1.5 and 8.1.7 both support alter table iot_tab move for IOTs - is there a special bug in 8.1.6 ? Your own notes even describe this: |The move_table_clause rebuilds the index-organized table's primary |key index B*-tree. The overflow data segment is not rebuilt unless the |OVERFLOW keyword

Re: Rebuilding Index Organised Tables (IOTs)

Correct, and apologies, it's too easy to give the quick and simple answer. If you want to rebuild the whole thing, without changing tablespaces, then: alter table iot_tab move overflow; You can't move the overflow with an online move, of course (except in Oracle 9, I expect). If you also

RE: Automatically startup database

You need to make sure that the oraclesservice is set to automatically start in the Services panel. Dave -Original Message- Sent: Thursday, March 21, 2002 10:38 AM To: Multiple recipients of list ORACLE-L How to make database instance on Win2K automatically startup when the PC up? for

Re: Embarcadero DBArtisan Trial Version

Uninstall the trial version and reinstall it? I don't know if that will work but it is worth a try. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, March 21, 2002 10:58 AM All, Six months back I installed DBArtisan trial version.

RE: Embarcadero DBArtisan Trial Version

The download of the evaluation copy of dbartisan states clearly that it is good only for 15 days. I think that you need to download another evaluation copy. If you need you can contact [EMAIL PROTECTED] and I am sure they will be happy to assist you. Yechiel Adar, Mehish Computer Services [EMAIL

RE: Embarcadero DBArtisan Trial Version

Phone up Embarcadero, and ask them for an extended trial key? This is pretty much the norm for these types of tools.. Embarcadero should just give you a key that will last for another month. Tools like this keep track of if a product was installed previously, and store some obscure key in the regi

RE: A RMAN question

Thanks Jay.actually our clients want it that way that the cloned DB is backed up instead of the production DB. I think u r right about RMAN getting confused when it reads the controlfiles the next day for taking an incremental backup since they will have been replaced overnight. But I am usi

RE: Use of Orastaff

You want to OT don't you. The power of the OT list is strong in you young Koivu. -Original Message- Sent: Thursday, March 21, 2002 10:08 AM To: Multiple recipients of list ORACLE-L Good point Peter. There may be a lot of slimy ones, but I've also found one or two I would gladly work w

iFS - storing XML via Windows Explorer

Hi, we have a iFS instance. iFS lets you update an attribute of a file by copying a proper XML file into a directory and iFS interprets it as a command. If something is not O.K. with the file, it spits out an error file into the same directory. Now my problem is that I would like to store an XML

RE: ways to speed up import

All the suggestions I have seen are focused on improving import, which is great. But how about stepping back, and talking with the client about using transportable tablespaces? -Original Message- Sent: Wednesday, March 20, 2002 10:48 PM To: Multiple recipients of list ORACLE-L i'm get

Re: OAS 9i anyone?

Gary Weber wrote: > > Greetings, > > We are contemplating a purchase of Oracle Application Server 9i. > > Anyone using it? "We" are. (TIMW). > Mind sharing your experience? No > > What prompted you to purchase an Application Server? Why was Oracle App > Server chosen, as opposed to Webl

RE: Error in procedure with dba_users

Tested it. You do not have permission for dba_users. You need to have role select_catalog_role. On 8.1.6.3.4 on NT. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Thu, March 21, 2002 5:33 PM > To:

RE: Revoke alter password frm user

revoke ALTER ANY USER or ALTER USER privilege from this user. -Message d'origine- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Date: jeudi 21 mars 2002 16:13 À: Multiple recipients of list ORACLE-L Objet: Revoke alter password frm user Hi list, Is it possible to revoke a oracle u

Automatically startup database

How to make database instance on Win2K automatically startup when the PC up? for now I have to run C:> sqlplus internal sql>startup ...every time myserver is powered on. TIA, Ferry Situmorang: Using Oracle 8.1.7 Designer 6i R4 PT Perkebunan Nusantara XIII (Persero) Pontianak-Indonesia http:/

RE: Oracle CERT Advisory

I think that Oracle's bravado has translated into lower share prices recently... : ( Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Thursday, March 21, 2002 10:48 AM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle CERT

Re: Error in procedure with dba_users

You must grant select on DBA_USERS *directly* to the user creating the procedure - not via a role. hth connor --- [EMAIL PROTECTED] wrote: > Hi list, > > I have this procedure under the system user, and > when try to create it > I get an error > > CREATE OR REPLACE PROCEDURE GENERAR_ESTADIST

RE: Use of Orastaff

Good point Peter. There may be a lot of slimy ones, but I've also found one or two I would gladly work with again that call me from time to time to check in on me. If anyone wants a good recruiter's name in Florida, email me directly. Lisa Koivu Oracle Database Barrel Belly Fairfield Resort

Embarcadero DBArtisan Trial Version

All, Six months back I installed DBArtisan trial version. I didn't get a chance to play much with DBArtisan. Now I un-installed DBArtisan and reinstalled again on same desktop. It is prompting me to enter license key. Is there a way to get trial version without rebuilding my desktop. I think

Re: Direct Import of XML file

Search otn.oracle.com for the XML Developers toolkit, XDK. --- [EMAIL PROTECTED] wrote: > Hi list, > > Is there any tool in Oracle to import a xml-file direct to a > database table? > > TIA > > Volker Schoen > E-Mail: [EMAIL PROTECTED] > http://www.inplan.de

PO 9i and Windows Me

Hi everyone Has anyone installed Personal Oracle 9i on Windows Me? You could run PO 8.1.7 for Windows 98 on Windows Me. Friend of mine just installed PO 9i for Windows 98 on his Windows Me computer and run into problems. I wonder whether it doesn't run on Windows Me or it is his computer issu

Re: kill the procedure Call

If you are using unix, you have to play with tcp kernel parameters. We have tuned these parameters: tcp_ip_abort_interval the time it takes for an existing connection to be closed tcp_ip_abort_cinterval the expiration time for establishing a new connection tcp_time_wait_interval the length of

OAS 9i anyone?

Greetings, We are contemplating a purchase of Oracle Application Server 9i. Anyone using it? Mind sharing your experience? What prompted you to purchase an Application Server? Why was Oracle App Server chosen, as opposed to Weblogic, etc? J2EE considerations? Ease of configuration/maintenance

9i install

We are going to 9i on our NT4.0 SP6 prod box. I will test the 9i install on a test box first. My question is: Do I need to install a patchset with 9.0.1.0.0 or can I run as is? If I run the catexp from 9i into 8i (as SYS) and export I will be able to import into 9i, correct? Any advice is high

RE: A RMAN question

Hi Yechiel, Of course I do use a RMAN catalog on server B to backup the cloned database. The scenario I described was because I am wondering whether RMAN will be happy taking a second incremental backup the next day after the controlfiles of the target database were overwritten overnight. Plea

RE: Rebuilding Index Organised Tables (IOTs)

Many thanks to all of those people who advised. Unfortunately we are running on 8.1.6.3, so cannot do "alter table move.. " as well :( If you get any info, please let me know. Meanwhile, here are few bits that I gathered in IOTs. Cheers Kumanan Why use Index-Organized Tables * Fast key

Error in procedure with dba_users

Hi list, I have this procedure under the system user, and when try to create it I get an error CREATE OR REPLACE PROCEDURE GENERAR_ESTADISTICAS AS CURSOR ESQUEMAS IS SELECT USERNAME ESQUEMA FROM SYS.DBA_USERS WHERE USERNAME IN ('RAMON', 'SCOTT'); BEGIN FO

RE: Use of Orastaff

I sent a resume to them once. It fell into a black hole. If you are looking for a head hunter, Jim Wilson with Triad Group in Seattle is the quintessential professional. Always honest even if you do not always like what he has to say. About a year ago I talked to him, his advice 'sit tight'.

RE: system packages status is invalid Oracle 8.1.7 on red hat 7.2

You might want to run UTLRP.SQL on your database. Do this as SYS or INTERNAL. Also remember to do a SET ORACLE_SID=your_sid first. Dave -Original Message- Sent: Thursday, March 21, 2002 8:38 AM To: Multiple recipients of list ORACLE-L 7.2 And you can't compile them? Lisa Koivu Ora

Re: Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7

I am sure that you don't have any invalid objects after the patch application. I had a lot of problem with that after a patch application two years ago. Sharon -- Xiaohong Yang (Sharon) certified Oracle DBA Center for Bioinfomatics, CB#7100 S

Revoke alter password frm user

Title: Revoke alter password frm user Hi list, Is it possible to revoke a oracle user the right to alter his password? TIA Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de

RE: system packages status is invalid Oracle 8.1.7 on red hat 7.2

Run rdbms/admin/utlrp.sql or utlrep.sql. Then query again for invalid packages. If there are still many, then not enough room to hold them all in your shared pool. Packages are invalid when the db starts up, because no one has accessed them yet. Utlrp.sql forces Oracle to do the work up front.

Direct Import of XML file

Title: Direct Import of XML file Hi list, Is there any tool in Oracle to import a xml-file direct to a database table? TIA Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de

RE: A RMAN question

I think RMAN will have problems with the incremental backup. When it looks at the control files for the cloned db, they will have no record of a previous backup. What you are doing is a bit unusual in that the database on server A (which would be considered production) should be backed up. An

RE: Oracle CERT Advisory

Thanks Patrice for sharing this info. So much for "Can't break it. Can't break in. Unbreakable" marketing jingle. Lisa Koivu Oracle Database Something. Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, Mar

RE: ORACLE TUNING

Thanks, I'll post. -Original Message- Sent: Thursday, March 21, 2002 3:58 AM To: Multiple recipients of list ORACLE-L Why not post the query and the two plans ? Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html

RE: Re[2]: Fav. Urban Legend...Mem vs Disk

A most enjoyable book "Venus on the Half Shell", written by Philip Jose Farmer under the pseudonym Kilgore Trout, who was a character in many novels - particularly "Breakfast of Champions" - by Kurt Vonnegut, who was a good friend of Mr. Farmer - also the author of the "Riverworld" trilogy (quadri

Oracle Licensing Mess

Someone posted the original on this topic, which I sort of stayed away from, I too often on those types of topics put my foot into the mouth. Anyway, the following came across the wires this morning from Information Week. Some of you may be interested, me I'm off to do some more with PostGres &

RE: system packages status is invalid Oracle 8.1.7 on red hat 7.2

And you can't compile them? Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: Praveen Sahni [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, March 20, 2002 5:33 PM > To: Multiple recipients of list ORACLE-L > Subject: system pac

RE: Use of Orastaff

I got an email from them asking to fill out a skills matrix. Never heard anything further. "Koivu, Lisa"

Re: Failed login attempts

1. change the initializaion parameter audit_trail to be: audit_trail=db shutdown and restart database 2. connect to the database as a user that has the privilege "AUDIT SYSTEM" and enter audit session whenever not successful at this point you can see these unsuccessful logins by monitoring

RE: ORACLE TUNING

Thanks -Original Message- Sent: Wednesday, March 20, 2002 11:23 PM To: Multiple recipients of list ORACLE-L Are the sizes of the tables same on both development and production machines? In our case, we used histograms on indexed columns and that brought execution plans same on both the

RE: A RMAN question

Hello Samir I do not work with RMAN but I THINK that you have a conceptual error in your logic. Since you do not have a catalog RMAN use the control files as catalog. When you want to restore RMAN will not find the data on the full backup in the control files. You will have only the data on the l

RE: Use of Orastaff

Go to this site to sign up for some "enlightening" discussions!! http://groups.yahoo.com/group/oracle-l-ot/ Dave -Original Message- Sent: Wednesday, March 20, 2002 3:01 PM To: Multiple recipients of list ORACLE-L Ruth, What is the procedure to subscribe to the OT list, please? TIA, Sc

Failed login attempts

Hi all, Which is the best way to keep audit of failed login attempts to the oracle server -without turning on full audit? Thanking you, --- +---+ C.S Waibale Simon MTN-Uganda, Cell: +256 77-212655,http://mtn.co.ug +-

Re: Workaround for using NTILE function in Oracle8i

Just wrap it within 'execute immediate' and it will run fine. hth connor --- Kieran Murray <[EMAIL PROTECTED]> wrote: > Hi Everyone, > I'm writing PL/SQL code which utilizes the NTILE > function but have just > found out that due to a bug in Oracle8i the function > works from Sqlplus but not wh

Re: Workaround for using NTILE function in Oracle8i

Look into native dynamic sql - the standard trick with SQL that pl/sql cannot handle is to do something like: declare cursor variable declaration begin open cursor_variable for 'your sql string as a text string' ; loop fetch cursor variable into local variables

  1   2   >