Re: internal date value

: 130,100,5,5,16,31,46 12 rows selected. /peter Igor Neyman wrote: You gather it wrong :) Oracle stores date in 8 bytes, one for each: year, month, day, hour, min, ... etc. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Droogendyk, Harry Sent: Friday, January 23, 2004 12:40 PM

Re: Renumber a set of grupped rows?

005 10004 006 etc Any ideas? Thanks, maa -- Best regards/Venlig hilsen /*Peter Gram*/ mailto:[EMAIL PROTECTED] Miracle A/S http://www.miracleas.dk/ Kratvej 2 DK - 2760 Måløv Cell: (+45) 2527 7107 Phone: (+45) 4466 8855 Fax: (+45) 4466 8856 Home: (+45) 3874 5696 Email: [EMAIL

Re: Renumber a set of grupped rows?

-- Best regards/Venlig hilsen /*Peter Gram*/ mailto:[EMAIL PROTECTED] Miracle A/S http://www.miracleas.dk/ Kratvej 2 DK - 2760 Måløv Cell: (+45) 2527 7107 Phone: (+45) 4466 8855 Fax: (+45) 4466 8856 Home: (+45) 3874 5696 Email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] SQL Server Master Class 8-10

Re: encrypt back-up data

Hi It is only the data that is passed via sqlnet. /peter Ehresmann, David wrote: Thanks, I will pass it along. Next question: If you are using Oracle's Advanced Encryption standard with one of the following standards: encryption algorithms supported are RC4_40, RC4_56, RC4_128

Re: encrypt back-up data

: Friday, January 02, 2004 2:19 PM To: Multiple recipients of list ORACLE-L Hi It is only the data that is passed via sqlnet. /peter Ehresmann, David wrote: Thanks, I will pass it along. Next question: If you are using Oracle's Advanced Encryption standard with one of the following

Re: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE

to the performance or response time differences. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, Australia

Re: pl/sql open cursor question

; exception when others then return null; end; -- Best regards/Venlig hilsen Peter Gram MiracleA/S Kratvej 2 DK - 2760 Mlv Cell:(+45) 2527 7107 Phone:(+45) 4466 8855 Fax:(+45) 4466 8856 Home:(+45) 3874 5696 Email:[EMAIL PROTECTED]

Checking that the instance is up

Folks - Some months ago there were exchanges on the optimum way to check that an instance was alive. I have searched, hunted and generally scavenged for these exchanges, but without luck. Can anyone give me the subject line, and I can turn again to the archive? thanks, peter edinburgh

RE: Checking that the instance is up

Mark, Raj - Thank you both for coming back on that request of mine so promptly - I feel that I have a surfeit of riches! peter edinburgh -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED] Sent: Thursday, December 18, 2003 2:54 PM To: Multiple recipients of list ORACLE-L

Using a '.' in a username

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lee, Peter (AZ15) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Problem with Null Valuies (grin!)

; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns - the ones we don't know we don't know. Who? None other than US Defence Secretary Donald Rumsfeld. peter edinburgh

Re: Anyone run into this strange ORA-00904 error ??

Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City

Re: Writing a delay in PL/SQL?

Hi try DBMS_LOCK.SLEEP (seconds IN NUMBER); /peter Jonathan Gennick wrote: I know this is going to sound rather crazy, but I want to write an INSERT trigger that imposes an arbitrary delay, say a half second, or maybe a full second, on each and every insert operation. Does anyone know

PowerPoint and Oracle

A wild one here - but has anyone stuffed PowerPoint files into Oracle, together with associated metadata? Either complete (the easier solution) or decomposed for easier review. thanks, peter edinburgh * This e-mail message

Re: sql trace - XCTEND rlbk=1, rd_only=1

Boris It look like the app's is doing rollback :-( Have a look in Note 39817.1 Interpreting Raw SQL_TRACE ... for more info. XCTEND rlbk=(0 or 1) rd_only= (0 or 1) rlbk : 1 = rollback 0 = commit rd_only : 1 = read only transaction 0 = none read only /peter Boris Dali wrote: I've got a third

RE: Database Health Template-OT

