Bryan's Oracle Blog: Automating cloning of your Exadata Database Servic...

Bryan's Oracle Blog: Automating cloning of your Exadata Database Servic...: One of the questions I often get from customers is  "How do I automate the cloning of a production database backup to a non-prod c...

Bryan's Oracle Blog: Autonomous Recovery Service Live Lab available

Bryan's Oracle Blog: Autonomous Recovery Service Live Lab available: One of the latest additions to Oracle's Live Labs is the Autonomous Recovery Service. This lab  allow you to understand how to utilize t...

Database-Box: Logging Options in Oracle for Data Guard

Database-Box: Logging Options in Oracle for Data Guard:   Logging Options in Oracle for Data Guard When preparing a  primary Oracle Database  for use with  Oracle Data Guard , enabling the correct...

Bryan's Oracle Blog: MCP Server for Autonomous Recovery Service

Bryan's Oracle Blog: MCP Server for Autonomous Recovery Service: Wouldn't it be nice if I could just use AI and ask my tenancy to tell me about my Autonomous Recovery Service database backups ? I want...

Minimalistic Oracle: Inter-database import and exports using Oracle dat...

Minimalistic Oracle: Inter-database import and exports using Oracle dat...: To move an entire schema from one schema to another within the same Oracle database, there is no need to export data to disk and then reimp...

Bryan's Oracle Blog: How many IP addresses do I need for the Autonomous...

Bryan's Oracle Blog: How many IP addresses do I need for the Autonomous...:  One of the most common questions that comes up is "How many IP addresses do I need to set aside for the Autonomous Recovery Service...

Minimalistic Oracle: How to dump the entire schema's DDL into a file

Minimalistic Oracle: How to dump the entire schema's DDL into a file: pg_dump -d mydb \ --schema-only \ --no-owner \ --no-privileges \ -n myschema \ -f create_schema.sql The flag "--no-owner...