Oracle及Mysql的新建用户，备份及还原

1.Oracle新建

CREATE tablespace epoint datafile 'D:\app\yu\oradata\orcl\epoint.dbf' SIZE 100M autoextend ON NEXT 50m;

CREATE USER epoint IDENTIFIED BY Gepoint DEFAULT tablespace epoint;

GRANT dba TO epoint;

 

2Mysql新建

create user "epoint"@"localhost" identified by "Gepoint";

select user();

 

3.Oracle备份还原

此文件夹下建文件夹dump

4.Mysql备份还原

 

5.远程连接