Oracle数据日常使用脚本

exp icbc/kingdee file=/opt/app/oracle/expdir/ICBC_200910140949.dmp log=ICBC_200910140949.log owner=icbc

imp icbc/kingdee file = /opt/app/oracle/expdir/ICBC_200910140949.dmp ignore=y commit=y

imp OICBC/kingdee file = /opt/oracle/expdir/ICBC5_20100417.dmp fromuser=icbc5 touser=OICBC ignore=y commit=y

drop tablespace 表空间名称 including contents and datafiles;

drop tablespace icbc including contents and datafiles;

drop user icbc  cascade;

 impdp system/kingdee DIRECTORY=expdir dumpfile=SAAS2_db_20100525.dmp SCHEMAS=youshang2 REMAP_SCHEMA=youshang2:crm2online

 impdp system/kingdee DIRECTORY=expdir dumpfile=SAAS2_db_20100525.dmp SCHEMAS=youshang2 REMAP_SCHEMA=youshang2:crm2online

CREATE SMALLFILE TABLESPACE SWITCHTEMP DATAFILE '/opt/app/oracle/oradata/saas2/SWITCHTEMP.dbf'
                 SIZE 1024M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
                 
create user SWITCHTEMP identified by kingdee default tablespace SWITCHTEMP temporary tablespace TEMP profile DEFAULT;
                 
grant connect to SWITCHTEMP;
grant resource to SWITCHTEMP;
grant create view to SWITCHTEMP;

CREATE SMALLFILE TABLESPACE ICBC5 DATAFILE '/opt/oracle/oradata/ORCL/ICBC5.dbf'
                 SIZE 1024M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

create user ICBC5 identified by kingdee default tablespace ICBC5 temporary tablespace TEMP profile DEFAULT;

grant connect to ICBC5;
grant resource to ICBC5;
grant create view to ICBC5;

imp ICBC5/kingdee file = /opt/oracle/expdir/ICBC5_20100419.dmp ignore=y commit=y