SQL query without UNION clause

Hi all, How do I forumlate the below query without using the UNION clause? SELECT H1.OID HISTORIEOID,FAHRZEUG.AMTLICHESKENNZEICHEN, FAHRZEUG.OID, H1.PRODUKT,H1.AUFTRAGSPOSITIONSNR,H1.MYTECHOBJEKT FROM FAHRZEUG,HISTORIE H1 WHERE FAHRZEUG.OID = H1.MYTECHOBJEKT(+) AND

RE: SQL query without UNION clause

You would be surprised to discover what you could do with OR and suitably placed parentheses. - Original Message - From: Krishnaswamy, Ranganath [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 18 Dec 2002 23:53:44 Hi all, How do I forumlate the

RE: SQL query without UNION clause

Try this, SELECT DISTINCT H1.OID HISTORIEOID,FAHRZEUG.AMTLICHESKENNZEICHEN, FAHRZEUG.OID, H1.PRODUKT,H1.AUFTRAGSPOSITIONSNR,H1.MYTECHOBJEKT FROM FAHRZEUG,HISTORIE H1 WHERE FAHRZEUG.OID = H1.MYTECHOBJEKT(+) AND ((TO_DATE(H1.DATUMSTR,'-MM-DD') = (select max(TO_DATE(H1.DATUMSTR,'-mm-dd'))

SQL*PLUS and CygWin

Hi everybody I'm using cywin on my Win2k box to get a reasonable shell. Now there's one problem left: Everytime I issue a host command within SQL*PLUS, I get a Windows console. I would like to get the bash prompt instead. Is there any way to tell sql plus what to do when you do a host ? Like

Re: SQL query without UNION clause

I think you can translate it as OR, but you have to use some DISTINCT on output rows (because you use UNION and not UNION ALL). Without DISTINCT it is like: SELECT H1.OID HISTORIEOID ,FAHRZEUG.AMTLICHESKENNZEICHEN ,FAHRZEUG.OID ,H1.PRODUKT ,H1.AUFTRAGSPOSITIONSNR ,H1.MYTECHOBJEKT FROM FAHRZEUG,

Re: Methods to get DDL

I do have a set of sqlplus scripts that we wrote for 7.3.4 that generate DDL for objects in the database. So, you can write your own. All the neccessary information is in the catalog. It is for the more common stuff but for some objects the information is so deeply buried it is next to

Re: Direct and indirect foreign key relationships in SQL or Pl/Sql

How do I find out the direct and indirect foreign key relationships? Say, for example there are four tables A, B, C and D of which A is the parent table and B, C and D are child tables. Say B and C are related to A directly and D is related to A through C. How do I find out this indirect

RE: Methods to get DDL

Well I'm always happy to plug good books... But I did just that a couple of years ago on a different Oracle mailing list, and suddenly no-one else seemed to be seeing my posts - it made me wary of posting anything that could possibly be interpreted as a commercial plug. I've been using

RE: iAS 1.0.2.2.2a vs 9iR2 db

Thanks! Last night I managed to make progress, now the OPCA complains that I don't have fine-grained access in my database. Will install this tonight, and I think that'll be enough problems for the week. : ) Pat. -Original Message- Sent: Wednesday, December 18, 2002 5:02 PM To:

HP OmniB. + RMAN 8i

Hello, Listers! I have to do RMAN/Oracle/OmniBackII integration, in order to do backup of archived logs. Database itself is backed up to tapesafter mirror split, and that is not the problem. Now it is time to do integration mentioned above... Any advices and experiences, scripts?

RMAN archived log

Oracle 8.1.7 RMAN with no catalog db, only controlfile is used... How do I remove entries from V$ARCHIVED_LOG; After "backup archivelog all delete input",files are deleted from disk, and their status "deleted" in v$archived_log is set to "YES". But I want to completely remove entries

RMAN scripts - archived logs

Good day to everyone Would somenone share their scripts used to backup archived logs using RMAN 8.1.7? The more complex, the better... Thanks, Vladimir Barac

HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB

Hi people Now it's my turn, i really need some help here. I've got some forms developed in forms 6i (even some in forms 4.5) that are working fine in client/server mode. But ... if i switch to web mode i will lose loads of funtionalities here. The real problem is: How do i put the local devices

Fw: Greeting

Greeting.jpg

Re: SQL*PLUS and CygWin

Before you run sqlplus, set the ComSpec env variable, like so: set ComSpec=c:\usr\local\wbin\sh.exe Next time you host out it will run this instead of the default ComSpec='C:\WINNT\system32\cmd.exe' HTH, Warren Lindsey Stefan Jahnke wrote: Hi everybody I'm using cywin on my Win2k box to get

Oracle and Peoplesoft

How different is an Oracle Peoplesoft database from a regular database? Or in other words what all extra tasks does an Oracle Peoplesoft DBA do? How easy/difficult is it for a an Oracle DBA to transition into a Peoplesoft environment? Are there any good books/ websites on this subject? I would

RE: Methods to get DDL

The original is SQL PL/SQL Annotated Archives Ahh yes... but the new version is/ seems to be Oracle9i Instant PL/SQL Scripts Book Description From the authorized Oracle Press comes a complete guide to developing PL/SQL solutions quickly and easily. Inside, you'll find ready-to-run code

Footprint of 9i

All I'm about to consider rolling out 9i here and I'm wondering what type of footprint most people are seeing. In other words how large of an install is a database administrators (enterprise edition)? I've installed 9i at home on WINNT server, Win XP Pro and Suse Linux 8 all were about 2G. I

Re: Methods to get DDL

Yes, you wouldn't regret. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 8:38 AM The original is SQL PL/SQL Annotated Archives Ahh yes... but the new version is/

Sql problem

Hi, The following select does not work, I get ORA-00904 error message that the AgentShare column does not exists. It would be painful to write down every calculation many times because I can't make a reference to a previous calculated colunm. Select t.*,t.RowId , CONTR_ROWS_MG -

Re: Urgent: Trigger problem...

Joshua, do you have permission to execute /usr/local/ActiveTcl/bin/tclsh on S.O? Adriano - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 2:33 AM Could someone help me with this. I have a trigger in one table and the

Re: HP OmniB. + RMAN 8i

I've spent some time trying to make it work between Oracle 804/rman and Omniback2 hp10.20. The MML documentation was quite fuzzy. I hope it's easier with 8i. --- Vladimir Barac [EMAIL PROTECTED] a écrit : Hello, Listers! I have to do RMAN/Oracle/OmniBackII integration, in order to do

RE: Sql problem

Two possible answers : 42 and inline views. - Original Message - From: Zsolt Csillag [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thu, 19 Dec 2002 05:43:55 Hi, The following select does not work, I get ORA-00904 error message that the AgentShare

problems with materialized view

Hi, On Oracle 8.1.7.2 /aix 4.3 Refreshing complete a MV took forever, I canceled them after 10 hours. Dropping and recreating it took 10 minutes. On another MV, refreshing complete uses over 1G temp space, when dropping and recreating no temp tablespace busting. On smaller ones no difference

Bizzare behaviour of set oracle_sid=mysid

Only in my office can this happen Im checking into connecting to the db under the internal account from a cmd prompt I set oracle_sid=mysid C: set oracle_sid=my_sid C: connect internal I see cmd issuing sqlplusw system/password@othersid So, I add a permanent env_variable called

AW: SQL*PLUS and CygWin

Hi Great, thank you. Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Sql problem

Use inline views, create a view or use a cursor in a PL/sql block Regards, Waleed -Original Message- Sent: Thursday, December 19, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Hi, The following select does not work, I get ORA-00904 error message that the AgentShare column

Re: Oracle and Peoplesoft

Hi Sumathy, It is not too much different from oracle peoplesoft and regular dba. Except you have to know more about peoplesoft components, peoplesoft application server, process schedular, web server,weblogic.. there are some peoplesoft courses I am highly recommend you to take, Configuration and

RE: read only tablespaces

Ah, once again, we are deeply indebted to Jared for his 'perls' of wisdom... -Original Message- Sent: Wednesday, December 18, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Or the Oxford Encyclopedic (sp?) Dictionary of the English Language should you wish a truly authoritative

AW: Sql problem

Try following: Select t.*,t.RowId , CONTR_ROWS_MG - CONTR_ROWS_GROSS_RECEIVED OutStanding , CONTRACT_SALESAGENT_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED / 100 AgentShare ,CONTRACT_SHARE_FIXED OtherShareFixed ,CONTRACT_SHARE_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED /100 OtherSharePercentage

Re: Footprint of 9i

When you say footprint of 9i, my mind automatically flashes to the opening credits of Monty Python's Flying Circus, in which the Liberty Bell March is terminated with a large foot squashing down (*splat*)... I'm not sure what type of systems you're running, but I haven't seen drives smaller than

RE: Backup DB files to the Tape

Stephen, The para. about pax vis-a-vis tar versus cpio was interesting ! I never knew that -- though the names do make sense now ! Hemant At 06:39 AM 18-12-02 -0800, you wrote: I will add a vote for cpio. I have found it to be so reliable that I used cpio, instead of a dump utility, to back

RE: RMAN scripts - archived logs

Attached (If the list supports attachments) are one for tape (Legato Networker) and one for disk which later gets backed up by OS. These are generated by a ksh backup script every time the script runs. The disk backup does not use a catalog server; so you have the line at the end that backs up

Re: iAS 1.0.2.2.2a vs 9iR2 db

You'd need to set O7_DICTIONARY_ACCESSIBILITY to TRUE. Hemant At 08:39 AM 18-12-02 -0800, you wrote: I know this is probably hopeless, but has anyone managed to let the Oracle Portal Configuration Assistant bundled with iAS 1.0.2.2.2a for win32 connect to a 9i database? It wants to connect as

RE: read only tablespaces

Is this group suppose to be helpful or for some people just to show their ego? I do not know something you think is obvious, but I also know something you might not know, which to me is quite easy. It is a learning process, isn't it? One thing I notice is, for some really learned person,

Re:Oracle and Peoplesoft

While we're on the subject of Oracle and PeopleSoft, has anyone out there in a PeopleSoft environment turned on password aging? If so, how did PeopleSoft react? Dick Goulet Reply Separator Author: Panicker; Thankam S. [EMAIL PROTECTED] Date:

RE: Footprint of 9i

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bob Metelsky Sent: Thursday, December 19, 2002 13:49 To: Multiple recipients of list ORACLE-L Subject: Footprint of 9i All I'm about to consider rolling out 9i here and I'm wondering what type of

RE: Footprint of 9i

On Tru64 5.1 /oracle/app/oracle/product du -sk 9.2.0 4601900 9.2.0 There are multiple DBA's here that have a hand in this, so I don't know how much fiddling with the Apache stuff has been done (probably not much). At this time, there is only one 9.2 database on the box, and it is experimental,

Re: HP OmniB. + RMAN 8i

RMAN in 8.0.4 was fuzzy in a lot of ways. 8.0.5.1 is better, 8.0.6.3 better still, and 8i is much like 8.0.6.3. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 9:29 AM I've spent some time trying to make it work

Re: Sql problem

Zsolt, In Oracle9i, you might be able to make use of the new WITH syntax: SQL with xxx as 2 (select 1+2 calc from dual) 3 select calc*2 from xxx; CALC*2 -- 6 It might cut down on typographic errors (if not syntax complexity)

Re: Where's that last archive log?

In theory you should always be able to do an Incomplete Recovery [until the latest archive log you have available] provided that no database file was still in backup mode till a point in time after the last archive log. How do you backup your tablespaces ? Which archive logs are included in your

Re: Bizzare behaviour of set oracle_sid=mysid

Are you executing connect internal at the CMD C: prompt ? Shouldn't it be in the sqlplus prompt ? See if you've somehow got a CONNECT.BAT file in your path. If you are executing C: connect internal, you are probably executing CONNECT.BAT [or CONNECT.EXE or CONNECT.COM] Hemant At 06:39 AM 19-12-02

Spool output issue on solaris

This is what i am doing: 1- login to sqlplus on solaris 2- spool temp.out 3- run an sql file useing: @myfile.sql Sql file contains this: set termout off set head off set echo off set feedback off select * from dual; set

RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

Title: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB in our 9202 RAC we have everything except SYSTEM,UNDO in AUTO and have NO problems at all. We have 7 such instances (all RAC, all 9202 except for on which is 9012). 4 Instances use CLOBs and intermedia extensively, one of these

Spool file behavior on Solaris

hello, This is what i am doing: __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop INET: [EMAIL PROTECTED] Fat

Re: Direct and indirect foreign key relationships in SQL or Pl/Sql

Here is a script that I got from on of the lists. It should do what you want. Ruth select a.constraint_name, a.r_constraint_name, a.table_name, b.table_name from dba_constraints a, dba_constraints b where a.owner='YOUR_OWNER' and a.R_CONSTRAINT_NAME is not null and

RE: Footprint of 9i

Nearly 4Gb on Solaris 2.8. Pretty much a full selection installed John -Original Message- Sent: 19 December 2002 15:00 To: Multiple recipients of list ORACLE-L On Tru64 5.1 /oracle/app/oracle/product du -sk 9.2.0 4601900 9.2.0 There are multiple DBA's here that have a hand in this,

Restoring DB from specific RMAN backup set.

How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB IDCUR Reset

Spool file output

This is what i am doing: 1- login to sqlplus on solaris 2- spool temp.out 3- run an sql file useing: @myfile.sql Sql file contains this: set termout off set head off set echo off set feedback off set pagesize 0 4- spool off

Simple Query for Week number

Hey Folks, Looking for the simplest of queries to find the week number, given a date. For example, 19th December 2002 falls in the 3rd week, whereas 19th November, 2002, falls in the 4th week. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL

RE: kinda OT: veritas netbackup

How about running a script just before the backup that 1) Reads the current log number. 2) Forces a log switch. 3) Copies the logs to a seperate directory. 4) Backups up that seperate directory Leave the archive directory alone. Do not back it up. -Original Message-From:

