Toad for Oracle 12.0 provides the following Oracle 12c support with the 12.0.1 patch applied. Toad 12.0 must be installed first.
You can download the main installer here: Toad Downloads
See Patch 12.0.1 for information on downloading and installing the patch.
Excerpt from 12.0.1 Release Notes:
- In Oracle 11gr2 and older, the SELECT ANY DICTIONARY privilege included the SYS.USER$ table. In Oracle 12c and newer, it does not. Toad accommodates this change.
- Identity columns are supported in Create/Alter Table, script generation, schema compare, and in the “add column” dialog.
- The Instance Parameters dialog now has a “Pluggable DB Modifiable” column with Yes/No values. Parameters with a “no” here can’t modify the parameter in a pluggable database; this is an Oracle limitation for Pluggable databases.
- Varchar2 and similar parameters now have a maximum size of 32767. You can change the max_string_size parameter to ‘EXTENDED’ for the database to support it.
- Invisible columns are now supported in Create/Alter Table, script generation, schema compare, and in the “add column” dialog.
- Constraints and Indexes now have an “online” option when dropping; DML won’t be blocked as the index or constraint is being dropped. This does not apply to constraints on views.
- Set Column Unusable and Mark Index Unusable in the Alter Table window now use the ONLINE option for 12c.
- There is a new option in column definition: DEFAULT ON NULL. This applies to Create/Alter Table, script generation, schema compare, and SB-Tables-Columns.
- When this option is selected, any time an insert or update tries to make a value null, the default value for the column is used.
- When it is not selected, the default value only applies on the initial insert.
- More detail is displayed for Users in the Schema Browser RHS Information.
- Toad’s ‘rename datafile’ dialog supports this Oracle 12c functionality:
- You can now move a datafile without taking the tablespace offline.
- Simply specify the new file name; if you have Oracle Managed Files, there is no need to specify the new file name.
- These new Sequence parameters are supported in Create/Alter dialogs, script generation, schema compare, and the Schema Browser RHS Info tab:
- Visible/Invisible columns are supported in View Scripts, Create/Alter View, and Compare Views.
- Bequeath is supported in View Scripts, Create/Alter View, and Compare Views.
- The Database Browser has a “Pluggable” tab when a container database is shown on the LHS. You can see the status, and open/close the pluggable databases.
- The RHS Sessions, Top Sessions, and Datafile IO tabs on the Database Browser now have a Service Name column to identify the pluggable database and the specific column where the data in that row originates. (This is only visible when connected to a container database).
- These object privileges are supported in the Schema Browser User-RHS-Script tab, Create/Alter User (Object Privs tab and “Add” dialog), Schema Browser User-RHS-Object Grants:
- You can now select a library file from the server. (This functionality is available for users with any Oracle version, including 12c.)
- New options are available in the Finish step of the DBMS Redefinition wizard.
- In the DBA Module, in the Alter Table dialog, there are new dbms_redefinition options to change the tablespace, and compression options for all partitions, all LOBs, and so on.
- The ASM Manager has these new features:
- You can alter disk group attributes in the ASM Manager, on the new Attributes tab.
- You can add/delete User Groups on the new User Groups tab.
- ASM Manager | Alter Disk Group has an option for ‘scrubbing’ disk groups.
- There is a new Code Role Grants tab (showing roles) on SB-Pack/proc/func RHS, and on SB-Roles RHS (showing objects).
- In 12c, one or more roles can be granted to a package, procedure, or function. Its intended use is to provide additional privileges to packages executed with invoker rights.
- The grants will be part of the script produced by the export ddl, schema script, and schema compare. It is not an option to include or exclude these; they will automatically come with the script if they exist.
Note: You can only grant roles that are granted directly to the package/proc/func owner.
- There are new truncate table options: Drop All Storage, Cascade, and Preserve/Purge Materialized View Log.
- There is a new Alter Index option in the Alter index dialog: Cleanup.
- Data Pump:
- Data Pump Export includes these new options: Compression Algorithm, Views As Tables.
- Data Pump Import includes these new transformation options: lob_storage, segment_creation, disable_archive_logging, and table_compression_clause.
- Data Pump Import and Export now support the LOGTIME parameter.
- For the DBA Admin Module, this new object type has been added: Redaction Policies with create/Alter dialogs, F4 support, and so on. This new object type is in:
- Schema Browser
- Generate Schema script
- Html schema doc generator
