Oracle 常用命令

1.alter table "table_name"  add (字段 类型,....,......);

2.alter table "table_name"  drop (字段,....,......);

2.1.alter table "table_name"  modify (字段,....,......);

3.Imp  username/password @server   file=c:\a.dmp  fromuser=ecp touser=kenny (末尾不要分号,imp不是在sqlplus中运行).

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

AMERICAN_AMERICA.UTF8

imp kenny/kenny file=c:\a.dmp fromuser=ECP;

 

 

4.http://hi.baidu.com/sherrymall/blog/item/f103910ad0ae0f1c94ca6b7f.html