alter table Tablename add(column1 varchar2(20),column2 number(7,2)...)
比如：
已有表A，结构如下
字段名 类型
------------ -------------
A VARCHAR2(10)
B NUMBER
现在要增加一列C，类型是Varchar2(20)则：
alter table a add(C varchar2(20)); ......

到Oralce路径下
D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN
ZHG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = leehong)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = zhg)
    )
  )
HOST：要连接的机器名，可以使IP
PORT：端口号
SERVICE_NAME ：对方的实例 ......

Oracle中TO_DATE格式
url:http://www.cnblogs.com/ajian/archive/2009/03/25/1421063.html
TO_DATE格式(以时间:2007-11-02   13:45:25为例)
  
        Year:     
        yy two digits 两位年                显示值:07
        yyy three digits 三位年                显示值:007
        yyyy four digits 四位年                显示值:2007
           
        Month:     
        mm    number     两位月&nb ......

原文:ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
　　Cause This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this message include:
　　1.timeouts
　　2.file corruption
　　3.failed data checks in memory
　　4.hardware, memory, or I/O errors
　　5.incorrectly restored files
　　The first argument is the internal message number. Other arguments are various numbers, names, and character strings. The numbers may change meanings between different versions of Oracle.
　　Action Report this error to Oracle Customer Support after gathering the following information:
　　1.events that led up to the error
　　2.the operations that were attempted that led to the error
　　3.the conditions of the operating system and databases at the time of the error
　　4.any unusual circumstances that occurred bef ......

1.         在oracle10g中建立表空间
create tablespace test datafile 'D:\oracle\product\10.1.0\oradate\test.dbf' size 500m autoextend on next 100m
maxsize unlimited
logging
permanent
extent management local autoallocate
blocksize 8k
segment space management manual
flashback on;
2.   在oracle 10g 中创建表用户
CREATE USER test IDENTIFIED BY "test" 
 DEFAULT TABLESPACE "TEST" 
 TEMPORARY TABLESPACE "TEMP" 
 PROFILE DEFAULT 
 QUOTA UNLIMITED ON "TEST";  
GRANT UNDER ANY TABLE TO test WITH ADMIN OPTION;   
GRANT UNDER ANY TYPE TO test WITH ADMIN OPTION;  
GRANT UNDER ANY VIEW TO test WITH ADMIN OPTION;   
GRANT "DBA" TO test WITH ADMIN OPTION;  
GRANT "OLAP_DBA" TO test WITH ADMIN OPTION;  
GRANT "OLAP_USER" TO test WITH ADMIN OPTION;  
GRANT "SELECT_CATALOG_ROLE" TO test WITH ADMIN OPTION;&nbs ......

oracle clob 和blob问题的解决
 
整理了oracle clob 和blob问题的解决办法：
1：建议使用oracle 10的ojdbc14.jar,否则当保存clob的时候可能会出现套接字错误； 
2：spring配置如下： 
java代码: 
        <bean id="sessionFactory" > 
                <property name="hibernateProperties"> 
                        <props> 
                                <prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop> 
             ......