--登陆sys
sqlplus /nolog;
connect / as sysdba;
--alter user sys identified by Jacjqwl123;
create user user_Name identified by pass;
create tablespace tablespace_name datafile
'd:\oracle\admin\orcl\fdj_data.dbf' size 6000M;
alter user user_Name default tablespace tablespace_name;
grant create session,create table,create view,create sequence,
unlimited tablespace to user_Name;
select * from dba_directories
grant read,write on directory DATA_PUMP_DIR to user_Name;
--cmd:
expdp user_Name/pass directory=DATA_PUMP_DIR
dumpfile=database_001.dmp logfile=database_001.log
impdp user_Name/pass directory=DATA_PUMP_DIR dumpfile=database_001.DMP