oracle 导入导出

CREATE TABLESPACE LCZYM
LOGGING
DATAFILE 'G:YM_DBLCZYM.ora' SIZE 1000M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

导出 

exp 用户名/密码@数据库 file=路径 owner=用户名  log=c:orabackuphkbfull.log

删除此用户所有对象

drop user emis cascade;

创建用户 

CREATE USER emis PROFILE DEFAULT 

IDENTIFIED BY emis DEFAULT TABLESPACE emis
TEMPORARY TABLESPACE temp
QUOTA UNLIMITED
ON emis
ACCOUNT UNLOCK;
GRANT CONNECT TO emis;
GRANT DBA TO emis;

导入

 imp system/manager@TEST  file=d:daochu.dmp full=y

查看目录Directory位置

select * from dba_directories;

创建目录

CONNECT system/manager  
CREATE OR REPLACE DIRECTORY my_dir as 'D:DataPump'; //修改创建 
CREATE OR REPLACE DIRECTORY my_logdir as 'E:logs';  

GRANT read, write ON DIRECTORY my_dir TO scott;  
GRANT read, write ON DIRECTORY my_logdir TO scott;

 SQL> CREATE OR REPLACE DIRECTORY LZFXMIS1_DIR as 'G:Gongsi....数据库';

CMD>Expdp LZFXMIS1/LZFXMIS1 DIRECTORY=LZFXMIS1_DIR DUMPFILE=LZFXMIS1.dmp SCHEMAS=LZFXMIS1

cmd>impdp LZFXMIS1/LZFXMIS1@LZFXMIS1 schemas=LZFXMIS1dumpfile =LZFXMIS1.dmp logfile=LZFXMIS1.log directory=LZFXMIS1_DIR job_name=my_job

 ==========================

----------------auto_imp.bat-------------------

sqlplus /nolog @D:ackupauto_imp.sql
imp emis/emis@orcl  file=D:ackuporacle%date:~0,4%-%date:~5,2%-%date:~8,2%.dmp log=D:ackuporacle%date:~0,4%-%date:~5,2%-%date:~8,2%.log full=y ignore=Y

----------------auto_imp.sql--------------

conn / as sysdba;
drop user emis cascade;
CREATE USER emis  PROFILE DEFAULT
    IDENTIFIED BY emis DEFAULT TABLESPACE emis
    TEMPORARY TABLESPACE temp
    QUOTA UNLIMITED
    ON emis
    ACCOUNT UNLOCK;
GRANT CONNECT TO emis;
GRANT DBA TO emis;
exit

--------------------------------

扩展表空间

 alter database datafile 'E:dongBEMISDBBEMIS.ORA' autoextend on next 100m maxsize 20480m;