and metadata. They could of course treat the former in the same way, however. peter edinburgh Guys, For management reporting has anyone considered OEM V9?? Has anyone installed it - do you know that it provides a number of reports already defined that can be setup to be run

Configuring multi-threaded server

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

RE: Configuring multi-threaded server

DISPATCHER established:0 refused:0 current:0 max:1022 state:ready D000 machine: bvdesi02, pid: 41012 (ADDRESS=(PROTOCOL=tcp)(HOST=bvdesi02.esid.northgrum.com)(PORT=33420)) It looks like the listener is ignoring the second entry. Any idea what is going on here? Thanks, Peter Schauss

RE: Configuring multi-threaded server

Thanks for all of the suggestions. I took a look at my init.ora file and discovered that I had the services and db_domain entries disagreed with the database global_name value and. I fixed those entries, bounced the database and the connections started coming in on the shared server. Peter

RE: Configuring multi-threaded server

If you remove the database declarations from your listener.ora file does it cause a problem if the listener is not running when the database comes up? Thanks, Peter Schauss -Original Message- Sent: Monday, November 17, 2003 2:55 PM To: Multiple recipients of list ORACLE-L Peter

RE: Database Compare Script

elicited an immediate response. Comparison is two-part, of course - DDL and data. Databee excellent for former. On data comparisons you will need a different solution, which will depend on the size of your tables. More on that if required. peter edinburgh -Original Message- Sent

RE: Geometric mean

Thanks for that, Stephane - hmmm, I'm still working on it... will post the successful script when I get it... peter edinburgh -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 5:24 PM To: Multiple recipients of list ORACLE-L

RE: LF and CR (chr(10)||chr(13)) problem

to look for these non-printers first. Oh yes - don't judge data contents by what Notepad might show you. Use a hex editor (or dump) if you really want to check. peter edinburgh -Original Message- From: Kitty Luo [mailto:[EMAIL PROTECTED] Sent: Friday, November 14, 2003 4:59 AM

Geometric mean

Has anyone any code (SQL, PL/SQL) that will permit the calculation of the geometric mean of 'n' values? appreciated... peter edinburgh ps - yes I know Perl will do it, but that is not the answer... * This e-mail message

Re: Stop using SYS, SYSTEM?

containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk

Multi-threaded server - will it help in this case

, for example, by eliminating the overhead of starting a dedicated server for each connection? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Multithreaded server - effect of POOLING=ON option

Thanks for all of the input on the multi-threaded server. I have one more question: What is the effect of the POOLING option on the MTS_DISPATCHERS specification? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL

RE: XDB XLMSCHEMA

Hi, I do not have a tool for what you want. But I did experiment with XDB during the Summer of 2002. There is a XML IDE called XML Spy that integrates with Oracle XDB (http://www.altova.com/) and I suggest that you go to the XDB forum on Technet to ask your questions, I do not think that

RE: DBA Support Database

in the system. The management of an attribute in a table can in fact be traced right back up to that level of senior management where they don't even know how to spell 'Oracle'... peter edinburgh -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003

Using an index defined on members of a user defined type

] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Replication

... ! If you really want more details, then contact me off-line. peter edinburgh -Original Message- Sent: Wednesday, October 22, 2003 12:39 PM To: Multiple recipients of list ORACLE-L Peter, your reply was empty, could pls. send it again, maybe you have valuable information... rgds gb

RE: Replication

--_=_NextPart_001_01C39882.D1104260 Content-Type: text/plain; charset=iso-8859-1 Use Oracla's advanced replication (only available with Enterprise Edition). Or use the patented Robson method!! peter -Original Message- Sent: Wednesday, October 22, 2003 11:45 AM To: Multiple

RE: Problem in dropping Materialized View

] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: OT California

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

RE: Where can I download 10g ?

hmm, that makes one wonder... peter edinburgh -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 1:09 AM To: Multiple recipients of list ORACLE-L Subject: Re: Where can I download 10g ? At least I would then die with a broad

RE: 8.1.7 to 8.1.7.4 database migration - step 10 hangs

