Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Oracle SQL Plus The Definitive Guide- P51:Every day, computer professionals the world over wake up, travel to the office, sit down in front of a computer, and begin another day working with that database called Oracle. Programmers write queries and stored procedures. Database administrators monitor performance, make database changes, and perform other maintenance tasks. Operations people may need to back up or recover a database. | previous page page_462 next page Page 462 scriptfile Is the name of the file you want to execute and may include the path and the extension. The default extension is SQL. If you do not specify a path SQL Plus will look for the file first in the current working directory then search each directory listed in the SQLPATH environment variable. See Chapter 11 for information about customizing the search path. argument Is an argument you wish to pass to the script. You may pass as many arguments as you like. Arguments must be separated from each other by at least one space. Arguments may be enclosed in quotes and should be if they contain spaces. Either single or double quotes may be used at your discretion. Your script may reference the first argument as 1 the second as 2 and so forth. Startup The STARTUP command allows you to start an Oracle instance and open a database. Chapter 10 discusses this command. In order to use STARTUP you must be connected as SYSDBA SYSOPER or INTERNAL. STARTUP FORCE RESTRICT PFILE_parameter_filename MOUNT OPEN RECOVER database_name EXCULSIVE PARALLEL SHARED I NOMOUNT where STARTUP Is the command which may not be abbreviated. FORCE Forces the instance to start. If the instance is currently running then FORCE will cause the equivalent of a SHUTDOWN ABORT to be done first then the instance will be restarted. RESTRICT Opens the database in restricted session mode. Only users with the RESTRICTED SESSION system privilege will be allowed to connect. PFILE parameter_filename Tells SQL Plus to use the specified parameter file initialization file when starting the instance. You may specify a path with the filename. previous page page_462 next page previous page page_463 next page Page 463 SQL Plus reads the parameter file not the Oracle instance. The path to the parameter file must be relative to the machine running SQL Plus. This matters for example if you are using SQL Plus on a PC and connecting remotely to an instance on a server in order to .
