Prev | Current Page 311 | Next

Rick Greenwald, Robert Stackowiak, Jonathan Stern

"Oracle Essentials: Oracle Database 11g"


ALTER DATABASE RECOVER
Apply logs individually or start automatic application of the redo logs.
CREATE DATABASE
Create and name a database, specify datafiles and their sizes, specify logfiles and
their sizes, and set parameter limits.
DROP DATABASE
Delete a database and all of the files included in the control file.
CREATE SPFILE
Create a server parameter file from a text initialization (INIT.ORA) file.
RESTRICTED SESSION privilege
Allow connections to databases started in Restricted mode. Restricted mode is
designed for activities such as troubleshooting and some types of maintenance,
similar to what SYS can do.
Administrators connected as SYSOPER can perform a more limited set of commands:
STARTUP and SHUTDOWN, CREATE SPFILE, ALTER DATABASE OPEN
or MOUNT or BACKUP, ALTER DATABASE ARCHIVELOG, ALTER DATABASE
RECOVER, as well as the RESTRICTED SESSION privilege.
Database administrators are authenticated using either operating system authentication
or a password file. The CONNECT INTERNAL syntax supported in earlier
releases of Oracle is no longer available.


Pages:
299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323
Władysławowo noclegi pity pozycjonowanie bilety lotnicze świnoujście noclegi