ORACLE创建表空间 用户

新建用户并授权：
-- Create the user
create user SPHY identified by ffffff
  default tablespace SPHY_DATA
  temporary tablespace TEMP
  profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to SPHY;
grant dba to SPHY;
grant resource to SPHY;
-- Grant/Revoke system privileges
grant alter any table to SPHY;
grant alter tablespace to SPHY;
grant create any table to SPHY;
grant create any view to SPHY;
grant delete any table to SPHY;
grant drop any table to SPHY;
grant drop any view to SPHY;
grant select any table to SPHY;
grant unlimited tablespace to SPHY;
grant update any table to SPHY;


导sphy.dmp数据到SPHY用户下。