Re: Create 12c or 18c database in traditional architecture
Date: Wed, 29 Aug 2018 17:27:49 +0200
Message-ID: <CAK6ito0uEiJLEisCBuC-LjsL-BSe1YUJpoqPJDqjFHA9d_Mvug_at_mail.gmail.com>
Hi all,
In the little annoyances when going to CDB, the major problems I see are
related to dictionary views that are partly broken. Things like:
Connected to:
Which will probably never been fixed. Probably not a problem in production
but I've seen several homemade development frameworks failing on PDB when
reading metadata. So it is not only the application and the DBA scripts
that have to be tested. The whole tools covering the whole development
life-cycle as well.
Regards,
On Wed, Aug 29, 2018 at 5:11 PM Mladen Gogala <gogala.mladen_at_gmail.com>
wrote:
> Hi Neil!
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> alter session set container=pdb1;
Session altered.
SQL> select dbms_metadata.get_ddl('VIEW','DBA_USERS') from dual;
ERROR:
ORA-31603: object "DBA_USERS" of type VIEW not found in schema "SYS"
ORA-06512: at "SYS.DBMS_METADATA", line 6681
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 6668
ORA-06512: at "SYS.DBMS_METADATA", line 9672
ORA-06512: at line 1
Franck.
>
> Multi-tenant doesn't make any sense because the resources it will save
> are much, much cheaper than the cost of the multi-tenant option. Also,
> the competitors (DB2, SQL Server, SAP Hana) are all allowing creation of
> additional databases for free. I don't see why would I need to pay for
> the same feature with Oracle?
>
> Regards
>
>
> On 08/29/2018 09:23 AM, Neil Chandler wrote:
> > Personally I think multi-tenant a decent feature but it is cost
> > prohibitive for what you get in return.
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 29 2018 - 17:27:49 CEST