我的sql笔记2

1、sybase重建所欲索引

select 'DBCC REINDEX ('+name+')'+' GO' from  sysobjects where type = 'U'

2、查询重复项

select * 
from t1 WHERE ID in (SELECT ID from t1 group BY ID having count(1) >= 2)

3、11g备份

导出
expdp 'sys/123@orcl as sysdba' schemas=test dumpfile=test.dmp logfile=test.log DIRECTORY=DATA_PUMP_DIR    

导入
impdp 'sys/123@orcl as sysdba' DIRECTORY=DATA_PUMP_DIR SCHEMAS=test DUMPFILE=test.DMP logfile=test.log