oracle exp根据条件,oracle exp导出加上过滤条件

exp username/password@dbname   file=‘d:\hehe.dmp‘ tables=(%) query="""where UPDATE_DTIME >= to_date(‘2017-01-01‘,‘yyyy-mm-dd‘)"""

create user DB_USER_NAME identified by DB_USER_PWD

default tablespace ETL;

grant connect,resource to DB_USER_NAME;

grant create any sequence to DB_USER_NAME;

grant create any table to DB_USER_NAME;

grant delete any table to DB_USER_NAME;

grant insert any table to DB_USER_NAME;

grant select any table to DB_USER_NAME;

grant unlimited tablespace to DB_USER_NAME;

grant execute any procedure to DB_USER_NAME;

grant update any table to DB_USER_NAME;

grant create any view to DB_USER_NAME;

grant DBA to DB_USER_NAME;

//表空间

create tablespace XXX

datafile ‘D:/app/DEMOSPACE_TBSPACE.dbf‘

size 1500M

autoextend on next 5M maxsize 2000M;

oracle exp导出加上过滤条件

标签：空间   extend   connect   enc   to_date   tab   xtend   taf   file

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：http://www.cnblogs.com/wdw31210/p/7284769.html