March 2016 »

Uncategorized

Prevent PDB creation in a Single Tenant environment

How do I prevent the creation of a second PDB in a Single Tenant environment? At last Oracle introduced a number of new features with 12c, but Multi Tenant is still the one outstanding innovation. But when switching to the new version my customers have one question: Do I really need this feature? Beside the not really low licensing costs for the Multi Tenant Option, there are practical use cases. But when I use one productive environment with one test environment or a consolidation into a Multi Tenant environment makes simply no sense, I still can use the Non-CDB alternative.

Prevent PDB creation in a Single Tenant environment Blogbeitrag lesen »

By Johannes Ahrends • 18. March 2016 • 2 minutes of reading

Datapump or Flashback Database

Do you need Datapump? At nearly every customer I’m visiting there is a need to take export dumps of the entire database every single day. But why? You probably know the answer: because the application team requested it to reset a schema or a table to an earlier time in the event due to a user failure, batch error or whatever. My next question is this: “How often did you reset a table or a schema within the last 12 months?” Answer: “Not a single time… but we had to do it some years ago with one of our databases.