删除用户和表空间impdp重新导入数据

最新推荐文章于 2024-06-21 11:28:43 发布

sxj1069425501

最新推荐文章于 2024-06-21 11:28:43 发布

阅读量3.9k

点赞数

分类专栏： ORACLE技术类文章标签： dba oracle 数据库

本文链接：https://blog.csdn.net/songxuejuan/article/details/24019895

版权

ORACLE技术类专栏收录该内容

16 篇文章 0 订阅

订阅专栏

drop user kleas cascade;

DROP TABLESPACE tablespace_name INCLUDING CONTENTS AND DATAFILES;

如果其他表空间中的表有外键等约束关联到了本表空间中的表的字段，就要加上CASCADE CONSTRAINTS

drop tablespace tablespace_name including contents and datafiles CASCADE CONSTRAINTS;

create user test identified by test
default tablespace test_data
temporary tablespace test_temp;

alter user default tablespace test;

select username,default_tablespace from dba_users;

grant connect,resource,dba to test;

创建表空间
create tablespace user_data
logging
datafile
'/data/zmdata/user_data01.dbf' size 50m reuse autoextend on next 50m maxsize 1000M,
'/data/zmdata/user_data02.dbf' size 50m reuse autoextend on next 50m maxsize 1000M
extent management local
segment space management auto;

alter tablespace test add datafile 'd:\app\administrator\oradata\kldb\kldb04.dbf' size 100m;

alter database datafile 'd:\app\administrator\oradata\kldb\kldb04.dbf' autoextend on next 2g maxsize 10g;

alter database datafile 'd:\app\kldb01.dbf' resize 10g;

alter database datafile 'd:\app\kldb01.dbf' offline drop;

rm 操作系统中的d:\app\kldb01.dbf 文件

alter tablespace tablespace_name drop datafile file_name;

select file_id,file_name,tablespace_name from dba_data_files where tablespace_name='USERS';

impdp klform/klform@kldb directory=dmp_dir dumpfile=Klform_2014_04_08_00_00_06.dmp schemas=klform;