CREATE tablespace MES_PRD logging DATAFILE'/u01/app/oracle/oradata/mesorcl/MES_PRD_DATA.DBF' size 10240m autoextend on next 1000m;
alter tablespace MES_PRD add DATAFILE'/u01/app/oracle/oradata/mesorcl/MES_PRD_DATA01.DBF' size 10240m autoextend on next 1000m;
alter tablespace MES_PRD add DATAFILE'/u01/app/oracle/oradata/mesorcl/MES_PRD_DATA02.DBF' size 10240m autoextend on next 1000m;
alter tablespace MES_PRD add DATAFILE'/u01/app/oracle/oradata/mesorcl/MES_PRD_DATA03.DBF' size 10240m autoextend on next 1000m;
alter tablespace MES_PRD add DATAFILE'/u01/app/oracle/oradata/mesorcl/MES_PRD_DATA04.DBF' size 10240m autoextend on next 1000m;
alter tablespace MES_PRD add DATAFILE'/u01/app/oracle/oradata/mesorcl/MES_PRD_DATA05.DBF' size 10240m autoextend on next 1000m;
alter tablespace MES_PRD add DATAFILE'/u01/app/oracle/oradata/mesorcl/MES_PRD_DATA06.DBF' size 10240m autoextend on next 1000m;
alter tablespace MES_PRD add DATAFILE'/u01/app/oracle/oradata/mesorcl/MES_PRD_DATA07.DBF' size 10240m autoextend on next 1000m;
alter tablespace MES_PRD add DATAFILE'/u01/app/oracle/oradata/mesorcl/MES_PRD_DATA08.DBF' size 10240m autoextend on next 1000m;
alter tablespace MES_PRD add DATAFILE'/u01/app/oracle/oradata/mesorcl/MES_PRD_DATA09.DBF' size 10240m autoextend on next 1000m;
CREATE tablespace MES_MM logging DATAFILE'/u01/app/oracle/oradata/mesorcl/MES_MM_DATA.DBF' size 10240m autoextend on next 1000m;
CREATE temporary tablespace MES_MM_TEMP tempfile '/u01/app/oracle/oradata/mesorcl/MES_MM_TEMP.DBF' size 10240m autoextend on next 1000m;
CREATE temporary tablespace MES_PRD_TEMP_NEW tempfile '/u01/app/oracle/oradata/mesorcl/MES_PRD_TEMP_NEW.DBF' size 10240m autoextend on next 1000m;
CREATE temporary tablespace MES_PRD_TEMP_NEW tempfile '/u01/app/oracle/oradata/mesorcl/MES_PRD_TEMP_NEW.DBF' size 10240m autoextend on next 1000m
create user mes_bz identified by "123" default tablespace MES_PRD temporary tablespace MES_PRD_TEMP_NEW profile DEFAULT;
create directory backup_mes as '/u01/backup';
grant read,write on directory backup_mes to mes_bz;
grant connect,dba,resource to mes_bz;
grant unlimited tablespace to mes_bz with admin option;
impdp system/**** dumpfile=20210404-LLL.DMP logfile=20210404-LLL.impdp.log DIRECTORY=backup_prd SCHEMAS=mes_bz EXCLUDE=STATISTICS
文章评论