November 16, 2005

• ORA-99999: Warning – bloatware detected. Please uninstall Oracle.

  I can’t emphasise enough how much I hate Oracle. Look at the following lines of code and output:

  SQL> create cluster cust_supp_nation_cluster (n_nationkey integer) size 1484802;
  
  create cluster cust_supp_nation_cluster (n_nationkey integer) size 1484802
  
                                                                    
  *
  
  ERROR at line 1:
  
  ORA-02229: invalid SIZE option value

  Now, here’s what the Oracle manual has to say about this very nice error ORA-02229:
  <quote>
  
  Cause: The specified value must be an integer number of bytes.
  
  Action: Specify an appropriate value.
  </quote>

  Are you trying to tell me 1484802 is not an integer?

  - SwordAngel

  • 4:03 pm
  • Leave a comment