RE: change a database connection in a stored procedure?

Hi Sergey, I am using dynamic SQL but it is returing error for connect statement. Can u give me some example code. Rgds Kranti -Original Message- Sent: Tuesday, May 07, 2002 7:38 AM To: Multiple recipients of list ORACLE-L Hello kranti, Use dynamic SQL. Monday, May 06, 2002, 8:23:29

Re[2]: change a database connection in a stored procedure?

Hello kranti, I made a mistake. You can't change your database connection at all from stored procedure (there is no such SQL command connect it's a sqlplus directive). When I gave the answer I thought about database link. You can drop and create it using dynamic SQL. Tuesday, May 07, 2002,

RE: 8.1.7.3 - Good or Bad?

Bugs in 8.1.7.3 that Can Crash the Box ? What Bug Number is that ? Can you Alternately post Kevin Toepke E-mail OR Specify the Date of His posting ? -Original Message- Sent: Tuesday, May 07, 2002 2:25 AM To: Multiple recipients of list ORACLE-L Oracle Gurus, I seem to be running

Re: I need to change the instance name (to Dennis)

Dennis : Thanks for your answer. Well, I need to downgrade my database, changing EE for SE, so ... The most problem is that the v$instance is used in the aplication. I saw in the metalink a document that helps to change the db_name and not the instance_name, understand.. so ... I thought to

Re: Re[2]: change a database connection in a stored procedure?

Hi Kranti, First of all, think about what you wanna do. This looks like logical mistake if you need session change in PL/SQL. When you change the session, what happens with the first one? Session is establised by client requesting the server, so you can only do it from client. If you just want

RE: Good DBA vs. Bad DBA

