Re: CBO not using the index even though it is faster when hinted ....

Are any of the columns in the index declared to be NOT NULL - if not, then the hint is invalid because obeying it could produce the wrong answer. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see

Informix Emigration

Hi List , Can Please some one list the steps and the commands ,even in breif, to extract files from informix database running on linux into flat files , I know nothing about informix and linux. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walid

EMC EDM backup utility and 9i

Title: EMC EDM backup utility and 9i Hi! Is anybody out there using EMC's EDM backup utility to back up their Oracle databases? We're running into problems when trying to back up 9i. 8i works fine. Thanks, Helmut

Error extensions in the alrtXXX.log

Title: Error extensions in the alrtXXX.log Hello List, Pls help, I am busy playing with a Perl script which I want to read through the error log file each day and mail me when an error has occurred. I have already created the part that will be backing up the alrtXXX.log to another file. So

RE: changing Home directory?

Do you install your form 5 in the same directory with oracle 9i ? If 'yes' your registry in your OS is already changes, that's why you can't start your 9i. Perhaps it is a bad idea if you reinstall your 9i (but check whether there is a facility to repair your oracle 9i on its cd) or you

Server Shutdown

Sorry I forgot to mention oracle version etc on the first copy of this email. Hi, Can anyone point me to any web sites that have information on the following two issues 1. Running oracle forms on the oracle server Our customer wants to take away our access to the client machines and they

Re: Slow database, too MANY buffers???

