|
Size: 2238
Comment:
|
Size: 2284
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 31: | Line 31: |
| impdp \"system as sysdba\" schemas=fxwl directory=dump_dir dumpfile=FXWL_201611030600.DMP logfile=impdpFrom11.2.0.1.log table_exists_action=replace | 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 |
| Line 47: | Line 47: |
| dump.txt {{{ |
|
| Line 58: | Line 60: |
| }}} |
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 10000M AUTOEXTEND ON NEXT 50M 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;
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
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
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'"