Oracle Data Import

zhaozj2021-02-16  161

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. 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

转载请注明原文地址:https://www.9cbs.com/read-7997.html

New Post(0)