Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CAN I CREATE USER IN A STANDBY DATABASE?

Status
Not open for further replies.

oracle8

MIS
Sep 30, 2000
69
PH
HI!

Can i create a user/schema in a standby database.

thanks
 
Can you give us a little more detail here? I immediately want to say yes you can, but I am not sure... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...
 
Hi

since creating a user will result in redo-log information the standby-database will get every change with the archive-log-import.

So normally one would expect that every user created in the primary database will also be generated in the Standby-database with some time-lack dependent on the log-size and checkpoint-intervalls.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top