oracle 导入 dmp

最新推荐文章于 2023-10-09 14:40:39 发布

机灵小桶桶

最新推荐文章于 2023-10-09 14:40:39 发布

阅读量355

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/baidu_34464794/article/details/54378916

版权

oracle 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

drop user IVR_ANALYSIS cascade// user_name :IVR_ANALYSIS
create user IVR_ANALYSIS IDENTIFIED by "password"
grant connect,resource,dba to IVR_ANALYSIS;//授权
create tablespace CSS_APP // tablespace_name:CSS_APP
datafile 'E:/oracle_tablespaces/CSS_APP.dbf'
size 1500M
autoextend on next 5M maxsize 3000M;
alter user IVR_ANALYSIS quota unlimited on CSS_APP

cmd 下导入dmp

imp IVR_ANALYSIS/password@127.0.0.1/orcl fromuser=IVR_ANALYSIS touser=IVR_ANALYSIS file=dmp路径 ignore=y

SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size
FROM dba_tablespaces t, dba_data_files d
WHERE t.tablespace_name = d.tablespace_name
GROUP BY t.tablespace_name;

SELECT SUM(bytes) / (1024 * 1024) AS free_space, tablespace_name
FROM dba_free_space
GROUP BY tablespace_name;

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

alter database datafile 'E:\\APP\\160429\\ORADATA\\ORCL\\USERS01.DBF' resize 500m;