niall.litchfield's articles:

Items(9) /1

help us to help you 0 44 (8/16/2007 9:26:05 PM) comp.databases.oracle.server Michel correctly pointed out that what you posted was invalid pl/sql and would return a syntax error. In addition you don't supply a version, the definition of types, the error message, or what you were attempt... Niall

dbca - create database greyed out 0 82 (8/31/2005 9:53:56 PM) comp.databases.oracle.server What install option did you choose? IIRC choosing to install the client can result in brain-dead server utilities being installed Niall ... news

petition #2 0 43 (7/13/2005 12:49:31 PM) comp.databases.oracle.server Apologies if Google posts this twice. I have recently started a petition at http://www.petitiononline.com/oraman/petition.html calling on Oracle Corporation to allow all customers, not just enterprise edition... Niall

petition 8 44 (7/13/2005 12:31:31 PM) comp.databases.oracle.server I have recently started a petition at http://www.petitiononline.com/oraman/petition.html calling on Oracle Corporation to allow all customers, not just enterprise edition customers to license the various manag... Niall

Small Announcement #3 3 52 (11/10/2004 11:05:31 AM) comp.databases.oracle.server I promise that this will be the only time I mention this. I have created a simple utility for generating resource usage profiles from extended sql trace data that is available from my website for free use. Th... Niall

Small Announcement #2 0 42 (11/10/2004 11:05:04 AM) comp.databases.oracle.server I promise that this will be the only time I mention this. I have created a simple utility for generating resource usage profiles from extended sql trace data that is available from my website for free use. Th... Niall

Small Announcement 1 46 (11/10/2004 10:33:23 AM) comp.databases.oracle.server I promise that this will be the only time I mention this. I have created a simple utility for generating resource usage profiles from extended sql trace data that is available from my website for free use. Th... Niall

Re: Max Size Datafile in 10g 2 40 (9/16/2004 10:07:28 AM) comp.databases.oracle.server comments below koert54 wrote: > Connor, > > Any idea how they managed to do is ? I guess the DBA increased in size for > bigfile tablespaces ... > > kind regards > K > Its an interesting guess, but seems to be... Niall

The sun is the same in a different way 0 58 (6/11/2004 9:08:51 PM) comp.databases.oracle.server As promised there is now a script at my site that will allow you to play with arbitrary insertions and deletions into tables in order to attempt to create indexes that have inconsistent heights. Hopefully it ed... Niall

niall.litchfield's replies:

Items(408) /41 Next >> Last >|

Will Oracle 10g run on HP UNIX 11 3 38 (11/8/2007 7:12:35 PM) comp.databases.oracle.server I am on HP UNIX 11 in a production nevironment, cannot upgrade to 11i. Want to install Oracle 10.1 or 10.2. In certfication matrix, Oracle 10g is shown to run on HP UNIX 11i. Will it still run on HP UNIX11, tha... zigzagdna (346)

Compress Offline Redo Logs on Windows? 5 39 (11/8/2007 4:18:44 PM) comp.databases.oracle.server Hi, We have many Oracle databases running on Win2003 (Some on Win2000). Due to disk space issues, I manually zip some of the offline redo logs using Winzip. The logs are 20MB or 50MB in size. Now, I want to a... basis_consultant (53)

Object names changed to BIN$pgkQ... etc 20 50 (11/6/2007 2:21:47 PM) comp.databases.oracle.server Hello all, I just connected with TOAD 8.6 to a Oracle 10.2.0.1 where i installed a database with tables a few days ago. Now when i connect with TOAD, most of the tables in the table listing are gone. When i ch... helma.vinke (125)

OCF(v2). 15 42 (11/5/2007 4:25:23 PM) comp.databases.oracle.server Hi, I need some advise from someone who knows alot about OCF and maybe CFs in general.. Suppose you have two independent (A & B) database nodes share a database volume on a CF. Is it possible to have the CF ... per.lanvin2 (10)

why administrator refuse to give permission on PLUSTRACE 86 45 (10/26/2007 12:21:48 PM) comp.databases.oracle.server why our DBA refuse to give us permission on PLUSTRACE ??? does that role expose the database to any security flaw ??? I need to set the AUTOTRACE to understand how the sql script is functionning, but our DBA re... antony6670 (10)

Database Performance Problem between 3:00PM and 4:00PM 25 35 (10/22/2007 2:56:17 PM) comp.databases.oracle.server I am Windows 2000 server using Oracle 9.2.0.6. We have strange problem where by database becomes extremely slow between 3:00PM and 4:00PM. Same queries which take 15 seconds before 3:00PM (e.g., 2:55PM) take 3... zigzagdna (346)

Histograms on Columns for CBO 6 33 (10/5/2007 5:05:37 PM) comp.databases.oracle.server I am on Oracle 9.2.0.6 on Wiindows 2000, but I will like to know for any version of Oracle - 9.2 or later, following can be done. I have created function based indexes on upper of columns, foe example upper(... zigzagdna (346)

Force Upper Case 5 51 (10/5/2007 3:46:05 PM) comp.databases.oracle.server Hi, I have about more than 175 fields. Some are different (Characters, Date, Numeric, etc). I'm trying to force all capital letter only on Character Types at once. I hate to type each of the fields. Ucase... learning_codes (17)

hi all #2 5 35 (10/3/2007 1:15:39 PM) comp.databases.oracle.server String query="select status from menu_logs where menu='Initialisation Of the month'"; ResultSet rs=stmt.executeQuery(query); menu_logs: MENU VARCHAR2(50) SEQ NUMBER(3) STATUS V... roy.mamta (14)

Unexplainable: "Beautified" code runs slower 17 41 (10/1/2007 4:24:21 AM) comp.databases.oracle.server 10gR2 EE (10.2.0.3.0) /Solaris I have run into the biggest "mystery" in my 7 years of PL/SQL programming - my inability to even GUESS is so unacceptable to me it is driving me up the walls. So I inherited t... userjohn (21)