RE: read only tablespaces

Title: RE: read only tablespaces Here's the specific SQL query that needs to be run: select translate('LNOPQSUVWXYZBCDEGHIJKn;8!###)n9/)3l9)jku9)vum1@', '8#)n!9/3lvjkum1;@LNOPQSUVWXYZBCDEGHIJK', 'F. aRMedthmfinulT!') Well... from DICTIONARY where table_name='DICTIONARY' / :-) :-) :-)

strange error on DBMS_STATS

I'm running dbms_stats.gather_schema_stats, the account running it is NOT the schema owner, but DOES have the analyze any privilege and has read/write access to all the tables in the schema. We are not trying to gather stats into our own tables, just want the stats refreshed after the (massive)

RE: Bizzare behaviour of set oracle_sid=mysid

Humm obivioiously Im missing a few brain cells here Yes, I should know there isnt an exe called connect that would be native to the envioriment outside of oracle. Yes, there was a connect.bat in the path Duh... Ok, so lets see how many more vacant brain cells I have now if I log on to

Re: Spool file output

and your problem is? I run spool files on solaris all the time. What exactly is going wrong? --- OraCop [EMAIL PROTECTED] wrote: This is what i am doing: 1- login to sqlplus on solaris 2- spool temp.out 3- run an sql file useing: @myfile.sql Sql file contains this: set termout

What Bonnie's benchmark should we expect for RAID 0+1

Hello, We have a Compaq AlphaServer 8400 with 8 GB RAM, 8 dual 625mhz CPUs and two HSZ70 Array Controllers. Each Controller is connected to 24 36GB 10K rpm Ultr SCSI disk divers. In the system, some volums are configured as RAID 1, and the others are configured as RAID 0+1 with 3 striping.

RE: Backup DB files to the Tape

It's one of those Unix things. It goes with the beard and the bad-fitting trousers held up by suspenders. -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Backup DB

Re: Oracle and Peoplesoft

I would agree with Joan - we spend lots of time refreshing databases here. We were responsible for all of the application servers, web servers, process schedulers, etc. until a technical architecture team was formed. That has helped tremendously since my team can concentrate on the Oracle side.

Re: Footprint of 9i

Oracle 9.2.0.1 on NT: Demo files 80MB. Starter databases - 300MB Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 5:09 PM -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

We were the other way around in our testing lately:-) We turned on auto space management to remove the contention. Afterwards-we removed quite a bit of header block/free list contention.. anyway, more tests to follow -Original Message-From: VIVEK_SHARMA [mailto:[EMAIL

Re: Restoring DB from specific RMAN backup set.

As long as you haven't opened the database with resetlogs between the time of the backup you want and the present you can just restore it and recover, using backup controlfile, until cancel. If you have opened it with resetlogs, you will have to change the incarnation of the database, Consult the

kinda OT: veritas netbackup

RESEND: never saw it get posted: Can we force veritas netbackup (HPUX) to NOT backup open files? Here is the problem: while arch process is writing out archive logs, the netbackup script that backs up the arch directory will write a partially written log to tape, we're trying to avoid that.

RE: Methods to get DDL

I did not work on the new version, so I have no comments on what is or is not in there -- I don't know how much was removed, added or changed. --- Bob Metelsky [EMAIL PROTECTED] wrote: The original is SQL PL/SQL Annotated Archives Ahh yes... but the new version is/ seems to be

RE: Spool file output

OK. Is there a question or comment here someplace? -Original Message- Sent: Thursday, December 19, 2002 10:40 AM To: Multiple recipients of list ORACLE-L This is what i am doing: 1- login to sqlplus on solaris 2- spool temp.out 3- run an sql file useing: @myfile.sql Sql file

RE: Spool file behavior on Solaris

The solution is: -Original Message- Sent: Thursday, December 19, 2002 8:34 AM To: Multiple recipients of list ORACLE-L hello, This is what i am doing: __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now.

FW: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB

-Original Message- From: Paulo Gomes Sent: quinta-feira, 19 de Dezembro de 2002 12:50 To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB Hi people Now it's my turn, i really need some help here. I've got

Re: read only tablespaces

What is obvious here, is that you don't do your homework (RTFMing) before asking questions. That's why you get, what you asked for :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19,

Re: Spool file behavior on Solaris

and the result is...? reply of course only if it pertains to oracle :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 10:34 AM hello, This is what i am doing:

RE: Footprint of 9i

My issue is with memory requirements... try running iAS 9i R2 on 700M of RAM, with a local db. Ugh! Pat. -Original Message- Sent: Thursday, December 19, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Oracle 9.2.0.1 on NT: Demo files 80MB. Starter databases - 300MB Yechiel

RE: Footprint of 9i

I'm not sure what type of systems you're running, but I haven't seen drives smaller than 18G much lately. Perhaps its time to upgrade to a SAN anyway? :-) 1G isn't all that much to ask (especially if your production systems are running in ARCHIVELOG mode), but your comments prove that

RE: Restoring DB from specific RMAN backup set.

Paul - Can you specify what you mean by no archive log mode and backed up with RMAN? Was the database open? Which Oracle version? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 19, 2002 9:40 AM To: Multiple recipients of

Re: kinda OT: veritas netbackup

Hello Joe Just schedule another backup of the archive logs 1 hour (or 5 minutes) after the regular backup. NetBackup will take a second (complete) backup of the archive file and when you want to restore , restore the last copy of the files. Yechiel AdarMehish - Original Message

RE: strange error on DBMS_STATS

this is being run in sqlplus as execute dbms_stats.gather_schema_stats If I didn't run it (on another schema) within the same sql script, I'd think it was that I didn't have privs on dbms_stats. I'll keep looking --- Jesse, Rich [EMAIL PROTECTED] wrote: Yes, but it turned out to be privs

RE: Simple Query for Week number

Dan, Thanks. The W works just fine. What I was looking for. Phew!!! I almost wrote a PL/SQL for this ; Fink, Dan

RE: strange error on DBMS_STATS

Title: RE: strange error on DBMS_STATS Probably wrong question ... but was rebuilt index still owned by schema owner? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal

RE: Simple Query for Week number

Raj, How do you define week number? If a month starts in the middle of the week, is that week #1 or must it be the first full week? If the format mask 'W' is adequate, use 1 select sysdate, to_char(sysdate, 'W'), 2 '01-DEC-02', to_char(to_date('01-DEC-02'), 'W'), 3

Re: kinda OT: veritas netbackup

Here's an idea. First of all, I assume you are using plain vanilla netbackup, no RMAN. That's what it sounds like. Add the arch directory to the list of directories to exclude. Create a SQL script to create a list of files in the arch directory to backup. I won't supply details, cuz I know

Re: strange error on DBMS_STATS

...I've got this hammer called SQL Trace and just about every problem looks like a nail... Good thing is, this'll probably resolve it for you. Can you run this in the same session prior to running the GATHER_SCHEMA_STATS? alter session set max_dump_file_size = unlimited; alter session set

FW: kinda OT: veritas netbackup

Hi, I am the other guy involved in this issue of Not backing up OPEN files on Unix with Netbackup. We are keeping 2 days of logs on disk up to 60gig of logs.. The tape backup people are not happy about us backing this up often to provide extra redundancy especially as we implement this

RE: Backup DB files to the Tape

Here's a nickel, kid. Go buy yourself a better computer. -Original Message- Sent: Thursday, December 19, 2002 10:15 AM To: Multiple recipients of list ORACLE-L It's one of those Unix things. It goes with the beard and the bad-fitting trousers held up by suspenders. -Original

RE: Simple Query for Week number

select to_char(sysdate, 'W') from dual; Paul -Original Message- Sent: Thursday, December 19, 2002 10:54 AM To: Multiple recipients of list ORACLE-L Hey Folks, Looking for the simplest of queries to find the week number, given a date. For example, 19th December 2002 falls in the 3rd

RE: Spool file behavior on Solaris

Geez, Not only people come to list expect an answer and can't take jokes, now they expect us to read their minds too. Sigh -Original Message- Sent: Thursday, December 19, 2002 10:34 AM To: Multiple recipients of list ORACLE-L hello, This is what i am doing:

RE: strange error on DBMS_STATS

Yes, but it turned out to be privs (or lack thereof) to run the stats or associated queries in a procedure, rather than privs to do the analyze itself. Do you have auditing turned on? That's usually the first place I check to see what objects changed since the last time it worked. GL! Rich

RE: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB

Title: RE: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB if you have activex controls that you want to replace, there is 'Java Importer' and in Forms 9i you can use PJCs also. Read through Forms information at http://technet.oracle.com Raj

Giving back Perl

Title: Giving back Perl Hello everyone - I've been trying to write more Perl lately and after showing my Perl mentor some of the stuff I had written over the last couple of weeks the first thing he said was why don't you give back to the community. So I figure if I offer up my latest

RE: read only tablespaces

Come on now, these guys are just joking. I don't see any egos or mean replies. You asked which dictionary instead of which data dictionary view. It is a learning process and we should all have a little fun. :) -Original Message- Sent: Thursday, December 19, 2002 10:30 AM To: Multiple

FW: kinda OT: veritas netbackup

Yes, we have coded it to do thisand it works but for many reasons.. including simplicitywe want to avoid thissolution for theentire12B enterprise solution... when it confuses others, and is much more vulnerable for screwups with Mount point management and recovery. Brian Spears

RE: Restoring DB from specific RMAN backup set.

Database is 9.0.1.4 running on Win2K. The database called DB2 is not running in archivelog mode. The database is being backed up using RMAN: I.e. set ORACLE_SID=DB2 rman target / catalog rman@otherdb shutdown immediate; startup mount; backup database format=f:\oracle_backup\%d\%d_%U tag

Re: Spool file behavior on Solaris

42 Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 6:45 PM and the result is...? reply of course only if it pertains to oracle :-) Igor Neyman, OCP DBA [EMAIL PROTECTED]

Re: read only tablespaces

Shao We operate of the principle of GIGO - Garbage In, Garbage Out. The people on this list expect you to write clear questions if you want clear answers. Sometimes a questions like yours allow us to horse around a little. All in good will and between friends. Yechiel Adar Mehish - Original

RE: Giving back Perl

I'm interested, send at your convenience. And . Oracle Diaper Administrator ... Diaper ??? As in what my 3 year old has stopped needing at night? ~brian -Original Message- Sent: Thursday, December 19, 2002 11:30 AM To: Multiple recipients of list ORACLE-L Hello everyone - I've

RE: Backup DB files to the Tape

Long live Dilbert! The scary thing around here is that the guy that most fits the description is an NT admin. He even has empty Mountain Dew cans all over his cubicle. The only thing missing are the Hostess Twinkie wrappers. -Original Message- From: Brian Dunbar [mailto:[EMAIL

RE: Giving back Perl

Title: Giving back Perl Pl. send me a copy of the code. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 12:30 PMTo: Multiple recipients of list ORACLE-LSubject: Giving back Perl Hello everyone - I've been trying to

Re: Simple Query for Week number

Check out the date 19/11/2002. format 'W' return 3 instead of 4. I wrote something to do this. It select the week day number of the current date, the week day number of the first of the month and the current week. If week day of the first of the month is higher then the current week day Then add

RE: Backup DB files to the Tape

Condescending Unix user! -Original Message- Sent: Thursday, December 19, 2002 12:45 PM To: Multiple recipients of list ORACLE-L Here's a nickel, kid. Go buy yourself a better computer. -Original Message- Sent: Thursday, December 19, 2002 10:15 AM To: Multiple recipients of list

Re: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

Depending on your circumstances, ASS Management can eliminate severe contention on the freelists / freelist groups area. However, because Oracle is overgenerous with its allocation of bitmap blocks (which may turn out to be in excess of 1% of your database), you may end up thrashing your system

RE: read only tablespaces

That's a keeper! Orr, Steve [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/19/2002 07:21 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: read only tablespaces Here's the specific SQL query

RE: kinda OT: veritas netbackup

In that case Brian ... sorry, not going to be any help. Good luck. -Original Message-From: Spears, Brian [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: FW: kinda OT: veritas netbackup Yes, we have

RE: Backup DB files to the Tape

That's MR. Condescending Unix user thankyouverymuch. -Original Message- Sent: Thursday, December 19, 2002 1:03 PM To: Multiple recipients of list ORACLE-L Condescending Unix user! -Original Message- Sent: Thursday, December 19, 2002 12:45 PM To: Multiple recipients of list

RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB

Title: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB ASS Management? I'm snickering, I know it's juvenile humor, but... LOL! Let me tell you, my ASS is not on the Free List. And thrashing? I'll leave that one alone! Sorry everyone. Couldn't resist. Is it Friday yet...

  1   2   >