RE: Partition and primary key

Title: RE: Partition and primary key Here a sample of my alert.log, SCOPE_MD_IDX is my index tablespace : ORA-1652: unable to extend temp segment by 320 in tablespace SCOPE_MD_IDX ORA-1652: unable to extend temp segment by 320 in tablespace TEMP 1. I've then created a primary key with

RE: windows application to show sql being executed by a client

Title: windows application to show sql being executed by a client program Hi Jacques The tool is very good and usefull. I suggest try to include explain plan for every SQL statement captured. Thanks Banarasi -Original Message-From: Deshpande, Kirti [mailto:[EMAIL

Need some insight views

Title: Need some insight views I wish to hear from those that have experience supporting Oracle databases for Geneva billing systems and Siebel. It will be greatly appreciated if somebody can advise me on any hotspots. Kind Regards, Hatzistavrou Yannis Database Administrator

NOT NULL constraint and long parse time

Hi all, I had a problem with long parse time on one of my queries and want to know if it is a bug or what. Suppose two tables: tab1 and tab2 on my database 9.0.1.3.0. These tables are both empty. Have a look at the column tab1.col1. The NOT NULL constraint on it can be defined in two ways: 1) in

Re: iAS (9.0.2.0.1) R2 install on RedHat 7.2 make

hello Pls check if all necessary libraries have been installed. Check out the rpm's contents for the missing files and install them - unless already done. If so, check the linking options. Got to check the site of www.puschitz.com - hints there are great, even for your probs. I could manage

Ora-1548 while dropping tablespace

Hi all, I have the following problem.

AW: OAUGNet OAUGNet-DBA list servers from OAUG.COM

You should re-register yourself to the lists. I had the same problem, but after re-registering mail delivery is OK. Milen -Ursprüngliche Nachricht- Von: Bob Robert [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 6. Februar 2003 16:45 An: Multiple recipients of list ORACLE-L Betreff:

Skipping a table on import

Hi, I'm trying to import the live schema into a test schema, but 1 or 2 tables have a lot of data and it's taking hours. Is there a way to skip certain tables during an import? We're using 8.1.7 We have 400 tables, so I'd like to avoid having to list all the tables in the export statement. I have

Re: Skipping a table on import

Craig, you can export a owner without a table. See the note : Note:115578.1 How to Export a Database Bypassing a Table in Oracle7 and Oracle8 at metalink. If you don't have access to metalink send a email to me. But don't have any way to import Bypassing a table. I asked it to Oracle Suport at

Re: Disaster Recovery

From: =?iso-8859-1?q?Connor=20McDonald?= [EMAIL PROTECTED] Date: Thu, 6 Feb 2003 23:25:17 + (GMT) Subject: Re: Disaster Recovery You'll want to ensure that any other files that used in conjunction with the database are backed up with their locations well-noted. - listener config files -

RE: Skipping a table on import

Craig, Assuming you don't need the tables that you don't want to import the best option is to not export the tables by using a parameter file. (This speeds up the export, reduces the size of the dmp file, saves the backup/ftp time to copy the file to the target system and saves reading through

RMAN question

Title: RMAN question Hi! How do I make RMAN delete all obsolete backups? We are using a recovery catalog. Example: RMAN report obsolete; RMAN-03022: compiling command: report Report of obsolete backups and copies Type Key Completion Time Filename/Handle

RE: Skipping a table on import

Thanks for the help. But I just checked the note, and it doesn't work for 8i Standard Edition, only Enterprise and Personal. Guess which one we've got? Craig -Original Message- From: Breno A. K. Magnago [mailto:[EMAIL PROTECTED]] Sent: 07 February 2003 10:59 To: Multiple recipients

DB design principles

Hi all, I need gather some principles for good db design. Do you happen to have any or do you good links where I could check some white papers etc... rgds _ Gratis e-mail resten av livet på www.yahoo.se/mail Busenkelt! -- Please see the

RE: Oracle Training

Whatever you choose, I would recommend a program that has evening classes over a 2-4 month period. Ive always been skeptical of 5-10 days all day classes. Too much information too fast. That may not be an option for you if you have other obligations, but its generally the best way to learn when

Retrieving Sets of Record via VB

All, My current application is written in VB accessing the Oracle back-end. I have just been asked about how to execute a query that may return many thousands of rows, but only display, let's say, 1000 at a time. After the first set of rows was returned, the user would click a button and

Re: Skipping a table on import

Craig, I had to smile when you stated you had 400 tables and were reluctant to list them in the export or import parfile. Our 3rd party Student Information system has over 47,000 tables. I frequently do exports and/or imports with parfiles listing several thousand tables. It's not a problem

RE: windows application to show sql being executed by a client

Title: windows application to show sql being executed by a client program BBabu, Like he said, talk directly to the developer ... read the README.eng file. Thanks Jacques for finding this product ... I already like it and am in touch with the author with some issues. Raj

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

Title: RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an Thanks Robert, I wasn't aware of that issue. Plus now that we have all instances on 9202, we hope it won't bite us. As for adding tablespaces dynamically, no chance. We *require* that development team request space

RE: RMAN question

Helmut, This thread came up a couple of days ago The answers were to use the commands change datafilecopy delete or change backuppiece delete Also have a look at the script $ORACLE_HOME/rdbms/demo/rman1.sh to automate the process from the output of report obsolete HTH John -Original

RMAN question

Title: RMAN question Hi! How do I make RMAN delete all obsolete backups? We are using a recovery catalog. Example: RMAN report obsolete; RMAN-03022: compiling command: report Report of obsolete backups and copies Type Key Completion Time Filename/Handle

RE: multiple oracle homes

Ray - the one thing we do is always make sure we don't corrupt the Oracle Inventory files. Whenever we install a new version of Oracle, we copy then delete the current oraInst.loc file (e.g. cp oraInst.loc oraInst_u03.loc), which on our system is located in /var/opt/oracle. We have our Oracle

RE: Skipping a table on import

Jack, I always knew there was a limit on the size of a parfile which I had assumed was a maximum no of tables allowed. However I recently found out that it is a byte limit on the overall file parameter. (It was 8K in 7.x ) Do you not hit this limit with several thousand table names (presumably

Re: Retrieving Sets of Record via VB

So, what's wrong with reference cursors? Why are you looking for anything different? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 07, 2003 7:58 AM All, My current application is

RE: Help with a truncate command in a procedure

Title: Message Thanks for the help! Ron -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 5:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Help with a truncate command in a procedure (pant pant) Will I

Re: multiple oracle homes

On Thu, Feb 06, 2003 at 05:08:55AM -0800, Ray Stell wrote: Where is it well documented how to install multiple server versions, 8i and 9i, on the same unix server? -- Thanks for you replies. I've never tried this before and it seems like there are two different approaches on the surface:

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

Here is a link to IBM site showing a matrix for AIX 4.x support. Fix the link if it wraps around. We had a meeting yesterday to begin upgrading Servers to AIX 5.1 first, for a short duration, and then to 5.2.

RE: Help with a truncate command in a procedure

This is it create or replace PROCEDURE truncate_table(nom_de_table in varchar2) AUTHID DEFINER is total INTEGER ; trouve EXCEPTION ; cursor_name INTEGER ; ret INTEGER ; trun VARCHAR2(30) := 'truncate table ' || nom_de_table ; BEGIN

RE: SQL*Net Connection under-performing

Rajesh , List tnsping for tbasun Database (below) 10 ms whereas tnsping for bby01 Database (below) is 10,000 ms Qs. Is is due to the Multiple ADDRESS Entries with LOAD_BALANCE = yes for tbasun ? NOTE - tnsnames.ora file put on the Database Server itself tnsping also being issued from the

RE: Skipping a table on import

John, A quick check turned up a medium parfile for me - only 1201 tables listed. The file size is 14KB, so I guess it's not an issue for 8i. Even on larger parfiles I've never gotten an error - for neither HP-UX nor Win2k. Jack C. Applewhite Database Administrator Austin Independent School

RE: Skipping a table on import

If it is only 1 or 2 tables, maybe create those tables small and make maxextents = 1? Maybe put them in their own tablespace, then make it read only? Or take it offline? H. -Original Message- Is there a way to skip certain tables during an import? -- Please see the official

RE: Retrieving Sets of Record via VB

Use the ADO Reordset Object PageSize Property to logically divide the Recordset object into a series of pages, Each of which has the number of records equal to PageSize (except for the last page which might have fewer records).

Re: multiple oracle homes

Ray - I have always used #2 and never had a problem. I do set Oracle_Base Oracle_Home to different values for each version. e.g. /oracle1/dbserver/7.3.4 /oracle1/dbserver/8.1.7 /oracle1/appserver/1.0.2 ... hth, Gene P.S. The root directory is different on all my servers to support HA, i.e.

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

Title: RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris and I do my cold backups at a time when the system is not being used. In the future I want to learn RMAN for hot backups but for now I do the following; SHUTDOWN ABORT STARTUP RESTRICT SHUTDOWN IMMEDIATE You mention

RE: Skipping a table on import

Thanks for that. Parfile is what I was looking for. I must have skipped it in the manuals. Cheers Craig -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 07 February 2003 13:04 To: Multiple recipients of list ORACLE-L Subject: Re: Skipping a table on

RE: Retrieving Sets of Record via VB

Ed, thanks for the reference! I'll check into it. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, February 07, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Use the ADO Reordset Object PageSize Property to logically divide the Recordset object

RMAN without all files?

We are conducting a disaster recovery test on RMAN. Files backed up to disk, recovering from disk. We've done this with smaller databases, this is our largest. RMAN reports that it can't find all the data files on disk (70 out of 200). We seem to have all backup pieces. Any ideas? Thanks.

Re[2]: windows application to show sql being executed by a client

Hello Banarasi, I'm Sergey Ten, the one that wrote the tool Jacques is referring to. Thanks for the feedback. I'd also like to see some functionality like that, but Quest Software already has SQLab that does it (means I'd have to compete against my own employer). Besides, my tool does not

RE: Skipping a table on import

Another thought, move the table to a different (new) schema, create synonym and privileges required, then export user=original schema(s), then do your import. Gene [EMAIL PROTECTED] 02/07/03 09:28AM John,A quick check turned up a "medium" parfile for me - only 1201 tableslisted. The file

RE: multiple oracle homes

Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had a bad experience :-) Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 07, 2003 8:24 AM To: Multiple recipients of list ORACLE-L On Thu, Feb 06, 2003 at

Version Controlling in Oracle database - Ideas ?

Looking for a solution to version controlling of database objects in Oracle. The scenario is like this: Multiple people simultaneously work on the same database object in TOAD. How can we implement a version controlling feature. Putting this in simple words, If X checks out a file from

Re: RAC on linux?

This is probably more realistic than many of us realize. Linux and open source in general is seriously threatening MS. PostGreSQL has been around for awhile, but mySql has much more momentum than PGS ever had. I look for it to seriously threaten Oracle in the future. Maybe not at the high

dump.sql

Where can I get then latest version of Jared's legendary script? Or is there a better alternative script for dumping and reloading table data? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services--

Re[2]: RAC on linux?

Jared, You had better bet it is! We're right in the middle of re-designing the back bone of our web site to use Linux/Apache/Tomcat/Java/PostgreSql. Instead of the usual MS Win 2K/IIS/ASP/Oracle. And seriously, Damn this is FUN!! Dick Goulet PS: Teaching an old dog new tricks isn't

help meeeee please - related with c 5.1 in aix

guys, instalation notes on 9ir2 say tht i have to have c 5.1 on this system. do you know here i can get it? or at least how i can install a rpm package in aix? thanks in advance Paulo -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paulo Gomes INET: [EMAIL PROTECTED]

Re[2]: RAC on linux?

Richard, I agree, Oracle is getting way too expensive. Kinda like EMC, a platinum plated truck bed liner where a nice rubber one would work just as well. Dick Goulet Reply Separator Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= [EMAIL PROTECTED] Date:

RE: OT: Hotsos Symposium - Dallas

Having to choose between IOUG and HOTSOS, I opted for IOUG as I haven't been since 2000. So we will get to meet at last! John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

SETGID

List, Has anybody else experienced this problem on UNIX. We have seen this issue on two different servers, one running AIX 4.3.3 and the other running AIX 5.1L. Both have 8i 8.1.7 Ent Edition. My sysadmin set the gid for the directory in which the Oracle datafiles reside. Something to do

Using Soft Links for Datafiles

Resending. Any takers? - Forwarded by Rajesh Rao/JPMCHASE on 02/07/03 11:51 AM - Rajesh

Oracle package that can generate HTML content ???

Hi all, I saw some Oracle packages that can generate HTML content. The package looks like ftpk.c (I don't remember the exact name). Does anyone know what those packages are, and where to find documents? Thanks, Janet __ Do you Yahoo!? Yahoo!

RE: multiple oracle homes

Dennis, What bad experience did you had? I wouldn't recommend it but I had no problem when I run both 32 bit and 64 bit 8.1.7.4 on the same box using that approch. Thanks Richard -Original Message- Sent: Friday, February 07, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Ray

RE: RAC on linux?

Title: RE: RAC on linux? Back when I was in discussions about becoming a beta site for Oracle Financials I visisted Oracle HQ at 20 Davis Drive in Belmont, CA. When asked why we should believe that Oracle was really committed to this new Financials product we were told that Oracle Corp. was

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

Dave Just add one more line before to shutdown abort... alter system checkpoint; SHUTDOWN ABORT STARTUP RESTRICT SHUTDOWN IMMEDIATE Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 07 Feb 2003 07:28:43 -0800 I do my cold

RE: SQL*Net Connection under-performing

Vivek, I am wondering why do you have load balancing turned on for BBY01, when you have just one listener? Whats the MTS_DISPATCHER set to? Raj

RE: RAC on linux?

Title: RE: RAC on linux? Anyone have ideas on this? http://story.news.yahoo.com/news?tmpl=story=/cmp/20030206/tc_cmp/iwk20030206s0012 Sun is now going after the intel market too. Is this just a new version of their Solaris x86, or a completely new build? -Original Message- From:

Re: NOT NULL constraint and long parse time

I've tried your test case on 9.2.0.2 but it didn't reproduce. Should there any data in the tables ? How did you determine that the time was spent on the parse - and could you tell us your CPU speed and the times involved. Also, was there ultimately any difference in the execution plan ?

RE: Version Controlling in Oracle database - Ideas ?

Title: RE: Version Controlling in Oracle database - Ideas ? I believe this feature coming in new TOAD ... its available in Beta though ... I think it is called 'Team Coding ... something' Another product is Oracle SCM ... Raj __ Rajendra

Re: windows application to show sql being executed by a client

Title: windows application to show sql being executed by a client program how can I do it for unix processes ? ... Bp - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Friday, February 07, 2003 5:09 AM Subject: RE:

RE: dump.sql

Try this link. http://www.cybcon.com/~jkstill/util/ Dave -Original Message- Sent: Friday, February 07, 2003 10:34 AM To: Multiple recipients of list ORACLE-L Where can I get then latest version of Jared's legendary script? Or is there a better alternative script for dumping and

Re: Re[2]: RAC on linux?

Quoting [EMAIL PROTECTED]: Jared, You had better bet it is! We're right in the middle of re-designing the back bone of our web site to use Linux/Apache/Tomcat/Java/PostgreSql. Instead of the usual MS Win 2K/IIS/ASP/Oracle. And seriously, Damn this is FUN!! I am doing this as

RE: windows application to show sql being executed by a client

Lindows?? -Original Message- how can I do it for unix processes ? ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--

RE: SAN, Heterogenous environments, Backups

Hemant, Could you check what happens if all the filesystems that were 'shadow copied' were VxFS filesystems? I would assume that Veritas maintains the same formats across *nix versions Btw, I haven't implemented Heterogenous implementations on a SAN, but am just suggesting an alternate... Let

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

got it Thanks, Dave -Original Message- Sent: Friday, February 07, 2003 11:30 AM To: Multiple recipients of list ORACLE-L an Dave Just add one more line before to shutdown abort... alter system checkpoint; SHUTDOWN ABORT STARTUP RESTRICT SHUTDOWN IMMEDIATE Regards Rafiq

RE: RAC on linux?

I first installed Solaris 2.5 on Intel (AMD actually) on a 386/40 with 8Mb RAM. It ran fine. Sun pretty well shot its Intel market the same way IBM blew its OS2 market: Overpriced the crap out of the OS and development tools. By the time they woke up and noticed that the market had moved on to

RE: multiple oracle homes

I agree with Dennis. We tried this several years ago and decided it was best to stick with one username. I forget what the exact issues were - it might have been file privileges when you are upgrading a database. Jay [EMAIL PROTECTED] 02/07/03 10:54AM Ray - My 2 cents worth. Don't ever use

RE: SETGID

Title: RE: SETGID what are the permissions on the oracle binary in $ORACLE_HOME/bin... make sure it reads -rwsr-s--x -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Subject:

Re: multiple oracle homes

On Fri, Feb 07, 2003 at 07:54:24AM -0800, DENNIS WILLIAMS wrote: Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had a bad experience :-) Would you mind expanding on that, other people say the multiple userid idea works for them. They may be surprised one day, I can

RE: Oracle package that can generate HTML content ???

Title: RE: Oracle package that can generate HTML content ??? package of procedure ... htp package of functions htf Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal

Re: RMAN without all files?

Title: RE: RMAN without all files? -:) Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Orr, Steve To: Multiple recipients of list ORACLE-L Sent: Friday, February 07, 2003 11:48 AM Subject: RE: RMAN without all files? The below message

RE: RAC on linux?

Sun in fact want to discontinue the Solaris for Intel platform a year ago but receive a lot of critisim from the user community. So they revived it. -Original Message- Sent: Friday, February 07, 2003 1:49 PM To: Multiple recipients of list ORACLE-L I first installed Solaris 2.5 on

Re: Re[2]: windows application to show sql being executed by a client

Sergey, Does your utility monitor connections through ODBC interface(not OCI or OO4O)? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 07, 2003 11:09 AM Hello Banarasi, I'm Sergey Ten,

RE: multiple oracle homes

Richard - It was more like Jay mentioned. Just problems with file permissions. It just always seem to be biting me at every turn. I finally got everything over to the Oracle username. The other issue is that my guess is that the Oracle developers test everything with the Oracle username. So if you

Re: Skipping a table on import

how about giving where clause for the export of that table with where 1=2, This way u will not have any records in export file . Bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 07, 2003 3:18 AM Craig, Assuming you don't need

RE: RAC on linux?

Title: RE: RAC on linux? Sun has always been shipping Solaris for Intel, I started with 2.5. Thenthey want to kill it a year ago, but the user community raised hell with them, so after a brief stop, they are shipping it again for Solaris 9. Don't know if Oracle is goingsupport it again. I

RE: multiple oracle homes

I tend to agree also, just because of confusion. We are running on one server, 817 (1 instance), 9201 (1 instance), 9iASRel 2 (1 instance) and on the second server we have 817 (2 instances), 9201 (1 instance), 9iAS Ver 102 (1 instance). So at first we tried different user names: oracle8i (817

RE: Using Soft Links for Datafiles

Title: RE: Using Soft Links for Datafiles Raj- We used the symbolic links on a regular basis in a previous life.. But we did not have the opportunity to use RMAN, so I am not able to address that right now. But when we lost sym links; we actually had to restore and recover. And that's why we

RE: Trolling for ideas

Gene - I asked the network engineer about this. No reported outages. Extremely few errors in his log. We've recreated the problem during the day. Thanks for the ideas, however. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February

Re: Partition and primary key

Philippe If you are using parallel clause in index creation/rebuilding you need more space in target tablespace as well as temp tablespace. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 07 Feb 2003 08:09:25 -0800 You

Re: multiple oracle homes

On Fri, Feb 07, 2003 at 11:36:36AM -0800, Scott Stefick wrote: I tend to agree also, just because of confusion. We are running on one server, 817 (1 instance), 9201 (1 instance), 9iASRel 2 (1 instance) and on the second server we have 817 (2 instances), 9201 (1 instance), 9iAS Ver 102 (1

RE: RAC on linux?

But ROacle hasn't. 8.1.7 is the terminal release on Slowaris. -Original Message- From: Richard Ji [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 2:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: RAC on linux? Sun in fact want to discontinue the Solaris

RE: multiple oracle homes

Maybe, but Ray will decide what's best for him. I think we have offered enough points for him to consider. File permission is a big headache. In my case, I have two totally separate environment since one is 32 bit, on is 64 bit. Regards Richard Ji -Original Message- Sent: Friday,

Re: multiple oracle homes

maybe multi-user oracle homes would be a problem for stuff that's in oracle base such as the inventory. during an install/upgrade this common data needs to be updated. i suppose i would work ok if u were careful with permissions, but it would be just one more thing to go wrong. thanks, steve

sql question -- distinct, group by and order by

Hi: I have a basic sql question about sql. I have the follwing four sqls and I am wondering why #3 costs less than #4 in explain plan. #1 and #2 cost the same. How is distinctand group by treated internally by Oracle? Is #3 a better optimized sql than #4? TIA. Guang Mei 1. select

Re: multiple oracle homes

That is why each oracle home has its own oraInventory directory. I have 10 different instances across 2 machines. Each instance has its own user id and group. There have been no problems at all with this setup for 8.1.7.4 and 9.2.0 Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of

Re: sql question -- distinct, group by and order by

Guang Mei wrote: Hi: I have a basic sql question about sql. I have the follwing four sqls and I am wondering why #3 costs less than #4 in explain plan. #1 and #2 cost the same. How is distinctand group by treated internally by Oracle? Is #3 a better optimized sql than #4? TIA.

Re: multiple oracle homes

Solution would be different users but all having the same group. I always use a oinstall group for all oracle users in a system. I have Oracle 8 and 9 on the same Sun. Quoting Stephen Evans [EMAIL PROTECTED]: maybe multi-user oracle homes would be a problem for stuff that's in oracle base

Re: Oracle 9i Lite - any help please?

Saira, Excellent feedback. I'll forward it to Jacob Christfort and Martin Graf. Martin, by the way, sent me a response to your posting (Jacob forwarded my message to Martin). See below. Best regards, Mogens Mogens, In deed, Oracle9i Lite has over 10'000 posted messages on OTN,

RE: RMAN - questions.. Rob Freeman?

Resending, just wondering if there any Shark FlashCopy users out there. So far, it doesn't look good. Gene [EMAIL PROTECTED] 02/06/03 05:03PM Excellent thread on VLDB and backups. I know EMC BCVs/Timefinder works for quick disk backups from experience. However, EMC is not an option, we are

Re: RAC on linux?

I heard an Oracle product manager (whose product also got rolled into iAS - or I Am Sorry, as it's known here) mention that Larry had been quoted as saying "Well, everybody has a database now" - meaning: Now Oracle has to sell iAS, Apps, anything other than the database, so that kind of

Re: What is minimum privs to have user do hot backups

Here's what I've used: create session select_catalog_role alter database alter tablespace alter system [EMAIL PROTECTED] wrote: Hi All, If I create a backup user, what is the minimum requirements to connect as that user and do hot backups? Thanks Rick -- Please see the official

RE: multiple oracle homes

Ray - Perhaps you misunderstood. You won't find anything in the documentation saying our developers didn't have time to test every installation permutation against alternate userids. I used to be a developer at a software vendor. I know how the developers think. You don't like to test. You take

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

Hi Robert, For problem 1, you mean transaction recovery, i.e. rollback, right? Did this problem happen only with fast start parallel rollback or also with normal version 7-on background TX rollback? How about user rollbacks (user 1 rolls back large transaction, user 2 truncates the table in the

RE: RMAN - questions.. Rob Freeman?

enter theme from Jaws No shark flash-copy usage here I think your going to need a bigger boat! Cheers! Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 2/7/2003 3:23 PM Resending, just wondering if there any Shark FlashCopy users out there. So far, it

Client Distribution

Hello All, We have been exploring different options to distribute the Oracle client to users to deploy an application. Earlier, we used to use Install Anywhere or do it manually. I am thinking there should be a better way folks out there must be using. Our present requirement is to have a

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

Just to add another aspect: I had a problem once with a 7.3.4 database when we performed a shutdown abort. Now this database was in the middle of a complete refresh of a rather large Table from another database. The shutdown abort occurred properly, but the db took its sweet time to come up while

Re: dump.sql

It may be found at www.cybcon.com/~jkstill It may also be found at: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=1050919.6 Yes, it's back, still without credit. Please, no 'piracy' emails to Oracle about it. Jared John Dunn [EMAIL PROTECTED]

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris an

John, In 7.3.4, wasn't background TX recovery already a feature? In other words, weren't large rollbacks delayed until after the database was already open and available? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 7 Feb 2003, John Kanagaraj wrote: Just to add another aspect:

ORA-04031 error

Hi List, whats the meaning of the following error ERROR at line 1: ORA-04031: unable to allocate 4096 bytes of shared memory (large pool,unknown object,sort subheap,sort key) heres the sql query ---select * from hox12 order by op desc; Oracle Release --8.1.6.1.0 OS -- RH 7.1 sort_area_size-- 2MB

RE: Freeware reverse engineer ER diagram from ODBC connection

Hi Lindon, You can try this link, http://www.logicworks.com/ -Original Message- From: Lyndon Tiu [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 12:34 AM To: Multiple recipients of list ORACLE-L Subject: Freeware reverse engineer ER diagram from ODBC connection

RE: re SHUTDOWN ABORT -- was RE: Debate on rc commands Solaris

You do seem to have tested out different Shutdown or SHUTDOWN ABORT scenarios ! The TRUNCATE table issue does seem to be serious. However, the INSERT should have been rolled-back at the next STARTUP --- unless you had a problem because you issued the TRUNCATE before the ROLLBACK was completed ?

  1   2   >