Correct. Hot blocks (the most intensively used blocks) are always likely to leave chains of CR copies, or have CR copies built, but the number 6 will often show up as a fairly strict limit. The code tries to limit the number of CR block to 6 (according to a parameter with a name something like

RE: Error extensions in the alrtXXX.log

Title: Error extensions in the alrtXXX.log I think the only erros which can exists in alert.og are ORA- -Original Message-From: ext Denham Eva [mailto:[EMAIL PROTECTED]]Sent: 24 January, 2003 11:04To: Multiple recipients of list ORACLE-LSubject: Error extensions in the alrtXXX.log

RE: BMC's Patrol

From: KENNETH JANUSZ [EMAIL PROTECTED] Date: Thu, 23 Jan 2003 13:42:39 -0600 Subject: BMC's Patrol Is anyone using BMC's Patrol tool on their Oracle DB? If so, what do = you like / dislike about it? Any problem areas? Customer support from = BMC? FWIW, the local BMC folks here wanted to

RE: over-normalized?

From: Saira Somani [EMAIL PROTECTED] Date: Thu, 23 Jan 2003 10:59:33 -0500 Subject: over-normalized? Is there such thing as an over-normalized database design? What defines over-normalization? And what are its consequences? (Other than the obvious degraded database performance and lots of

RE: over-normalized?

I worked on a project a few jobs back where the data modelers really tried for fully normalized tables. When the address table ended up as 5 (or was it 6?) different tables, because address was defined as email or US snail mail or other country snail mail or office building (with the associated

RE: Error extensions in the alrtXXX.log

From: Denham Eva [EMAIL PROTECTED] Date: Fri, 24 Jan 2003 11:03:47 +0200 Subject: Error extensions in the alrtXXX.log Hello List, Pls help, I am busy playing with a Perl script which I want to read through the error log file each day and mail me when an error has occurred. I have already

RE: Tricky query question

Mark, You're on the right track thinking of the analytic functions (8.1.6 and above), which among many things provide the ability to compare between rows without having to do a self-join or multiple passes. Take a look at the lag and lead functions. Here's and example, making a single pass (plus

users identified by external

It used to be (Oracle 8.0.5 think) that if you created a user identified by external (i.e.) via the OS then the user name begain with OPS$. and had to be referenced as such This does not seem to be the case in 81.1.7 on AIX. When did this change? John Dunn Sefas Innovation Ltd 0117 9154267

RE: over-normalized?

Funny... I aruged against tables called international_phone, us_phone, international_address, us_address, primary_email, secondary_email... My director told me I couldn't kill her... just mess her up real good. =) April -Original Message- To: Multiple recipients of list ORACLE-L

RE: users identified by external

It used to be (Oracle 8.0.5 think) that if you created a user identified by external (i.e.) via the OS then the user name begain with OPS$. and had to be referenced as such This does not seem to be the case in 81.1.7 on AIX. When did this change? John Dunn Sefas Innovation Ltd 0117 9154267

Re: EMC EDM backup utility and 9i

Title: EMC EDM backup utility and 9i Hi, Helmut I worked whith backup's using EDM and ORACLE 8i but 9i no yet what's problems do you've? Adriano - Original Message - From: Daiminger, Helmut To: Multiple recipients of list ORACLE-L Sent: Friday, January 24, 2003

tim column in trace output

Anybody knows what is the reference point for the timing used in the tim column in the trace output, like in: PARSE #3:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=832261739 EXEC #3:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=832261739 Apparently the scale is 100 per second for 8i and

RE: CBO not using the index even though it is faster when hinted ....

Oh heck, of course! Why didn't I think of that? BAHH! Gotta quick staying up so bloody late! RF -Original Message- Lewis Sent: Friday, January 24, 2003 2:49 AM To: Multiple recipients of list ORACLE-L hinted Are any of the columns in the index declared to be NOT NULL - if not,

RE: Sort (Collating Sequence)

Title: Sort (Collating Sequence) Laura, The way that I have always handled this was to create another column in the table, and populate it with a before insert/update trigger. In your case, I would create a VENDOR_SORT column and move the vendor_name column into this column. I have

RE: Error extensions in the alrtXXX.log

Title: Error extensions in the alrtXXX.log Look in the Oracle Errors Manual, it will give you a list of all the prefixes for the different kinds of errors. RF -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Denham EvaSent: Friday, January 24,

RE: BMC's Patrol

Ken, We have BMC Patrol in use for quite some time now. I used to like it when I installed it about 4 years ago. Presently a co-worker is in charge. And we are pondering if we want to continue to use it. The first problem I ran into was that BMC was a bit late in supporting new features

Re: Parallel query on partitioned table gives inconsisitent

A sample query which returns different amounts and count is the following. select adjctn_date, cycle_nbr_code, sum(reimd_amt) totalamt, sum(fed_ffp_amt) fedamt, count(distinct(rcpt_id)) rcnt, count(1) from TEST group by adjctn_date, cycle_nbr_code order

OEM 4

Title: RE: Program name in v$ views Oracle just posted an item, they announced the next version of the OEM. http://196.30.226.221/sections/enterprise/2003/0301240730.asp?A=TESS=Software%20TestingT=SectionO=FPSH I checked on OTN, nothing is available for download there. Patrice Boivin

Re: Program name in v$ views

There are a number of reasons for this: 1) The oracle developers call a function that sets the program name. SQLPlus does that. 2) If the program name is not set, the client libraries will try to find the name as part of the logon call. For this a port specific function will be used. If that

RE: CBO not using the index even though it is faster when hinted

Title: RE: CBO not using the index even though it is faster when hinted How about a where clause for your query ?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal

RE: tim column in trace output

Djordje, It's hsecs from v$timer, this is what the 'db reference' says: V$TIMER This view lists the elapsed time in hundredths of seconds. Time is measured since the beginning of the epoch, which is operating system specific, and wraps around to 0 again whenever the value overflows four bytes

RE: Statspack recomendations.

I get the error on solaris 9 and 9.2.0.2 except it's 103 Connected.ERROR:ORA-00600: internal error code, arguments: [ktfthcf-1], [103], [], [], [], [], [], [] [EMAIL PROTECTED] 01/23/03 04:16PM BUT, I don't get the error on 9.0.1.0.0 on Solaris 5.8!-Original Message-Sent: Thursday,

Re: Dictionary location or initSID.ora and PWDsid.ora

D'oh! I forgot about those. Getting them out of the registry is another problem. Do you know Perl? Use Win32::TieRegistry. Jared On Thursday 23 January 2003 21:43, Naveen Nahata wrote: There are avaialable in the registry with String values 'ORA_SID_PFILE' and 'ORA_SID_PWFILE' From

RE: Statspack recomendations.

I also get it on 9.2.0.1 on Win2K, same error code as Robert: Connected to:Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Production SQL select a.file_name 2 from dba_temp_files a, v$tempstat

Re: Slow database, too MANY buffers???

On Friday 24 January 2003 02:23, Jonathan Lewis wrote: I wouldn't necessarily be concerned, for example, by Jared's example of a single block being at 66 copies and all the rest at 6. I've earned the right to be picky with this particular application. :) Jared -- Please see the official

DDLs -- was Re: simple question on DDL

Take your first example : insert into t1 values (1); drop table t1; -- how to deal with self-deadlock ? insert into t1 values (2); commit; Why does Oracle HAVE to commit when the DROP TABLE is issued ? What if the INSERT had been issued by another session ? Would the DROP TABLE go through

RE: over-normalized?

Title: RE: over-normalized? Like one column per table?? I'd like to name this phenomenon as Fanatic Form Of Normalization Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is

Re: over-normalized?

Of course, you can get carried away and call something normalized that has gone far beyond the requirements for normalization. Jared On Friday 24 January 2003 03:43, April Wells wrote: Funny... I aruged against tables called international_phone, us_phone, international_address, us_address,

RE: Statspack recomendations.

I found a bug in Metalink for this. It's fixed in 10i. See my previous message (and one from Jared) for a work around. RF Robert G. FreemanTechnical Management ConsultantTUSC - The Oracle Experts www.tusc.com904.708.5076 Cell (it's everywhere that I am!)Author of several books you can

RE: tim column in trace output

Djordje, 1. You're right; in Oracle8, tim is measured in centiseconds (0.01s). 2. The value is the same as that found in v$timer.hsecs. 3. We're not sure whether the Epoch for this clock is even meaningful or not (I don't think we've been able to prove that the value resets when you do an

RE: OEM 4

Why isn't this press release on Oracle's sites? I also wonder why there's no info (even a lame Contact your salespersons) on how to actually obtain the product. The Manager-2-Go feature sounds useful. I wonder... Rich Rich Jesse System/Database Administrator [EMAIL

RE: JSP Runtime.getRuntime().exec and no secondary groups on Unix

OK, some clarification here: I use JSP for Java Stored Procedure and NOT Java Server Pages. Also, a co-worker suggested running the groups command to verify what groups are available to the process. That confirmed that the secondary group is indeed NOT active in the Java Stored Procedure call.

RE: Another simple question

Banarasi - Worse than that, Oracle used to recommend that you use no more than 4 characters (look at your process names, and imagine if your O.S. only allowed 8 characters for the name). The problem is that some, mostly older, computer systems have severe filesystem and process name limitations. I

Re: Slow database, too MANY buffers???

We'll I don't want to show my ignorance but I'll never learn if I don't ask. How do you get from DBABLK to PK_MATERIAL_ORDER_POOL?

RE: Dictionary location or initSID.ora and PWDsid.ora

I think it would just be best to follow the OFA standard and backup the everything under $ORACLE_BASE occasionally. If your sysadm runs incrementals on the server any changes to the init file should always be backed up. Changes should also be documented in some other change log/request etc..If

Re:RE: Another simple question

Dennis, Allow me to add another item to the pile from the OLD days. Back in SQL*Net V1 it was recommended to select a database name/SID that was case insensitive. That restriction/recommendation was due to older DOS based clients that handled all of that sort of data as upper case.

RE: Dictionary location or initSID.ora and PWDsid.ora

At least I remebered one thing which Jared forgot!!! :-) Regards Naveen -Original Message- Sent: Friday, January 24, 2003 9:05 PM To: Multiple recipients of list ORACLE-L D'oh! I forgot about those. Getting them out of the registry is another problem. Do you know Perl? Use

RE: over-normalized?

If done properly, this would require two columns. One for the data and one for the PK. This is on parent tables only. Children would of course require FK columnns. :) Jared Jamadagni, Rajendra [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/24/2003 07:54 AM Please respond to ORACLE-L

Re: Slow database, too MANY buffers???

I just use this script that I originally used for finding which object corrupt blocks are in. Serves well for this as well. Note that file_id is the incorrect column to use on a database with 1022 data files. I think you need to use relative_fno in that case. Jared -- ora_1578.sql -- use

RE: DDLs -- was Re: simple question on DDL

Hemant, My guess is that Oracle, at some point in time long ago, decided that DDL's and DML's should not be mixed together. Because they could not (or did not want to) deal with the issue, they decided to perform an implicit commit before any DDL statement was issued. Case closed. This is the

Re:OEM 4

Sounds pretty interesting, IF your in a completely Oracle environment! On the other hand if you don't have 9IAS you may be out in the cold. Dick Goulet Reply Separator Author: Boivin; Patrice J [EMAIL PROTECTED] Date: 1/24/2003 5:11 AM Oracle just

RE: OEM 4

I run this URL now and again, that's how I found the article: http://www.newsnow.co.uk/newsfeed/?search=Oracle Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques

unix time conversion function

Title: unix time conversion function Anybody got a handy little function to convert a standard unix seconds-since-Jan-1970 epoch time (stored as a number) to a readable date? It would save me a lot of time not having to re-invent the wheel. Matt Matt Adams - GE Appliances -

Re: Slow database, too MANY buffers???

So this is what you're looking for? col segment_name format a30 col segment_type format a10 select segment_name, segment_type, count(*) from dba_extents, x$bh where file_id = file# and dbablk between block_id and block_id + blocks - 1 group by segment_name, segment_type HAVING count(*) 5

SQL Tuning

Hi List, Is anybody have any idea for better performance for the following query: I just change the OR to UNION ALL Appreciate any idea. SELECT a.evh_event_id FROM event_history_evh a WHERE (a.evh_event_id = 2 AND a.evh_created_date = (SELECT max(

RE: unix time conversion function

Title: RE: unix time conversion function Nevermind, Once I thought about it for more than 30 seconds, I got it. TO_DATE('01/01/1970','MM/DD/') + SECONDS / 86400 easy as 3.141592654 Matt Adams - GE Appliances - [EMAIL PROTECTED] My computer beat me at chess, but I won when

RE: OEM 4

And they have an Instant PHB feature, too. -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Friday, January 24, 2003 11:34 AM To: Multiple recipients of list ORACLE-L Subject: RE: OEM 4 Why isn't this press release on Oracle's sites? I also wonder why

auto backup and spfile restore

Title: auto backup and spfile restore List, We are in the process of testing every recovery scenario we can think of using rman. We don't use a catalog and controlfile autobackup is on which implies the spfile is automatically backed up. So one of the scenarios was to delete the spfile and

Friday Reading ... All About SQL and RDBMS

Title: Friday Reading ... All About SQL and RDBMS If you have time this is a good reading all about SQL ... http://www.mcjones.org/System_R/SQL_Reunion_95/ Please delete immediately, if you have already read this one ... I think this is a keeper. Raj

Check list - never mind...

Title: Check list - never mind... I found it in the archives of the list on the website. Sorry... Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063

ORA-4062 is driving me crazy !!

Title: ORA-4062 is driving me crazy !! Hi all, One of our developer has a package (lots of TYPEs, pl/sql table declarations, overloaded function etc). This is being called from Forms [32 Bit] Version 6.0.8.20.1 (Production) Oracle Toolkit Version 6.0.8.19.1 (Production) PL/SQL Version

RE: DDLs -- was Re: simple question on DDL

Tom - I think you've nailed it. Think of the design decisions that some of Oracle's competitors made in the early days and how silly they seem in retrospect. Anyone remember the row-locking vs. block-locking wars? The other aspect that many people don't think of if they have never worked in

RE: DDLs -- was Re: simple question on DDL

I think DDL and DML are two different things and should not be mixed together. If they are mixed together, then developers need to learn how it works and deal with it. And there you have it. If you need DDL in your code, isolate it in an anonymous transaction, or just be sure that you are

Checklist - Ken Janusz??

Title: Checklist - Ken Janusz?? Hello everyone, I saw a check list posted to the list a couple of days ago. Well, wouldn't you know it - Hours ago I inherited an Oracle/Peoplesoft/AIX environment and I need that check list because I am talking to the previous DBA in just a couple of

RE: CBO not using the index even though it is faster when hinted

All the columns in the table are not null ... here is an interesting test I ran ... several Direct_Path_Write and Read waits with large elasped times are showing up in the 10046 trace data on this query due to the full table scan. Just deleted statistics on this and fwiw ... With Statistics

RE: unix time conversion function

Title: unix time conversion function Kinda...you can change the year to 1970 if you want, this also converts to minutes, not seconds. It is a really ugly function but it seems to work. You could always use perl. function f_minutes { # Funky function I use to calculate the number of minutes

Re: CBO not using the index even though it is faster when hinted

Well, if it can do it under rule-based, then it shouldn't be able to ignore the hint under CBO - I don't suppose there's any chance that you have a typo in the hint ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see

Producing .mdb output from sqlplus or SQL or PL/SQL

I am wondering if it is possible to produce .mdb or .xls format files from inside Oracle. Can this be done? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics

RE: JSP Runtime.getRuntime().exec and no secondary groups on Unix

As no one seems to care, I guess I'll have to answer my own question. Methinks the problem was that the svrmgrl process I used to bounce the instance after the change to /etc/group was holding on to the old group memberships. So, by simply exiting svrmgrl between the shutdown and startup of the

RE: Producing .mdb output from sqlplus or SQL or PL/SQL

Title: RE: Producing .mdb output from sqlplus or SQL or PL/SQL .xls is possible ... using owa_sylk package ... (check asktom.oracle.com for more info). no clue what .mdb is ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot

Re: SQL Tuning

Hamid Alavi wrote: Hi List, Is anybody have any idea for better performance for the following query: I just change the OR to UNION ALL Appreciate any idea. SELECT a.evh_event_id FROM event_history_evh a WHERE (a.evh_event_id = 2 AND

RE: Producing .mdb output from sqlplus or SQL or PL/SQL

Patrice: I have used the data extract function in EXCEL to select data from views and tables in my database using an ODBC connection. I imagine you could do the same thing from within ACCESS as well. You run the query and it populates the spreadsheet which can then be saved. Rick Weiss Oracle

Re: Producing .mdb output from sqlplus or SQL or PL/SQL

Patrice, I don't think it is possible to do this directly, but if you spool carefully, you could have it in a format that is automatically read when you open Excel. Or it is a simple operation in Access to import text data and you could build a macro to handle that easily. Good luck Stephen

RE: CBO not using the index even though it is faster when hinted

Yes ... I can force the hint, but why wont it take the RBO path ?Its a difference of 7 seconds versus a split second. So why would the CBO take that path ? -Original Message- Sent: Friday, January 24, 2003 1:14 PM To: Multiple recipients of list ORACLE-L hinted Well, if it can

Re: Slow database, too MANY buffers???

Yes, the only problem is that doing a join with the dba_extents query makes this run rather long. Jared Thomas Day [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/24/2003 10:39 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: unix time conversion function

Title: unix time conversion function At the risk of stating the obvious, doing it in Perl looks like this: #!/usr/bin/perl use Date::Format qw(time2str); my $t = 1043447100; # for example print time2str(%T %A %d %B %Y, $t), \n; Cary Millsap Hotsos Enterprises, Ltd.

Re: BMC's Patrol

that's because it's so user unfriendly it requires professional services to install/configure it... as far as charging for the consultants time, they usually charge for small deals and it's free for big ones. I'm sure CA and others are the same. my 2¢ - Original Message - To: Multiple

RE: Tricky query question

This works : create table test_event ( mypk number , mystatus char , mydate date)); insert into test_event values ( 1 , 'A', to_date('01/01/2001','mm/dd/')); insert into test_event values ( 1 , 'A', to_date('01/02/2001','mm/dd/')); insert into test_event values ( 1 , 'B',

RE: Producing .mdb output from sqlplus or SQL or PL/SQL

Title: RE: Producing .mdb output from sqlplus or SQL or PL/SQL .mdb files are Microsoft Access database files. Best best is import the data from the database into Access using ODBC connection or to create a flat file. Access can work directly with the flat file (hey Access has been doing

Perl Breakdown

This will make Jared happy, I finally broke down and fumbled my way through some perl. function f_file_date { { print #!/usr/bin/perl print print scalar(localtime((stat(\${1}\))[9])) } tmp.pl perl tmp.pl rm tmp.pl } This little diddy can be placed right in my .ksh script to

RE: CBO not using the index even though it is faster when hinted

Mike, several Direct_Path_Write and Read waits with large elasped times are showing up in the 10046 trace data on this query due to the full table scan. This is not to distract you from the original problem, but Direct Path Reads/Writes is I/O that bypass the Db block buffers to read directly

Re: CBO not using the index even though it is faster when hinted

What were the logical reads query + current during this same test. Physical reads could be different because the first query loaded the rows into memory. John [EMAIL PROTECTED] wrote: All the columns in the table are not null ... here is an interesting test I ran ... several

RE: unix time conversion function

Title: unix time conversion function Yes I knew it was easier in perl, I prefer to distribute a single script whenever possible and I write pretty much everything in shell. However, I just figured out a trick to put the perl directlyin my .ksh scripts (see the post I posted a few minutes

RE: CBO not using the index even though it is faster when hinted

John This is not to distract you from the original problem, but Direct Path Reads/Writes is I/O that bypass the Db block buffers to read directly into PGA, and is typical of sort I/O and PQ (among many other reasons). Thanks on this See note I sent just before this on what I did.

CBO not using the index ... Here is what I did

fwiw, The CBO is not choosing the fastest path for whatever reason on this query. When you run the various explain plans with timing on using the hints versus without the hint, it is clear which way is the faster way, but its not going that way using the CBO with a straight query. I turned the

RE: CBO not using the index even though it is faster when hinted

Lower the settings for optimizer_index_cost_adj. set optimizer_index_cost_adj to value that is less than (cost without hint / cost with hint). This should help. Regards, Waleed -Original Message- Sent: Friday, January 24, 2003 3:39 PM To: Multiple recipients of list ORACLE-L hinted

Re: Perl Breakdown

Nice effort! You could try: function f_file_date { perl -e 'print scalar(localtime((stat($ARGV[0]))[9])) ' $1 } Jared Post, Ethan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/24/2003 03:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L

RE: Tricky query question

No offense Waleed, but the solution Larry suggested is quite a bit easier to take. :) SQL l 1 select primarykey, 2 status, 3 dateinserted, 4 LAG(status,1) OVER (PARTITION BY primarykey 5 ORDER BY dateinserted) prior_status 6* from

Configuring back up in Oracle 9i

Hi listers, Can anyone in this list explain to me, how to back up my database ? I use Oracle 9i and I run back up via Oracle Management Console as SYS user and already setting its previlleges but after I follow all instructions in back up wizard, final result raise 'Authentication Error'. Pls

RMAN

I am trying to create an instance on Oracle 8.1.7.4.0 (Solaris 5.8). I am trying to run RMAN to back it up, but the RMAN instance is still at 8.1.7.0.0. I am getting a bunch of errors. Is it possible to run RMAN in this scenario, or does the RMAN instance need to be upgraded. I'd check

RE: auto backup and spfile restore

Title: auto backup and spfile restore My guess is that there is a path defined in your init.ora that isn't correct. Check your alert log for more information. RF -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chris StephensSent: Friday,

RE: DDLs -- was Re: simple question on DDL

Agreed. There's a lot of code out there that was developed considering the way Oracle handled DDL and DML specifically. Although I would have liked Oracle to handle DDL as an Autonomous Transaction and provide an error message for the scenario in the first example, I guess it might be too late

Re: RE: RE: Upgrade from 7.3.4 to 8.0.6

Thanks for your reply. Now I know whom to contact..for upgrades :) Cyril On Thu, 23 Jan 2003 Bowes, Chris wrote : A valid question. With a pseudo-valid answer, which is: Because there is no 8i for hp-ux 10.20. We have been asking for upgrades and all for the last 4+ years and the

RE: Tricky query question

How could you say that ? ): No offense at all, I saw Larry post. I liked to be able to do it without using the analytic functions (Oracle 7.0 for example). Also was wondering about a way to define data buckets using basic relational methods. Regards, Waleed -Original Message- Sent:

RE: auto backup and spfile restore

Title: auto backup and spfile restore Another thought is that if you are starting your database without any init.ora at all (which is very possible), then you may need to create file systems for the default file locations such as user_dump_dest, etc... RF -Original Message-From: