Re: Error creating pluggable db on 12c
Gaius Hammond <[email protected]>
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <[email protected]> |
Probably you don't need the trailing semicolon.
From: Simon Chang
Sent: Thursday, 18 December 2014 17:36
To: cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Reply To: cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
Subject: [cx-oracle-users] Error creating pluggable db on 12c
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
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users