Remember an Oracle Database migration deployment

1 --20,141,230 Deployment scripts (from top to bottom in chronological order)2 3 4 --command line, export the database data to be deployed (no semicolon)5 --EXPDP rmb3/[email protected] schemas=rmb3 directory=expdir dumpfile=20141230.dmp logfile=20141230.log6     --comment on the sentence:7     --expdp:cmd command (i.e. an EXE program under win)8     --Rmb3/[email protected]: username/password @ Local Service naming (local service naming SID in Netmanager, not that global service name)9     --SCHEMAS=RMB3: SCHEMAS of the user to exportTen     --Directory : Export file storage directory One     --dumpfile: Generated DMP file name (with extension) A     --logfile: Log file name -  -      the --If the overwrite deployment needs to be removed by user and tablespace - --drop user $ cascade; - --drop tablespace RMB including contents and datafiles; -  + --Create or replace directory Exp_dir as ' D:\app\Administrator\exp_dir ';--Specify a directory to hold the export file for the database - --Grant Read,write on directory Exp_dir to sys;--gives a user authorization to access the specified directory +  A --New Table Space at --Specifies the dbf file directory for the new tablespace, typically stored in the Oradata directory of the Oracle installation directory - CREATEtablespace RMB - LOGGING -DataFile'D:\app\Administrator\oradata\orcl\RMB.DBF'   - SIZE 50M -Autoextend on  in NEXT32M MAXSIZE UNLIMITED - EXTENT MANAGEMENT LOCAL; to  + --Create a new user and specify a table space - Create User$ identified bytest123 the DEFAULTtablespace RMB; *  $ --authorizing a new userPanax Notoginseng GrantConnect,resource toRMB; - Grant CreateSession,dba toRMB; the --Reclaim RMB user permissions to manipulate all tablespaces + RevokeUnlimited tablespace fromRMB; A --Modify user The quota limit for the RMB in the tablespace is "unlimited" the Alter User$ quota Unlimited onRMB; +  - --command line, importing data for new users (no semicolon) $ --IMPDP rmb/[email protected] schemas=rmb3 exclude=user REMAP_TABLESPACE=RMB3:RMB REMAP_SCHEMA=RMB3:RMB directory= Exp_dir dumpfile=20141230.dmp Logfile=20141230imp.log $     --comment on the sentence: -     --impdp:cmd command (i.e. an EXE program for win) -     --SCHEMAS: Source SCHEMAS to import the     --exclude: Excluding specific objects -     --REMAP_TABLESPACE=RMB3:RMB: Modify user tablespace (source table space: Destination tablespace)Wuyi     --Remap_schema: Modify user Schema (source schema: Destination schema), meaning to move user data from the source schema to the destination schema the     --DumpFile: The name of the data file to import -     --logfile: File name of the import log Wu  -      About --Supplement $ --View all table spaces - Select *  fromdba_tablespaces; - --View information for the RMB table space - Select file_name, Tablespace_name fromDba_data_fileswhereTablespace_name='RMB'; A --View all Catalogs + Select *  fromDba_directories;

Remember an Oracle Database migration deployment