3 ms·

"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 s

by devit 6y ago

"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.

daniel-levin 6y ago
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
- miahi 6y ago
  It's not about an application DB, it's just for the system dictionaries and metadata, the file structure and so on.
- AdrianB1 6y ago
  It was stated the db is empty.
miahi 6y ago
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.