Precautions for oracle Import and Export

Precautions for oracle Import and Export: The oracle Import and Export solution is the main melody of backup and reply, not dba. There is not much research on data import and export, and there is only a little bit of experience in the use process, here is a brief description. Import www.2cto.com [SQL] imp xzfy_master/xzfy @ orcl file = d: \ master0312.dmp full = y; here full = y must be written, that is, to import the entire solution. There must be semicolons. Otherwise, they will not be executed. Export [SQL] exp xzfy_efmweb/xzfy @ orcl file = d: \ xzfy_efmweb0312.dmp. The export process is relatively simple. You can directly export the entire solution without configuring other parameters, note that the semicolon must not be added. The dmp file extension is changed ". dmp ;". However, this does not affect usage. You only need to remove the extra semicolon from the disk, and the data is not damaged. However, it may confuse you. When you use a data file, you cannot find it. In fact, there is an extra semicolon. There are actually a lot of content in this regard. Today I have read about the step-by-step oracle of eygle, and backup and recovery are also a big chapter. Now I have not focused much on it. Let's do it first, it should be recorded.