SQL> CREATE CONTROLFILE REUSE DATABASE "EMREP" NORESETLOGS FORCE LOGGING ARCHIVELOG
 2     MAXLOGFILES 16
 3     MAXLOGMEMBERS 3
 4     MAXDATAFILES 100
 5     MAXINSTANCES 8
 6     MAXLOGHISTORY 292
 7 LOGFILE
 8   GROUP 1 '/u01/app/oracle/oradata/EMREP/redo01.log' SIZE 50M,
 9   GROUP 2 '/u01/app/oracle/oradata/EMREP/redo02.log' SIZE 50M,
 10   GROUP 3 '/u01/app/oracle/oradata/EMREP/redo03.log' SIZE 50M
 11 -- STANDBY LOGFILE
 12
SQL> DATAFILE
SP2-0042: unknown command "DATAFILE" - rest of line ignored.
SQL>  '/u01/app/oracle/oradata/EMREP/system01.dbf',
SP2-0734: unknown command beginning "'/u01/app/..." - rest of line ignored.
SQL>  '/u01/app/oracle/oradata/EMREP/undotbs01.dbf',
SP2-0734: unknown command beginning "'/u01/app/..." - rest of line ignored.
SQL>  '/u01/app/oracle/oradata/EMREP/sysaux01.dbf',
SP2-0734: unknown command beginning "'/u01/app/..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.
SQL>  '/u01/app/oracle/oradata/EMREP/users01.dbf',
SP2-0734: unknown command beginning "'/u01/app/..." - rest of line ignored.
SQL>  '/u01/app/oracle/oradata/EMREP/example01.dbf',
SP2-0734: unknown command beginning "'/u01/app/..." - rest of line ignored.
SQL>  '/u01/app/oracle/oradata/EMREP/goldengate01.dbf',
SP2-0734: unknown command beginning "'/u01/app/..." - rest of line ignored.
SQL>  '/u01/app/oracle/oradata/EMREP/gguser.dbf'
SP2-0734: unknown command beginning "'/u01/app/..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.

創(chuàng)新互聯(lián)是一家集網(wǎng)站建設(shè),惠水企業(yè)網(wǎng)站建設(shè),惠水品牌網(wǎng)站建設(shè),網(wǎng)站定制,惠水網(wǎng)站建設(shè)報價,網(wǎng)絡(luò)營銷,網(wǎng)絡(luò)優(yōu)化,惠水網(wǎng)站推廣為一體的創(chuàng)新建站企業(yè)，幫助傳統(tǒng)企業(yè)提升企業(yè)形象加強企業(yè)競爭力?？沙浞譂M足這一群體相比中小企業(yè)更為豐富、高端、多元的互聯(lián)網(wǎng)需求。同時我們時刻保持專業(yè)、時尚、前沿，時刻以成就客戶成長自我，堅持不斷學(xué)習(xí)、思考、沉淀、凈化自己，讓我們?yōu)楦嗟钠髽I(yè)打造出實用型網(wǎng)站。

解決方法：

SQL> set sqlbl on

因為我們在執(zhí)行腳本的時候腳本中有空白行所以造成以上的報錯。

以下是來之文檔的解釋：

SET SQLBL[ANKLINES] {ON | OFF}

SET SQLBLANKLINES is not supported in iSQL*Plus

Controls whether SQL*Plus puts blank lines within a SQL command or script. ON interprets blank lines and new lines as part of a SQL command or script. OFF, the default value, does not allow blank lines or new lines in a SQL command or script or script.

Enter the BLOCKTERMINATOR to stop SQL command entry without running the SQL command. Enter the SQLTERMINATOR character to stop SQL command entry and run the SQL statement

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機、免備案服務(wù)器”等云主機租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務(wù)可用性高、性價比高”等特點與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場景需求。

當(dāng)前名稱：重建控制文件報錯-創(chuàng)新互聯(lián)
當(dāng)前網(wǎng)址：http://weahome.cn/article/dcggdc.html