Liangda-w commented on a change in pull request #10214:
URL: https://github.com/apache/shardingsphere/pull/10214#discussion_r623141890
##########
File path:
shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-oracle/src/main/antlr4/imports/oracle/DDLStatement.g4
##########
@@ -1132,3 +1132,278 @@ rowArchivalVisibilityClause
defaultCollationClause
: DEFAULT_COLLATION EQ_ (collationName | NONE)
;
+
+alterDatabase
+ : ALTER DATABASE databaseName?
+ ( startupClauses
+ | recoveryClauses
+ | databaseFileClauses
+ | logfileClauses
+ | controlfileClauses
+ | standbyDatabaseClauses
+ | defaultSettingsClauses
+ | instanceClauses
+ | securityClause
+ | prepareClause
+ | dropMirrorCopy
+ | lostWriteProtection
+ | cdbFleetClauses
+ | propertyClause )
+ ;
+
+startupClauses
+ : MOUNT ((STANDBY | CLONE) DATABASE)?
+ | OPEN ((READ WRITE)? (RESETLOGS | NORESETLOGS)? (UPGRADE | DOWNGRADE)? |
READ ONLY)
+ ;
+
+recoveryClauses
+ : generalRecovery | managedStandbyRecovery | BEGIN BACKUP | END BACKUP
+ ;
+
+generalRecovery
+ : RECOVER (AUTOMATIC)? (FROM locationName)? (
+ (fullDatabaseRecovery | partialDatabaseRecovery | LOGFILE fileName)
+ ((TEST | ALLOW NUMBER_ CORRUPTION | parallelClause)+)?
+ | CONTINUE DEFAULT?
+ | CANCEL
+ )
+ ;
+
+fullDatabaseRecovery
+ : STANDBY? DATABASE
+ ((UNTIL (CANCEL | TIME dateValue | CHANGE NUMBER_ | CONSISTENT)
+ | USING BACKUP CONTROLFILE
+ | SNAPSHOT TIME dateValue
+ )+)?
+ ;
+
+dateValue
+ : dateTimeLiterals | stringLiterals | numberLiterals | expr
+ ;
+
+partialDatabaseRecovery
+ : TABLESPACE tablespaceName (COMMA_ tablespaceName)*
+ | DATAFILE (fileName | fileNumber) (COMMA_ (fileName | fileNumber))*
+ ;
+
+managedStandbyRecovery
+ : RECOVER (MANAGED STANDBY DATABASE
+ ((USING ARCHIVED LOGFILE | DISCONNECT (FROM SESSION)?
+ | NODELAY
+ | UNTIL CHANGE NUMBER_
+ | UNTIL CONSISTENT | USING INSTANCES (ALL | NUMBER_) | parallelClause)+
+ | FINISH | CANCEL)?
+ | TO LOGICAL STANDBY (databaseName | KEEP IDENTITY))
+ ;
+
+databaseFileClauses
+ : RENAME FILE fileName (COMMA_ fileName)* TO fileName
+ | createDatafileClause
+ | alterDatafileClause
+ | alterTempfileClause
+ | moveDatafileClause
+ ;
+
+createDatafileClause
+ : CREATE DATAFILE (fileName | fileNumber) (COMMA_ (fileName | fileNumber))*
+ ( AS (fileSpecification (COMMA_ fileSpecification)* | NEW))?
+ ;
+
+fileSpecification
+ : datafileTempfileSpec | redoLogFileSpec
+ ;
+
+datafileTempfileSpec
+ : (fileName | asmFileName )? (SIZE sizeClause)? REUSE? autoextendClause?
+ ;
+
+autoextendClause
+ : AUTOEXTEND (OFF | ON (NEXT sizeClause)? maxsizeClause?)
+ ;
+
+redoLogFileSpec
+ : ((fileName | asmFileName)
+ | LP_ (fileName | asmFileName) (COMMA_ (fileName | asmFileName))* RP_)?
+ (SIZE sizeClause)? (BLOCKSIZE sizeClause)? REUSE?
+ ;
+
+alterDatafileClause
+ : DATAFILE (fileName | NUMBER_) (COMMA_ (fileName | NUMBER_))*
+ (ONLINE | OFFLINE (FOR DROP)? | RESIZE sizeClause | autoextendClause | END
BACKUP | ENCRYPT | DECRYPT)
+ ;
+
+alterTempfileClause
+ : TEMPFILE fileName (COMMA_ fileName )*
+ (RESIZE sizeClause | autoextendClause | DROP (INCLUDING DATAFILES)? |
ONLINE | OFFLINE)
+ ;
+
+logfileClauses
+ : ((ARCHIVELOG MANUAL? | NOARCHIVELOG )
+ | NO? FORCE LOGGING
+ | SET STANDBY NOLOGGING FOR (DATA AVAILABILITY | LOAD PERFORMANCE)
+ | RENAME FILE fileName (COMMA_ fileName)* TO fileName
+ | CLEAR UNARCHIVED? LOGFILE logfileDescriptor (COMMA_ logfileDescriptor)*
(UNRECOVERABLE DATAFILE)?
+ | addLogfileClauses
+ | dropLogfileClauses
+ | switchLogfileClause
+ | supplementalDbLogging)
+ ;
+
+logfileDescriptor
+ : GROUP NUMBER_ | LP_ fileName (COMMA_ fileName)* RP_ | fileName
+ ;
+
+addLogfileClauses
+ : ADD STANDBY? LOGFILE
+ (((INSTANCE instanceName)? | (THREAD SQ_ NUMBER_ SQ_)?)
Review comment:
Okay, I didn't looked at the illustration. It seems that the document is
not consistent at some points 😕
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
