[cx-oracle-users] Error creating pluggable db on 12c
Brought to you by:
atuining
From: Simon C. <sim...@gm...> - 2014-12-18 17:36:05
|
I'm trying to create an Oracle 12c pluggable database with the following code ... ora_dsn = cx_Oracle.makedsn('192.168.1.1', 1521, service_name='cdb') connection = cx_Oracle.connect('sys/oracle', dsn=ora_dsn, mode=cx_Oracle.SYSDBA) cursor = connection.cursor() cursor.execute("create pluggable database pdb admin user pdbadmin identified by password;") connection.close() .... and got this error: cursor.execute("create pluggable database pdb admin user pdbadmin identified by password;") cx_Oracle.DatabaseError: ORA-00922: missing or invalid option I tested the "create pluggable database" statement in sqlplus and it worked. Is "create pluggable database" supposed to work on cx_Oracle 5.1.3? If so, can anyone advise what I'm doing wrong? Thanks! Simon |