导出、导入 兼容版本命令 仅支持11G
expdp esb/111@esb dumpfile=gylwl_db1.dmp EXCLUDE=TABLE:\"IN 'T_SYS_111'\" TABLESPACES=111 DIRECTORY=DATA_PUMP_DIR version=10.2.0.3.0
impdp esb/111@esb directory=DATA_PUMP_DIR dumpfile=gylwl.dmp version=10.2.0.3.0
导出、导入基本命令
exp esb/1111@ESB owner=esb file='f:\esb.dmp'
imp esb/1111@ESB
file='f:\esb.dmp' FULL=Y
--查看表空间文件路径
select tablespace_name,file_id,bytes/1024/1024,file_name
from dba_data_files order by file_id;
//创建数据表空间
create tablespace kettle
logging
datafile 'D:\oracle\product\10.2.0\oradata\orcl\kettle.dbf'
size 1024m
autoextend on
next 1024m maxsize 10240m
extent management local;
select tablespace_name,file_id,bytes/1024/1024,file_name
from dba_data_files order by file_id;
//创建数据表空间
create tablespace kettle
logging
datafile 'D:\oracle\product\10.2.0\oradata\orcl\kettle.dbf'
size 1024m
autoextend on
next 1024m maxsize 10240m
extent management local;
创建临时表空间
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE ' C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf '
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
//创建用户并指定表空间
create user testserver_user identified by testserver_user
default tablespace test_data
temporary tablespace test_temp;
//给用户授予权限
grant connect,resource to testserver_user;