ORACLE 创建用户，表空间，导入导出实践

最新推荐文章于 2024-08-26 12:48:40 发布

置顶李文

最新推荐文章于 2024-08-26 12:48:40 发布

阅读量402

点赞数

本文链接：https://blog.csdn.net/likunwen_001/article/details/50115485

版权

drop user autek cascade;

DROP TABLESPACE sis_temp INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE sis_data INCLUDING CONTENTS AND DATAFILES;

create temporary tablespace sis_temp
tempfile '/home/oracle/app/oracle/oradata/orcl/sis_temp.dbf' size 256m reuse
autoextend on next 128m maxsize unlimited
flashback off;

create tablespace sis_data
datafile '/home/oracle/app/oracle/oradata/orcl/sis_data.dbf' size 256m reuse
autoextend on next 128m maxsize unlimited
logging
default nocompress
online
permanent
extent management local autoallocate
flashback off;

create user AUTEK identified by FLYVIDEO
default tablespace sis_data
temporary tablespace sis_temp;

grant connect,resource,dba to autek;

exp AUTEK/FLYVIDEO@10.1.212.56/orcl file=E:/kevin/沧州文档/oracle_db/bocz20151129.dmp

imp AUTEK/FLYVIDEO@127.0.0.1/orcl file=E:/kevin/沧州文档/oracle_db/bocz20151129.dmp full=y ignore=y;