创建表空间 ts_name
create tablespace WLCS datafile '+data01' size 30G;
alter tablespace WLCS add datafile '+data01' size 30G autoextend on;
创建用户
create user fsp_gzwfm identified by Lc_fsp_gzwfm_17 default tablespace WLCS;
grant dba to xjtm;
导出
expdp fsp_gzwfm/Lc_fsp_gzwfm_17@10.235.34.93:1521/jkywdbdg directory=bakdir dumpfile=fsp_gzwfm20230901.dmp compression=all TABLES=fsp_gzwfm.JK_QUALITY_PICTURE --若不是单独备份某张表,忽略 TABLES选项
导入
impdp fsp_gzwfm/Lc_fsp_gzwfm_17@10.235.34.93:1521/jkywdbdg directory=bakdir dumpfile=fsp_gzwfm20230901.dmp schemas=fsp_gzwfm content=all table_exists_action=replace
--导入时dmp文件的权限调整为oracle:oinstall
创建备份空间
create or replace directory bakdir as '/u01/backup'
查看备份空间
select * from dba_directories;