On the 11 July Oracle has made a first edition of SQL Developer 4.0 avaible for download. You can find the download here. The download is avaible for: Windows 32/64 Bit Max OSX Linux A full New Feature List can be found here.
When you want to clone a PDB (in the same CDB) then there few simple steps to do. Check your Database Parameters Connect to your CDB Stop the source PDB (hope this step will not be necessary in future releases) Clone the PDB Open the PDB Step 1: Check your Database Parameters We want to…
When you want to convert a Single Instanz (non PDB) to a PDB (for example after a pre 12c Database upgrade) then this example is usefull for you. First here is a overview of the task: Open the database in read only mode Create a xml File for the conversion Login into your CDB Plug…
Also Datapump has some new interesting New Feature which are usefull for tranporting your data. Creating SecureFile LOBs During Import You can now specify the LOB Storage during import Command line example: impdp scott/tiger DIRECTORY=dpump1 DUMPFILE=export.dmp LOB_STORAGE:SECUREFILE Compressing Tables During Import You can now specify a Compression method during import Command line example: impdp scott/tiger…
You can now create invisible columns in your database. This means that when you create such column, that this will not affect you application and you can fill it with data. When all preparation is done you can change it to a visible column. Sample for creating a table with invisible columns: CREATE TABLE…
Oracle today has released the Weblogic Server 12.1.2 and is avaible for download. If you want to download the Weblogic Server look at the OTN page. Here are some of the New Features: Oracle TopLink 12.1.2 Dynamic Clusters Oracle Database 12c Integration Also some features a deprecated like: JSP Tags for XML processing weblogic.management.username and…
In the last days Oracle has released the Oracle Cloud Control 12.1.0.3 and Oracle 12c Database for Windows x64. So the next nice download would be the new Weblogic Server release.
In RMAN 12c, you can now execute SQL commands and PL/SQL procedures from the RMAN command line without prefixing the command with the SQL keyword. Example: [oracle@# trace]$ rman target sys Recovery Manager: Release 12.1.0.1.0 – Production on Tue Jul 9 23:10:09 2013 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. target…
Starting with 12c the multithreaded Oracle model allows you to start threads within OS processes. This model is similar to windows where you have only one process and different threads from this one process. This Architecture have some Benefits: CPU usage reduction Memory usage reduction Better performance for parallel executions / operations Better system reliability…
From 12c onwards it seems that the resource role has changed. The UNLIMITED TABLESPACE privilege is no longer the default RESOURCE role starting in Oracle Database 12c. The change should increase the security, but will be a pitfall will be that many oracle customers create application users without quota. So be sure to check your…
Peter`s DBA Blog 