Some views may bring problems during database reconstruction, because the order of structural inputs may cause the input of the view to the input of its low-level table, so that the view will fail. To solve this problem, Methods to take two steps: First enter the structure, then enter the data. The command is as follows (uesRName: JFCL, Password: HFJF, Host Sting: ORA1, Data File: Expdata.dmp):
IMP JFCL / HFJF @ ora1 file = Empdata.dmp rows = n
IMP JFCL / HFJF @ ora1 file = Empdata.dmp full = y buffer = 64000
Commit = y ignore = y
The first command enters all database structures, but there is no record. The second input structure and data, 64,000 bytes are submitted once. IGNORE = Y option ensures that the second input is only in the case of the object, it can be successful, in the case of using Import Some views may bring problems during database reconstruction, because the order of structural inputs may cause the view to enter the input of its low level table, so that the establishment view will fail. To solve this problem, you can take two minutes. Walking method: First enter the structure, then enter the data. Command is as follows (uesRName: JFCL, Password: HFJF, Host Sting: ORA1, Data): Expdata.dmp):
IMP JFCL / HFJF @ ora1 file = Empdata.dmp rows = n
IMP JFCL / HFJF @ ora1 file = Empdata.dmp full = y buffer = 64000
Commit = y ignore = y
The first command enters all database structures, but there is no record. The second input structure and data, 64,000 bytes are submitted once .Ignore = Y option guarantees that the second input is both only in the case of the object.
