【ORACLE】使用 IMP匯入檔案(以SYSDBA登入)

執行命令提示字元
輸入以下任一種方法

Code1:

Z:\>imp file=檔案路徑 show=y full=y

Import: Release 9.2.0.4.0 - Production on Thu Jul 8 18:23:15 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Username: sys as sysdba
Password:

 

 

 

Code2:

Z:\>imp file=檔案路徑 show=y full=y

Import: Release 9.2.0.4.0 - Production on Thu Jul 8 18:23:15 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Username: sys@orcl as sysdba
Password:

不能只有打SYSDBA或SYS
肯定會出錯...。