Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

While dropping and creating the database console do I need down time on production databases?

April 26, 2017console creating database databases production time

0

Posted

While dropping and creating the database console do I need down time on production databases?

1 Answer

0

Posted

The emca command, when recreating or dropping the repository, requires the database to be quiesced. This means that, temporarily, no operations are possible on the database and new users cannot login. If there are active sessions on the database at the time the quiesce operation will hang pending their completion, during which time no new users will be able to connect.