--创建表空间 Test
create tablespace TEST
datafile 'D:\app\liangzhuang\product\11.2.0\oradata\New.dbf'
size 20M
reuse
autoextend on
next 5M
maxsize unlimited
LOGGING
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON;
创建用户
create user username
identified by "pass"
default tablespace TEST
temporary tablespace temp;
--赋予权限 connect 、resource 、dba
grant connect to username;
grant resource to username;
grant dba to username;
--导入表数据
Imp username/pass@crcl file=E:\DB\j.dmp full=y log=E:\DB\j.txt
--倒出表数据
exp username/pass@crcl file=E:\DB\j.dmp full=y log=E:\DB
oracle 导入导出表
最新推荐文章于 2024-07-02 17:08:54 发布