Hacker News Reader

"create stand alone database: ~30m"

If creating a database takes 30 minutes, there is something extremely wrong either in the procedure the person used to do so, or in the Oracle software itself.

View on HN

In the Oracle world, creating a DB is not something you do often. In most cases you only have a database on the whole server/cluster and all the applications will use that database instance, being isolated at user/schema level. So that 30 minutes time is not that important actually.

Creating pluggable databases (containers) is fast.

Well, if the database has the number of tables, triggers, stored procedures, etc that SAP or Oracle’s ERP has then this seems less unreasonable. We’re talking thousands

It's not about an application DB, it's just for the system dictionaries and metadata, the file structure and so on.

It was stated the db is empty.

Reply on news.ycombinator.com