Importing and exporting Oracle scenarios is the main theme of backup and recovery, not DBAs, and there's not much research on importing and exporting data, just a little bit of experience in the process of using it.
Import
Copy Code code as follows:
Imp XZFY_MASTER/XZFY@ORCL file=d:\master0312.dmp full=y;
Here full=y must write, is to import the whole scheme again. And a semicolon must be there otherwise not executed.
Export
Copy Code code as follows:
Exp XZFY_EFMWEB/XZFY@ORCL FILE=D:\XZFY_EFMWEB0312.DMP
The export process is relatively simple, do not need other parameter configuration, directly to the entire scheme export, note that the semicolon must not be added, and then DMP file extension becomes the ". DMP;". But this also does not affect the use, only needs to go to the disk to remove that extra semicolon to be possible, the data has nothing to damage. But it may make you feel confused, the use of data files in any case can not find, in fact, is more than a semicolon.
In fact, this aspect of the content is quite a bit, today looked at the step-by-step eygle Oracle, Backup and recovery is also a big chapter, and now there is no excessive energy research, here is the first, as a record.
