oracle建临时表空间和表空间

/临时表空间/

create temporary tablespace pbzh04_temp
tempfile ‘D:\app\Administrator\oradata\orca/pbzh04_temp.dbf’
size 50m
autoextend on
next 50m maxsize 500m
extent management local;

/*创建数据表空间 */

create tablespace rjdj_data
logging
datafile ‘D:\app\Administrator\rjdj_data.dbf’
size 5000m
autoextend on
next 50m maxsize 500m
extent management local;

/创建用户/

create user rjdj
identified by “rjdj”
default tablespace rjdj_data
profile DEFAULT;
grant connect to rjdj;
grant dba to rjdj;
grant exp_full_database to rjdj;
grant imp_full_database to rjdj;
grant resource to rjdj;
grant unlimited tblespace to rjdj;

//导入
impdp pbzh04/pbzh04 dumpfile=pbzhdw20181127.dmp remap_tablespace=pbzhdw3_data:pbzh04_data remap_schema=pbzhdw3:pbzh04 table_exists_action=replace

expdp rjdjzs/rjdjzs dumpfile=pbzhdw2019121801.dmp directory=DPDATA1 tables=pbzhdw.t_po

impdp lin/root dumpfile=pbzhdw2019120401.dmp remap_schema=pbzhdw:lin table_exists_action=replace
impdp demo/testpbzhdw dumpfile= remap_schema=pbzhdw:demo remap_tablespace=pbzhdw_data:demo table_exists_action=replace
#########################################################################################################
查看drectory 的详细信息
select * from dba_directories;

impdp rjdjzs/rjdjzs dumpfile=rjdj202006081.dmp remap_schema=rjdj:rjdj remap_tablespace=ZHDW_DATA:rjdj_data table_exists_action=replace

expdp rjdj/rjdj dumpfile=rjdj20200629.dmp directory=DPDATA1 tables=rjdj.t_statistic_orgtemp_newrule

impdp rjdjzs/rjdjzs dumpfile=rjdj202006081.dmp remap_schema=rjdjzs:rjdjzs remap_tablespace=RJDJZS_DATA:rjdjzs2 table_exists_action=replace

impdp rjdj/rjdj dumpfile=rjdj2020060813.dmp remap_schema=rjdj:rjdj remap_tablespace=ZHDW_DATA:rjdj_data table_exists_action=replace

expdp rjdj/rjdj dumpfile=rjdj20200622.dmp directory=DPDATA1 tables=rjdj.t_member_base,rjdj.t_org_member_relational,rjdj.t_organization_structure,rjdj.T_ORG_MEMBER_RELATIONAL_PK1
impdp rjdj/rjdj dumpfile=rjdj20200629.dmp remap_schema=rjdj:rjdj remap_tablespace=ZHDW_DATA:rjdj_data transform=segment_attributes:n table_exists_action=replace

select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_objects b where b.object_id = a.object_id;

select b.username,b.sid,b.serial#,logon_time from v$locke{d}_{o}bjecta,v$session b where a.session_id = b.sid order by b.logon_time;

alter system kill session ‘2206,19428’;