测试全步骤:
//创建临时表空间
create temporary tablespace test_temp
tempfile 'D:\oracle\product\10.2.0\oradata\orcl\test_temp01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//创建数据表空间
create tablespace test_data
logging
datafile 'D:\oracle\product\10.2.0\oradata\orcl\test_data01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
//创建用户并指定表空间
create user test01 identified by test01
default tablespace test_data
temporary tablespace test_temp;
//给用户授予权限
grant connect,resource to test01;
//创建测试表及数据
conn test01/test01;
create table tab_test01
(
a VARCHAR2(6),
b VARCHAR2(30),
c VARCHAR2(80),
d NUMBER(4)
);
insert into tab_test01 (a,b,c,d) values ('1','2','3',4);
commit;
select * from tab_test01;
//开始迁移
SET ORACLE_SID=DB10G
SQLPLUS /NOLOG
CONN SYS/SYS AS SYSDBA;
SHUTDOWN IMMEDIATE;
(文件操作)复制(移动)数据文件至新路径
//更改路径设置
STARTUP MOUNT;
ALTER DATABASE rename FILE 'D:\oracle\product\10.2.0\oradata\orcl\test_data01.dbf' to 'D:\TEST_DATA01.DBF';
ALTER DATABASE OPEN;
//测试:往用户里面导入新数据;查看是否在新位置文件增加大小
imp test01/test01@orcl file=d:\cust.dmp ignore=y full=y
//测试通过;过程完成。
//删除本次操作的案例数据
//删除用户
drop user test01 cascade;
//删除表空间
DROP TABLESPACE test_temp INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE test_data INCLUDING CONTENTS AND DATAFILES;