Matters needing attention and sharing of experience in importing and exporting oracle
- 2021-10-11 19:54:55
- OfStack
Import and export oracle scheme is the main theme of backup and recovery, not dba. There is not much research on data import and export, only 1 point of experience in the use process, which is briefly explained here.
Import
Here full=y1 must be written, that is, to import the whole scheme. There is also a semicolon 1, which must be there or it will not be executed.
Export
The export process is relatively simple, and no other parameter configuration is needed. The whole scheme is exported directly. Note that semicolon 1 should not be added, and the extension of dmp file becomes ". dmp; ". However, this does not affect the use, just to the disk to remove the redundant semicolon can, the data is not damaged. But it may make you feel confused. When you use the data file again, you can't find it anyway. In fact, there is an extra semicolon.
In fact, there are quite a lot of contents in this respect. Today, I read the gradual oracle of eygle, and backup and recovery is also a big chapter. Now I don't have too much energy to study it. Let's do this first, just take it as a record.
Import
imp xzfy_master/xzfy@orcl file=d:\master0312.dmp full=y;
Here full=y1 must be written, that is, to import the whole scheme. There is also a semicolon 1, which must be there or it will not be executed.
Export
exp xzfy_efmweb/xzfy@orcl file=d:\xzfy_efmweb0312.dmp
The export process is relatively simple, and no other parameter configuration is needed. The whole scheme is exported directly. Note that semicolon 1 should not be added, and the extension of dmp file becomes ". dmp; ". However, this does not affect the use, just to the disk to remove the redundant semicolon can, the data is not damaged. But it may make you feel confused. When you use the data file again, you can't find it anyway. In fact, there is an extra semicolon.
In fact, there are quite a lot of contents in this respect. Today, I read the gradual oracle of eygle, and backup and recovery is also a big chapter. Now I don't have too much energy to study it. Let's do this first, just take it as a record.