oracle创建用户和表空间

–创建表空间
CREATE TABLESPACE HH_DATA01 DATAFILE ‘D:\oracle\huihuasql\hh_data01.dbf’ SIZE 5000M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;
–删除表空间
drop tablespace HH_DATA01 including contents and datafiles cascade constraint;
–创建用户
CREATE USER HHD63 IDENTIFIED
BY HZ_JZ63_tax DEFAULT TABLESPACE NNC_DATA01 TEMPORARY TABLESPACE temp;
–删除用户
drop user HHD63 cascade;
–授权给用户
GRANT connect,dba to HHD63;

–创建目录
create or replace directory expdp_dir_tax as ‘D:\data\HZ_JZ63_tax’;

–授权给目录
grant read,write on directory expdp_dir_tax to HZ_JZ63_tax;