Tags » Database

Transport tablespaces across platforms in Oracle Database 12c

Introduction:

Transportable Tablespaces helps to copy one or more tablespaces from one Oracle Database to another.
Starting with Oracle Database version 11g, transport tablespaces can be used to migrate database from one platform to another. 3,540 more words

Oracle

Automatic Diagnostics Repository (ADR) Enhancements in Oracle Database 12c (ADRCI)

DDL Log

Setting the ENABLE_DDL_LOGGING parameter to TRUE activates DDL logging. All DDL statements are logged into a plain text file and an XML file in the ADR location. 880 more words

Oracle

Online Move Datafile in Oracle Database 12c Release 1 (12.1)

Basic Syntax

The text description of the syntax is shown below, but the syntax diagrams and a full description of the ALTER DATABASE command is available in the documentation  1,129 more words

Oracle

Multitenant : Startup and Shutdown Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1)

Container Database (CDB)

Startup and shutdown of the container database is the same as it has always been for regular instances. The SQL*Plus STARTUP and  951 more words

Oracle

Multitenant : Connecting to Container Databases (CDB) and Pluggable Databases (PDB) in Oracle Database 12c Release 1 (12.1)

Connecting to a Container Database (CDB)

Connecting to the root of a container database is the same as that of any previous database instance. On the database server you can use OS Authentication. 842 more words

Oracle

Multitenant : Migrate a Non-Container Database (CDB) to a Pluggable Database (PDB) in Oracle Database 12c Release 1 (12.1)

Clone a Remote Non-CDB

The 12.1.0.2 patchset introduced the ability to create a PDB as a clone of a remote non-CDB. 

Using DBMS_PDB

The DBMS_PDB… 472 more words

Oracle

Creating Push Buttons in Your Database

So, push buttons. What do I mean by that? It’s quite simple really. They’re buttons set up so that you can access other forms (or other elements of your database, but I haven’t tried that yet), at the push of a button, rather than navigating to the back-end of the database and selecting what you want. 173 more words

Writing