oracle 00103错误,记住这个错误PLS-00103: 出现符号

最新推荐文章于 2023-11-06 13:31:38 发布

琳檬

最新推荐文章于 2023-11-06 13:31:38 发布

阅读量5.4k

点赞数 2

文章标签： oracle 00103错误

SQL> DECLARE

2 devtype varchar2(256);

3 done boolean;

4 BEGIN

5 devtype:=sys.dbms_backup_restore.deviceAllocate (type=>'',ident=>'t1');

6 sys.dbms_backup_restore.restoreSetDatafile;

7 sys.dbms_backup_restore.restoredatafileto(dfnumber=>01,toname=>'D:ORACLEORADATAORA9ISYSTEM01.DBF');

8 sys.dbms_backup_restore.restoredatafileto(dfnumber=>02,toname=>'d:oracleoradataora9iUNDOTBS1.DBF');

9 sys.dbms_backup_restore.restoredatafileto(dfnumber=>03,toname=>'d:oracleoradataora9iDRSYS01.DBF');

10 sys.dbms_backup_restore.restoredatafileto(dfnumber=>04,toname=>'d:oracleoradataora9iEXAMPLE01.DBF');

11 sys.dbms_backup_restore.restoredatafileto(dfnumber=>05,toname=>'d:oracleoradataora9iINDX01.DBF');

12 sys.dbms_backup_restore.restoredatafileto(dfnumber=>06,toname=>'d:oracleoradataora9iTOOLS01.DBF');

13 sys.dbms_backup_restore.restoredatafileto(dfnumber=>07,toname=>'d:oracleoradataora9iUSERS01.DBF');

14 sys.dbms_backup_restore.restoredatafileto(dfnumber=>08,toname=>'d:oracleoradataora9iXDB01.DBF');

15 sys.dbms_backup_restore.restoredatafileto(dfnumber=>09,toname=>'d:oracleoradataora9iTEST02.DBF');

16 sys.dbms_backup_restore.restoredatafileto(dfnumber=>10,toname=>'d:oracleoradataora9iUSERS03.DBF');

17 sys.dbms_backup_restore.restoreBackupPiece(done=>done,handle=>'D:ORACLEORA92DATABASEKKBSNLS_1_1', params=>null);

18 sys.dbms_backup_restore.deviceDeallocate;

19 END；

20 /

END；

ERROR 位于第 19 行:

ORA-06550: 第 19 行, 第 5 列:

PLS-00103: 出现符号 "；"在需要下列之一时：

;

做事还要认真和细心，就他奶奶的一个破'；',玩的我够惨阿。

我再罗嗦一句：经验他祖宗是教训。[@more@]

关注