Oracle-12c
從遠端創建 PLUGGABLE DATABASE REFRESH MODE MANUAL 失敗並出現 ORA-00922
我正在對遠端 PDB 複製進行一些測試。本地和遠端實例都是
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production PL/SQL Release 12.1.0.2.0 - Production "CORE 12.1.0.2.0 Production" TNS for Linux: Version 12.1.0.2.0 - Production NLSRTL Version 12.1.0.2.0 - Production
DB LINK 正在工作,並且遠端 PDB 存在
SELECT COUNT(*) FROM V$PDBS@REMOTE WHERE NAME = 'REMOTEPDB';
但是這樣做
sqldeveloper
CREATE PLUGGABLE DATABASE mypdb FROM REMOTEPDB@REMOTE REFRESH MODE MANUAL;
給了我這個錯誤:
Error starting at line : 1 in command - CREATE PLUGGABLE DATABASE mypdb FROM REMOTEPDB@REMOTE REFRESH MODE MANUAL Error report - ORA-00922: missing or invalid option 00922. 00000 - "missing or invalid option" *Cause: *Action:
create_pdb_clone::=
12.1 語法:
12.2 語法:
pdb_refresh_mode
從版本 12.2 開始可用,但在您的版本中不可用。