Sample Header Ad - 728x90

Understanding of sqlplus STARTUP command syntax

1 vote
0 answers
56 views
On https://docs.oracle.com/en/database/oracle/oracle-database/19/sqpug/STARTUP.html , the document states that: > ## Startup command > ... > > where db options has the following syntax:
[FORCE] [RESTRICT] [PFILE=filename] [QUIET]  [ MOUNT [dbname] |  [ OPEN [open_db_options] [dbname] ] | NOMOUNT ]
So it seems that the if you want to use force and restrict, you have to use something like startup force restrict. But by my testing, startup restrict force also works. But the document describe the option like [FORCE] [RESTRICT], to me, this indicates an order, and force should go first, then restrict. Is my understanding correct?
Asked by Just a learner (2082 rep)
Apr 26, 2025, 03:25 PM
Last activity: May 23, 2025, 02:50 AM