not finished. Peter Schauss -Original Message- Sent: Thursday, October 16, 2003 4:44 PM To: Multiple recipients of list ORACLE-L It may take a while to run (1/2 hour), how long has it been running? There are some issues with reloading java on an upgrade. I just went through the same

RE: How to add ' (comma) at the begining and end of each line? Ei

||, ***etc from table; peter -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED] Sent: Thursday, October 16, 2003 3:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: How to add ' (comma) at the begining and end of each line? Ei small C, java, Perl

8.1.7 to 8.1.7.4 database migration - step 10 hangs

. Has anyone else had this problem? Is there a workaround? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Find an unprintable character inside a column....

this But but but... peter edinburgh -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED] Sent: Friday, October 10, 2003 10:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: Find an unprintable character inside a column [EMAIL PROTECTED] wrote: I played

RE: RE: Find an unprintable character inside a column....

could use the PK of the table instead of rowid, of course. You will also note that I select the DATA field in both normal and ascii 'dump' mode, the better to locate where the corruption is located. peter edinburgh ... Source as follows: Function BAD_ASCII (V_Text

RE: Find an unprintable character inside a column....

it. peter edinburgh -Original Message- Sent: Thursday, October 09, 2003 9:54 AM To: Multiple recipients of list ORACLE-L Steve, If you are patient, I guess that something like where dump(problem_column) like '%target hex%' should more or less answer your question. HTH SF

Re: Shell script broken, bdf adds new line for long filesystem name.

-- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048

RE: how to send mail from windows command prompt?

(http://www.ozemail.com.au/~adavison) - been using it for ages, when it was free. Now I think its $25. peter edinburgh -Original Message- From: Murali_Pavuloori/[EMAIL PROTECTED] [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 11:15 PM To: Multiple recipients

RE: Development environments

Interesting to see the reference to Ultraedit. Been my regular editor for many years now. Macros are particularly useful, but also the ability to column edit. Often used it in association with spooled output, macro manipulation, then subsequent data input (in migration work, for example). peter

RE: BAARF

immediately via email: [EMAIL PROTECTED] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: x$ constructs and memory

Dan - I think you are in grave danger of forgetting the point of sitting on the top of mountains Either that or your Colorado mountains have nothing on our variety from the NW Highlands of Scotland... (grin!) peter edinburgh -Original Message- From: Daniel Fink [mailto:[EMAIL

RE: Off Topic: PC Firewall Recommendation

of the line... Anyone been down this particular topic? peter edinburgh -Original Message- From: Brian Dunbar [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 6:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: Off Topic: PC Firewall Recommendation KENNETH JANUSZ

RE: select distinct values

, then sure as eggs is eggs, it will fail on another data set. There is NOTHING in your example data set which enables a logical predicate to establish precedence of any one row with Testid=1 over another. peter edinburgh thanks! elain

RE: 10g: SQL Plus

Ah-a - NOW I see why you want my old version 5 manuals!! peter edinburgh -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2003 7:45 PM To: Multiple recipients of list ORACLE-L Subject: Re: 10g: SQL Plus Well, we have a good

RE: Offshore protests

Dale Carnegie ? ! My - that dates you! (Unless it has recently been reprinted - after 50 years!) peter edinburgh -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2003 5:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: Offshore

RE: Offshore protests

: Re: Offshore protests My age is the answer to the question of life, universe and everything. Unfortunately, I'm no longer in my twenties. On 2003.09.23 05:13, Robson, Peter wrote: Dale Carnegie ? ! My - that dates you! (Unless it has recently been reprinted - after 50 years

RE: Offshore protests

is as relevant today as it was when first published, if a bit corny. It was, after all, written for a very different world than our own. So you are, after all, absolutely correct in your analysis. (ps - that is a little practical Dale Carnegie for you to enjoy!) peter edinburgh -Original

RE: How to check data between two similar tables?

if there are dissimilarities between the candidate tables. Also (and this is of course vital) the DDLs for the tables being compared must be identical. Not unreasonable, I would have thought... Mail me if you want further details. peter edinburgh -Original Message- Sent: Friday, September 19

RE: SQL Query

' and c.col3='C' ... which really begs the question - 'what IS the question?' ! Although this solution works, it would be quite impractical to apply it to 'test' if there were 'n' values of col3. Imran - try framing your question in general terms. peter edinburgh -Original Message- Sent

RE: OT, But really STUPID

. The subtext was - 'why don't you speak to that person instead of emailing them?' peter edinburgh -Original Message- Sent: Friday, September 19, 2003 6:55 PM To: Multiple recipients of list ORACLE-L British Company Declares War On Internal E-mail British telephone retailer Phones 4u

Re: 10g: SQL Plus

? Thanks In Advance, Jay _ High-speed Internet access as low as $29.95/month (depending on the local service providers in your area). Click here. https://broadband.msn.com -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax

Re: SQL Plus

). -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12

Re: wrapping packages

=text_email_english -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12

Re: wrapping packages

: there is no unwrap cmd/exe Regards -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html

RE: sizing sort_area_size

PROTECTED] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: Move SQL Server Tables to Oracle

... rgds G Want to chat instantly with your online friends? *Get the FREE Yahoo! Messenger* http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.com/ -- Peter Gram, Miracle A/S Phone : +45 2527 7107

Re: Anyone have a copy of DUL ??

. /peter Pete Finnigan wrote: Hi Mark I agree with you Mark, even if its supplied by Oracle technicians - it is as you say possible to by-pass security completely. Does anyone in Oracle check that the field support personnel dispatched to a site ( in urgency ) are dumping data for the owner

Re: FAO: Peter Gram

immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1 -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL

RE: 64 bit Oracle (8.1.7) on a 32 bit AIX kernel (AIX 4.3.3)

Oracle in 64 bit or 32 bit mode? - If Oracle is running in 32 bit mode, what will happen if I restore a cold backup of my AIX 4.3.3 (64 bit) database onto the AIX 5L system? Thanks, Peter Schauss -Original Message- Sent: Friday, September 12, 2003 5:24 AM To: Multiple recipients of list ORACLE

8.1.7 on AIX 5.2

We are getting ready to migrate one of our instances from AIX 4.3.3 to 5.2. Do I need to get different media for this? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858

64 bit Oracle (8.1.7) on a 32 bit AIX kernel (AIX 4.3.3)

- 64bit Production How can I be running the 64 bit server on a system with a 32 bit kernel? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: DB2 has a foot in the door

, please notify us immediately via email: [EMAIL PROTECTED] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: offshoring article

: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E

Re: question on spfile and pfile

not sure if current spfile is different from that initSID.ora. Please help! thanks, Jin -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http

RE: Oracle9iR2 - temporary tablespace usage error

Hi, There are a couple of issues here. Firstly you need to know that when you get the error about the "temp" segment when building the index, the segment in question is the index. It is just that when building the index Oracle creates a temp segment to sort the data in and to create the

RE: book

://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

RE: get sid (session id) and serial#?

Title: Message Hi, It is my understanding that Oracle do support the dbms_support package and that it should have been in the 8i distribution, but was missed out by mistake. It's calls to sys.dbms_system.set_ev they do not supoprt since this enables you to set any debug event in the kernel.

RE: Question about Constraint

Sounds like 'Companynumber' and 'Type' should be either a compound Primary Key, or a unique index. Which begs the question of what 'Id' is doing - perhaps you don't need it. peter -Original Message- Sent: Friday, August 29, 2003 10:39 AM To: Multiple recipients of list ORACLE-L Hallo

Friday at the coding face...

scary to realise there is very little to choose between mass murderers and techies). ( hope this 'off topic' is acceptable within the spirit of Friday afternoons!) peter * This e-mail message, and any files transmitted

RE: Friday at the coding face...

and which are serial killers? http://www.malevole.com/mv/misc/killerquiz/ It's actually quite difficult (not to mention scary to realise there is very little to choose between mass murderers and techies). ( hope this 'off topic' is acceptable within the spirit of Friday afternoons!) peter

Need help with an error ORA-12640

? Thank you in advance. Pete -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lee, Peter (AZ15) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Moving Data from Oracle to SQL Server

-- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048

Re: How to invoke stored procedures from another instance?

could effectively though have an EAI adaptor for your application with a bit of additional thought Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services

RE: Need help with an error ORA-12640

Jarad: username/password Thank in advance, Pete -Original Message- Sent: Thursday, August 28, 2003 8:15 AM To: Multiple recipients of list ORACLE-L How does the application connect to the database? username/password or '/'? Jared On Wed, 2003-08-27 at 23:19, Lee, Peter (AZ15

Re: How to keep root out?

to firstly discuss it with them and then if the response is unsuitable you need to document the facts and present it to your manager for him to determine what is acceptable. Tough one to call Cheers -- = Peter McLarty E-mail: [EMAIL

RE: Grid

what Ellison said about that? ('The biggest mistake we ever made' - I was there, I heard him say it). So. I'm just wondering how this particular circle is going to be squared... peter edinburgh -Original Message- Sent: Monday, August 25, 2003 7:10 PM To: Multiple recipients of list

RE: Nature of Oracle-l has changed

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Chris Date speaking in Edinburgh, October 24th

. Contact details etc can be found in the web site referenced. Otherwise email me. peter == Chris Date will give three lectures during a 1-day meeting in Edinburgh on Friday 24th October, 2003. You can find out more about the subjects he will be addressing by visiting the site http

RE: Hey Jared

or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: Nature of Oracle-l has changed

world, unless America has shipped all development work offshore these days. Its Friday arvo and almost beer o'clock so the brain is about to hit neutral. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical Consultant

Re: Forms 3 and 9i

works with 9i. Any known issues in this. TIA, Senthil. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003

RE: Org charts

--_=_NextPart_001_01C3655F.E5DC1490 Content-Type: text/plain; charset=iso-8859-1 Nice as far as it goes, Jared - let us know when you can generate a complete ER diagram from SQL*Plus... ! peter edinburgh -Original Message- Sent: Saturday, August 16, 2003 2:04 AM To: Multiple

Re: Oracle 9i and connect as sys

Hi Babette This is a feature of 9i. using SYS you have to always use as sysdba same thing on Windows and Solaris at least and I am sure it is all other OS's Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical Consultant

Finding dedicated server processes associated with a specified us

How do you determine which dedicated server processes are associated with a given user session? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Raid 1 vs Raid 5 for tablespaces

Our hardware people tell me that our disk array will not support Raid 10. Given a choice between Raid 1 or 5 for my tablespaces, which one is best? This is Oracle 8.1.7 on AIX 4.3.3. The application will have a mix of read and write activity. Thanks, Peter Schauss -- Please see the official

materialized view failing to create in 9.2.0.3

raised a tar as yet so if anyone can tell me my query is wrong or invalid for a mview or other useful info else I shall raise a TAR Cheers -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com

Re: What books recommended for Data Modeling ?

Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238

Analytical Functions

(salary, 1, 0) OVER (ORDER BY hire_date) AS prev_sal FROM employees WHERE job_id = 'PU_CLERK'; Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services

RE: Analytical Functions

if the PL/SQL now understands them, I suspect it will as a lot of other things work. Update soon And thanks guys Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC

RE: OT -- Boston Globe job listings

business systems, so much so that moving such a post offshore would really be counter-productive. Even the suits can understand that. peter -Original Message- Sent: Thursday, August 14, 2003 5:45 PM To: Multiple recipients of list ORACLE-L You should try the UK. The government seems

RE: streams comments

to address some of the technical shortcomings of basic replication. I would say the product is certainly worth spending a little more time on to check it more closely against your requirements. peter edinburgh -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 6:04 PM

Re: Event 10235

y this event would be set. Anyone have experience with this event and what some of the motivations were? Dan -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia

Re: More On 10G

-- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list

RE: What books recommended for Data Modeling ?

, subtle area, and not easily learned from text books alone. You also need to decide which methodology and standards you want to follow. peter edinburgh hi all, What books you recommend for Data Modeling ? including how to map business requirements to relational and Data warehouse date model

Re: How to Lock and unlock a table until SP completes

-- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238

  1   2   3   4   5   6   7   >