1.新建用户
create user dpm_common identified by dpm_common ;
grant connect,resource,dba to dpm_common; -- 授权
drop user dpm_common; -- 删除用户
2.导入数据库
impdp dpm_common/dpm_common@avidm directory=DATA_PUMP_DIR DUMPFILE=AVDPM060011_20210615.dmp remap_schema=AVDPM060011:dpm_common
-- 注释:
-- impdp 用户名/密码@数据库连接名 directory=文件放置目录 DUMPFILE=文件名 remap_schema=原数据库名:新数据库名
select * from dba_directories t; -- 查看目录
-- 创建用户并设置表空间:
create tablespace AVIDM LOGGING DATAFILE 'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\TEST_DATA01.DBF'
create user dpm_common identified by dpm_common default tablespace PLM;
select * from dba_data_files -- 查看表空间物理位置