CREATE TABLESPACE "WATF" DATAFILE 'D:\app\Administrator\oradata\orcl\WATF.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE USER WATF IDENTIFIED BY WATF PROFILE DEFAULT DEFAULT TABLESPACE "WATF" TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK;
3,--给用户赋予权限
grant DBA to WATF;
4, 删除user
drop user username cascade;
5, 删除表空间
DROP TABLESPACE watf INCLUDING CONTENTS AND DATAFILES;
6,修改表空间用户密码
--alter user WATF identified by WATF;
7, 导出表结构及数据:
exp SYQ/SYQ@192.168.1.252/orcl tables=(EXT_REPORTCONFIG_INFO, EXT_REPORTCONFIG_METADATA, EXT_REPORTCONFIG_VALUE) rows=y grants=N TRIGGERS=N compress=N file=C:\SYQ_reportconfig.dmp
注意:tables和owner不能同时使用。
8, 导入\导出表结构及数据
imp SYQ/SYQ@localhost/orcl file=D:\GoldenWater\SYQ.dmp FULL=Y
exp A1301_ZWGL_R/A1301_ZWGL_R@localhost/ORCL file=C:\ZWGL.dmp grants=N TRIGGERS=N OWNER=A1301_ZWGL_R
9, EXPDP命令
(1)打开SQL>create directory dump_dir as 'd:\temp';
(2) SQL>Grant read, write on directory dump_dir to SYQ;
(3) 打开DOS, expdp SYQ/SYQ@localhost/orcl dumpfile=SYQ_2015-4-1.dmp DIRECTORY=dump_dir;