Example of oracle expdp and impdp

Example of oracle expdp and impdp: due to production requirements, you need to copy the rmtel user data to rmtel_xzy, but exclude the rmtel user ('cab _ JJXPORT_TAB ', 't_servicexx', 'tb _ crossconnection', 'tb _ link', 'tb _ card', 'tb _ PHYSICALCONTAINER ', and 'tb _ port') tables. That is to say, the data structures of these two users must be exactly the same, except for these tables. The data is stored in the rmtel_xzy tablespace. Follow these steps: 1. Use the administrator user sys to create a directory and authorize user a to query which export directories are available in the database: select * from dba_directories; B: Create the export directory: create directory RMTEL_DIR as 'd: \ rmtel_dump '; c: authorize the export directory to the operation User: grant read, write on directory RMTEL_DIR to rmtel_xzy, rmtel; 2: use the windows doc window to export rmtel data 3: Use the windows doc window to import data about the oracle expdp and impdp tools. in different environments, use the exclude and include parameter values differently. Note that if you create and execute these backup tools in the doc file in windows, you can install the above tools successfully.