users

select * from all_users;

create schema(users)

select tablespace_name from user_tablespaces;

select USERNAME, DEFAULT_TABLESPACE from DBA_USERS;

select USERNAME, DEFAULT_TABLESPACE from DBA_USERS where DEFAULT_TABLESPACE = 'DEV_DB';

create tablespace

conn fxwl/fxwl
select USERNAME, DEFAULT_TABLESPACE from DBA_USERS;

CREATE TABLESPACE  EAS_D_FXWL_STANDARD
    DATAFILE '+SSD_DATA' SIZE 30G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    LOGGING
    ONLINE
    SEGMENT SPACE MANAGEMENT AUTO
    /

create user fxwl identified by fxwl default tablespace EAS_D_FXWL_STANDARD quota unlimited on EAS_D_FXWL_STANDARD;

create user fxwlq identified by fxwlq default tablespace users quota unlimited on users;

grant dba to fxwl;

impdp \"system as sysdba\" schemas=fxwl directory=dump_dir dumpfile=FXWL_201611030600.DMP logfile=impdpFrom11.2.0.1.log table_exists_action=replace parfile=dmp.txt cluster=n

SQL> select name from v$tempfile;

NAME
-----------------------------------------------------------
D:\ORACLE\ORADATA\FXWL\TEMP01.DBF

SQL> select name from v$datafile;

NAME
-----------------------------------------------------------
D:\ORACLE\ORADATA\FXWL\SYSTEM01.DBF
D:\ORACLE\ORADATA\FXWL\SYSAUX01.DBF
D:\ORACLE\ORADATA\FXWL\UNDOTBS01.DBF
D:\ORACLE\ORADATA\FXWL\USERS01.DBF
D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD101.ORA
D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD102.ORA
D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD103.ORA
D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD104.ORA
D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD105.ORA
D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD106.ORA
D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD107.ORA

NAME
-----------------------------------------------------------
D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_TEMP2101.ORA
D:\ORACLE\ORADATA\FXWL\EAS_T_FXWL_STANDARD101.ORA

已选择13行。

SQL>

dump.txt

remap_datafile="'D:/ORACLE/ORADATA/FXWL/SYSTEM01.DBF':'+DATA'"
remap_datafile="'D:/ORACLE/ORADATA/FXWL/SYSAUX01.DBF':'+DATA'"
remap_datafile="'D:/ORACLE/ORADATA/FXWL/UNDOTBS01.DBF':'+DATA'"
remap_datafile="'D:/ORACLE/ORADATA/FXWL/USERS01.DBF':'+DATA'"
remap_datafile="'D:/ORACLE/ORADATA/FXWL/EAS_D_FXWL_STANDARD101.ORA':'+DATA'"
remap_datafile="'D:/ORACLE/ORADATA/FXWL/EAS_D_FXWL_STANDARD102.ORA':'+DATA'"
remap_datafile="'D:/ORACLE/ORADATA/FXWL/EAS_D_FXWL_STANDARD103.ORA':'+DATA'"
remap_datafile="'D:/ORACLE/ORADATA/FXWL/EAS_D_FXWL_STANDARD104.ORA':'+DATA'"
remap_datafile="'D:/ORACLE/ORADATA/FXWL/EAS_D_FXWL_STANDARD105.ORA':'+DATA'"
remap_datafile="'D:/ORACLE/ORADATA/FXWL/EAS_D_FXWL_STANDARD106.ORA':'+DATA'"
remap_datafile="'D:/ORACLE/ORADATA/FXWL/EAS_D_FXWL_STANDARD107.ORA':'+DATA'"


'D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_TEMP2101.ORA':'+SSD_DATA'
'D:\ORACLE\ORADATA\FXWL\EAS_T_FXWL_STANDARD101.ORA':'+SSD_DATA'

 impdp \"system as sysdba\" schemas=fxwl directory=dump_dir dumpfile=FXWL_201611030600.DMP logfile=impdpFrom11.2.0.1.log table_exists_action=replace  cluster=n remap_datafile='D:\ORACLE\ORADATA\FXWL\SYSTEM01.DBF':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\SYSAUX01.DBF':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\UNDOTBS01.DBF':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\USERS01.DBF':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD101.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD102.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD103.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD104.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD106.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD107.ORA':'+SSD_DATA'

full with replace table_exists_action

 impdp \"system as sysdba\" full=y directory=dump_dir dumpfile=FXWL_FULL_DATA_BACKUP.DMP logfile=1101.1156impdpFrom11.2.0.1_full.log table_exists_action=replace  cluster=n remap_datafile='D:\ORACLE\ORADATA\FXWL\SYSTEM01.DBF':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\SYSAUX01.DBF':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\UNDOTBS01.DBF':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\USERS01.DBF':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD101.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD102.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD103.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD104.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD106.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD107.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_TEMP2101.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_T_FXWL_STANDARD101.ORA':'+SSD_DATA'

full

 impdp \"system as sysdba\" full=y directory=dump_dir dumpfile=FXWL_FULL_DATA_BACKUP.DMP logfile=1101.1156impdpFrom11.2.0.1_full.log remap_datafile='D:\ORACLE\ORADATA\FXWL\SYSTEM01.DBF':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\SYSAUX01.DBF':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\UNDOTBS01.DBF':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\USERS01.DBF':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD101.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD102.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD103.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD104.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD106.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD107.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_TEMP2101.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_T_FXWL_STANDARD101.ORA':'+SSD_DATA'

schemas

 impdp \"system as sysdba\" schemas=fxwl directory=dump_dir dumpfile=FXWL_201611030600.DMP logfile=1104.1325impdpFrom11.2.0.1_schemas.log remap_datafile='D:\ORACLE\ORADATA\FXWL\SYSTEM01.DBF':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\SYSAUX01.DBF':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\UNDOTBS01.DBF':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\USERS01.DBF':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD101.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD102.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD103.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD104.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD106.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_STANDARD107.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_D_FXWL_TEMP2101.ORA':'+SSD_DATA','D:\ORACLE\ORADATA\FXWL\EAS_T_FXWL_STANDARD101.ORA':'+SSD_DATA'

select count(table_name) from user_tables;