[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
|