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 »

Uncategorized

Datapump or Flashback Database

datapump2 1

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.

Datapump or Flashback Database Blogbeitrag lesen »

Scroll to Top