Any replies? :-) -Original Message- Sent: Monday, May 06, 2002 10:58 PM To: Multiple recipients of list ORACLE-L Subject:RE: Good DBA vs. Bad DBA Dare I ask... do you have a Good Manager vs. Bad Manager list? ;o) Regards, Patrice Boivin Systems Analyst (Oracle

RE: Good DBA vs. Bad DBA

Not yet, but all the California people are still sleeping. Mike is back, I told him that we have to report to helpdesk every morning. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services

RE: ERD generation tool - Active SCM

I thought that there was a way via schema level triggers? I vaguely remember discussion on this last year -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Kimberly Smith [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:28 PM To: Multiple recipients

{9i New Features: V$SQL_PLAN}

Welcome to the next installment of 9i new features(and yes when 9iR2 is released, we'll start this series all over again, woohoo) In the mean time, here is the scoop on v$sql_plan view. This view provides a way of examining the execution plan for cursors that were recently executed. The

Re: Datawarehousing help

[EMAIL PROTECTED] wrote: I was hoping she would figure out the DW hard stuff, then write the book explaining everything with lots of big, colorful pictures...(big grin). If I were to write the book, and she be the tech editor, then she would drive down to Philly and kick myand shove

Re: change a database connection in a stored procedure?

hi! i don't quite understand the problem, but it seems that while running a script you want to build a second connection you can do this if you build the connection with HOST SQLPLUS xxx/yyy@zzz with the first EXIT you disconnect from connection 2 and with the second one from connection 1

Re: Datawarehousing help

Hello Rachel I am working with SAS on the mainframe (os390) and it works fine. We published a RFP for ETL tool and they are one of the candidates. Their tool looks good on paper but we are still evaluating papers and do not have hands on experience. We do have a SAS/oracle application on NT

Re: 9i Automatic UNDO bugs

I know Joe Testa blew up his DB with it... it was in the initial release and was supposedly fixed in the patchsets |+--- || | || | || optimaldba@ya| || hoo.com | |

Re: Datawarehousing help

I worked on a project with an Oracle 7.3.4 database and a SAS OLAP tool. SAS built a datacube using the Oracle database but then the OLAP queries went against the datacube. It worked but we had some very knowledgeable SAS users.

RE: Datawarehousing help

won't be me... why don't YOU write one and then talk to me about the joys of authorship (says the woman going blind looking a page proofs that are totally messed up) |+--- || | || | ||

Re: OT: 8i OCP questions

Hi Rick, There is currently no announced date to retire the Oracle8i OCP test. When announced they typically give approximately one year before retirement. What do you mean by time allowed between tests. John [EMAIL PROTECTED] wrote: Hi, I cannot find any info on Oracle web site

Re: Good DBA vs. Bad DBA

[EMAIL PROTECTED] wrote: Dare I ask... do you have a Good Manager vs. Bad Manager list? you mean there is such a thing as a good manager? why don't people tell me these things?;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED]

Oracle 9iR2 Relase date

http://www.infoworld.com/articles/hn/xml/02/01/31/020131hnoradb.xml Kevin Toepke [EMAIL PROTECTED] The information in

RE: Datawarehousing help

you people are soo funny. Writing a book takes time, hard work and more energy than I care to commit to the project.. especially on a subject with which I have zero experience |+--- || | || | |

Logs of SQL

Higurus! Where does the logs of sql get stored? In my case i have one Dll file , i call the standard function which are being exposed by the Dll . Those function must be firing SQl. i want to See those SQls. Thanx in advance... Shishir Kumar MishraAgni Software (P)

RE: Erwin - Does this thing work?

In our case, we had to add the following: In Windows settings, control panel, system, advanced, environment variables, add: Variable = NLS_LANG Value = American_America.UTF8 Rich -Original Message- Sent: Monday, May 06, 2002 10:28 PM To: Multiple recipients of list ORACLE-L There

Re: ERD generation tool - Active SCM

Hello Kieth you wrote: It would have been better to give your developer truncate only privileges, You mean: grant truncate on owner.table to user. No such grant. The closest I could find is: Create procedure that truncate the table as the owner and grant execute on the procedure to the user.

recovery keeps wanting logs

Recently installed a W2k server on a SAN. Using backupexec for W2K. Initial test worked great. This week one final test before moving a production database to it. Backed up the database. Restored the database. Launched recovery, it requested the log from during the backup and then wanted

Re: I need to change the instance name (to Dennis)

Right BUT: make sure you do not use any option that does not exist in the standard edition but existed in the enterprise edition. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 07, 2002 12:18 PM Dennis :

Password Checking

All: I am looking for an algorithm that will verify that a pasword meets minimum requirements (like 8 chars, mix of chars nbrs, != username, etc), but am just feeling too darn lazy to write one myself. Can anyone on the list help me out by pointing me to a good one? Thanks Kevin Toepke

RE: 8.1.7.3 - Good or Bad?

Vivek, Although there is not much more information, here is the complete message from April 17th, 2002: ** Jack: First of all, there are some serious problems with 8.1.7.3 that can cause database crashes and corruption. One

PK - Character vs. Numeric

I'm sure this has been raised in the past, but... Is it better, in terms of performance, to use numeric primary keys versus character/string keys? It is my understanding that this is really a space-savings issue rather than a performance issue. Can someone elaborate more on this? Thanks.

RE: Re[2]: change a database connection in a stored procedure?

Hi Alexandre, I am writing a procedure to create a user, grant privilleges to the user nad then connect as that user and create schema in that user. I want this whole process to be automated. That is why I want to change a database connection. Anyway I have done it using batch file.

RE: Datawarehousing help

Come on, Rachel! Zero Experence has never stopped anyone from publishing. Just look at academia and MCSE study guides... Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 8:19 AM To:

Online redo sizing and parameters

I'm looking to resize our online redo logs for a particular app and am somewhat confused about the appropriate settings. The current config is 4 groups (2 members each) of 5Mb size. We cycle through a daily average of 750 logs in a 22 hour period. During a more intensize daily batch window of 5

RE: {9i New Features: V$SQL_PLAN}

Kewl! Oracle has finally grasped the concept of a slow query log. Glad to see Oracle is at least trying to catch up to MySQL. --Walt Weaver Bozeman, Montana -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, May 07, 2002 7:48 AMTo: Multiple

RE: Erwin - Does this thing work?

I am also using ERWin reluctantly. What exactly is the FK problem you mentioned? I am using v.4.0. Erik -Original Message- From: Kimberly Smith [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002 10:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: Erwin - Does

RE: Datawarehousing help

nuh uh, for two reasons, the first and foremost being, I was paying attention when you spoke about the joys of authorship. the second is that I was paying attention when you spoke about the joys of authorship... .. . .. ... .. .. .. . -Original Message- [mailto:[EMAIL PROTECTED]]

Re: Good DBA vs. Bad DBA

HEY! I resent that. ask the last person who worked for me, I think I was a pretty good manager! |+--- || | || | || bthater2@nets| || cape.net | ||

Re: Good DBA vs. Bad DBA

[EMAIL PROTECTED] wrote: HEY! I resent that. ask the last person who worked for me, I think I was a pretty good manager! but you are the goddess, and i never worked for you. i don't call it damagement for nothing. -- -- Bill Shrek Thater ORACLE DBA

Clone Database

I have to refresh a development database every day with the production DB. The size of the DB is 70GB and import last like 7 hours. Does anyone in the list has the steps to clone a database, not using import. TIA Ramon E. Estevez

Listener question. What is PNPKEY?

The default listener.ora file contains an IPC listing with (KEY=PNPKEY). I've searched the documentation and can't find any description of what this is for. Thanks, Keith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Moore INET: [EMAIL PROTECTED] Fat

AW: Re[2]: pl/sql is INTERPRETED?

Hi Dennis I was just working on a framework to make your dream come true ;). We are going to use a thin abstraction layer to provide peer objects to business objects in order to make them persistent (what a surprise). Old concept, but we didn't even try to do it the one size fits all way. The

Re: ERD generation tool - Active SCM

Sorry to disappoint you all. I gave him the password so he can connect as the owner and then he can do truncate. I scanned the list later and found the discussion on the subject and I am going to replace that with a procedure that he will be granted execute. Yechiel Adar Mehish - Original

RE: Erwin - Does this thing work?

That's one I haven't heard about! -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of Ji, Richard [EMAIL PROTECTED] Sent: Tuesday, May 07, 2002 11:58 AM To: Multiple recipients of list ORACLE-L Subject: RE: Erwin - Does this thing work? In our case,

iTAR

I've been unsuccessful submitting an iTAR so far this morning. I'd like to hear if other list members have had success or failure opening a new iTAR today. FWIW - It fails using both Netscape IE browsers; but I get different symptoms from eachof them. -- Charlie Mengler

CA's Data Dictionary for Oracle v9i Poster

http://ca.com/products/posters/oraclev9i_poster_form.htm Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: Datawarehousing help

it stops me. I refuse to deliberately look like an idiot... I do enough damage inadvertently |+--- || | || | || [EMAIL PROTECTED]| || ms.osd.mil

RE: Good DBA vs. Bad DBA

She was terrible!! I was SO happy when she left!! Talk about micro-management. Checking every single SQL script before I ran it. I couldn't believe she used that baseball bat on the duh-velopers!!! They were all in tears of joy when she left. -Original Message- [mailto:[EMAIL

catalog maintenance

Hi, Does anyone know of any usefule scripts/tips to effectively maintain the rman catalog?? Most notably to delete very old entries??? Thanks in advance Fwzia ** Information in this email is confidential and may be

RE: 8.1.7.3 - Good or Bad ~~ Upgrade 8.0.5 to 8.1.7.3

Title: RE: Upgrade 8.0.5 to 8.1.7.3 Kevin Can youfindthe Bug Number possibly ? Can you Give us the TAR Number ? This would indeed allow me to STOP our Clients from moving to 8.1.7.3 from 8.1.7.2on SUN Sparc Solaris 8 Thanks Vivek -Original Message-From: Toepke, Kevin M

Re: Clone Database

Ramon, There is a paper on my site (http://www.optimaldba.com/library/CreatingOracledbusingphysicalcopy.html) that outlines the procedures to perform this cloning. The document uses 7.3, but the procedures remain the same. I would also recommend using this time to periodically test your

RE: ERD generation tool - Active SCM

via ActiveDesigner/ActiveChangeManager...just click on icon privileges and grant truncate only ref: http://www.iraje.com/acc_changemanagermain.htm Keith Date: Mon, 06 May 2002 18:28:25 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Reply-to: [EMAIL PROTECTED] Organization:

unknown value

Hi all: This is probably a simple question, but then again may be not. We are developing an application and will be loading data into bunch of tables. We will have a situation where some of the values will not be provided for various reasons. We don't want to make them NULL because some of these

RE: iTAR

So far as I have been able to find out... I-tar is broken. The voice mail thing I got at the real person line said they were having system troubles but I got a human fairly fast when I got fed up with waiting for metalink and called and waited in the queue. April Wells -Original

RE: catalog maintenance

Fwzia, I use the following to generate commands to delete old backups (more than 90 days old)from the Rman Catalog. The output from the script (rman_delete.rcv) is fed into Rman to clean up the catalog. I run this job once a month. Hope this helps set heading off set feedback off set newpage

RE: Clone Database

Ramon, Are you able to do a refresh from a hotbackup of the database? Bryan -Original Message- Sent: Tuesday, May 07, 2002 10:29 AM To: Multiple recipients of list ORACLE-L I have to refresh a development database every day with the production DB. The size of the DB is 70GB and