导出表

Posted on 2008-10-08 17:59 闫景荣阅读(121) 评论(0) 收藏举报

exp user/password@数据库名 grants=y file=文件名.dmp buffer=4096000 tables=(table1,table2) query="""where colomn1='200807' and partition_area_code in ('9004','9005','9006','9007','9008','9009','9010','9011','9012')"""

exp eba_dim/eba_dim_bonc@nmubis tables=EBA_DIM.DIM_OPPONENT_MOBILE file=EBA_DIM.DIM_OPPONENT_MOBILE.dmp query=\"where rownum<10001\"