2008-08-20 11:50:59兼職奶爸
Oracle進階
1.Export table data
exp userid=user/passwd@SID file=d:dump.dmp tables=(Owner.table_name) CONSTRAINTS=Y INDEXES=Y CONSISTENT=Y
exp userid=user/passwd@SID file=d:dump.dmp tables=(Owner.table_name) CONSTRAINTS=Y INDEXES=Y CONSISTENT=Y
2.Export all table data
exp user/passwd@SID full=y file=090325_full.dmp log=090325_exp.log
3.Import all table data
imp user/passwd@SID full=Y file=D:/CUE/exp/090325_full.dmp Log=d:/CUE/exp/090325_full.log
4.修改column的default value
alter table table_name modify(column_name default default_value);
上一篇:解釋FM00000000