chakkk309 commented on code in PR #19537:
URL: https://github.com/apache/shardingsphere/pull/19537#discussion_r931362560
##########
shardingsphere-sql-parser/shardingsphere-sql-parser-dialect/shardingsphere-sql-parser-oracle/src/main/antlr4/imports/oracle/DDLStatement.g4:
##########
@@ -3214,3 +3214,193 @@ forRefreshClause
: FOR ((SYNCHRONOUS REFRESH USING stagingLogName) | (FAST REFRESH))
;
+alterPluggableDatabase
+ : ALTER databaseClause (pdbUnplugClause
+ | pdbSettingsClauses
+ | pdbDatafileClause
+ | pdbRecoveryClauses
+ | pdbChangeState
+ | pdbChangeStateFromRoot
+ | applicationClauses
+ | snapshotClauses
+ | prepareClause
+ | dropMirrorCopy
+ | lostWriteProtection)
+ ;
+
+databaseClause
+ : DATABASE dbName?
+ | PLUGGABLE DATABASE pdbName?
+ ;
+
+pdbUnplugClause
+ : pdbName UNPLUG INTO fileName pdbUnplugEncrypt?
+ ;
+
+pdbUnplugEncrypt
+ : ENCRYPT USING transportSecret
+ ;
+
+pdbSettingsClauses
+ : pdbName? pdbSettingCluase
+ | CONTAINERS containersClause
+ ;
+
+pdbSettingCluase
+ : DEFAULT EDITION EQ_ editionName
+ | SET DEFAULT (BIGFILE | SMALLFILE) TABLESPACE
+ | DEFAULT TABLESPACE tablespaceName
+ | DEFAULT TEMPORARY TABLESPACE (tablespaceName | tablespaceGroupName)
+ | RENAME GLOBAL_NAME TO databaseName (DOT_ domain)+
+ | setTimeZoneClause
+ | databaseFileClauses
+ | supplementalDbLogging
+ | pdbStorageClause
+ | pdbLoggingClauses
+ | pdbRefreshModeClause
+ | REFRESH pdbRefreshSwitchoverClause?
Review Comment:
Update: I found the usage of **pdb_refresh_switchover_clause** in ALTER
PLUGGABLE DATABASE in the official documentation, so we should keep this SQL
syntax.
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
