以兩次 ORACLE IMPORT 解決 IMPORT 時 CREATE VIEW,FUNCTION 失敗的問題

以兩次 ORACLE IMPORT 解決 IMPORT 時 CREATE VIEW,FUNCTION 失敗的問題
ORACLE Import twice to solve the problem
that Create View Fail in Import

Iimport Data Usually With User one by one,
However, the situation will encounter some failures,
In Create View, fcunction ...

Create View Fail by reference Table to import yet
Twice Import to solve the problem

PASS1 STANDARD IMPORT

IMP USR_A/USR_A@ORCL FILE=C:\USR_A.DMP FULL=Y BUFFER=1024000 LOG=C:\IMP_P1_USR_A.LOG
IMP USR_B/USR_B@ORCL FILE=C:\USR_B.DMP FULL=Y BUFFER=1024000 LOG=C:\IMP_P1_USR_B.LOG
IMP USR_C/USR_C@ORCL FILE=C:\USR_C.DMP FULL=Y BUFFER=1024000 LOG=C:\IMP_P1_USR_C.LOG

PASS2 IMPORT USE SKILL FOR LOSS VIEW FUNCTION.....

IMP USR_A/USR_A@ORCL FILE=C:\USR_A.DMP IGNORE=Y ROWS=N STATISTICS=NONE FULL=Y BUFFER=1024000 LOG=C:\IMP_P2_USR_A.LOG
IMP USR_B/USR_B@ORCL FILE=C:\USR_B.DMP IGNORE=Y ROWS=N STATISTICS=NONE FULL=Y BUFFER=1024000 LOG=C:\IMP_P2_USR_B.LOG
IMP USR_C/USR_C@ORCL FILE=C:\USR_C.DMP IGNORE=Y ROWS=N STATISTICS=NONE FULL=Y BUFFER=1024000 LOG=C:\IMP_P2_USR_C.LOG