Oracle

Database architectureDefined:The composition of the database, the working process, the composition and management mechanism of the data in the database.Compositioninstances, user processes, server processes, database files,Other files (parameter

1. Change localhost to computer name best-pc, or IP address. I changed the computer name because I often switch between the wireless network and the Limited networkSid_list_listener =(Sid_list =(Sid_desc =(Sid_name = Clrextproc)(Oracle_home = d:\app\

In peacetime remote installation of Oracle use more than the use of VNC Remote Desktop to install, of course, is afraid of installation error, but recently in the installation of a server Oracle, in the installation of the installation script when

1. Create a Directory$ORACLE _base/admin/$ORACLE _base/oradata$ORACLE _base/flash_recovery_area2, the initialization of the parameter fileCD $ORACLE _home/dbsDb_name=orclmemory_target=1gprocesses = 150Audit_file_dest= '/oracle/app/product/admin/orcl/

Problem Description:A cell, need to follow the plot, Wendy, unit number, room number, but sort by address description, because the string contains a number, so the result is as follows,Building 1th is supposed to be building 2nd, but the search

In the actual development process, there are times when we are likely to need an operational trace of a table, or a recorded SQL statement for purposeful data recovery (at which point the point-in-time recovery has not satisfied finer granularity),

1. If the database is configured with automatic storage management (ASM), the Aggregation Synchronization service CSS (Cluster Synchronization Services) should be removed first. The way to delete a CSS service is to execute the following command on

To back up a data file:Sql> Select file_id, file_name from Dba_data_files; Backup: Standby (Backup) datafile: Data file backup tablespace: Backing up table Space Backup database: backing up databasesrman> backup DataFile 4;Rman> backup DataFile 4, 5;

What is the difference between Oracle functions and stored procedures1. The difference between the return value, the function has 1 return values, and the stored procedure is returned by the parameter, can have more or No 2. The difference between

Oracle NET1. The client obtains the specific connection information of the server through the @ora10g name to the Tnsname.ora file.2. The client sends a link request to the server via the description in the Tnsname.ora server side3. After the server'

first, the common view descriptionOracle SQL statement resource consumption monitoring, the most commonly used system views are:V$sqlV$sqlareaV$sqltextV$sessionV$sql and V$sqlarea are basically the same, documenting the SQL statistics in the shared

Lsnrctl Status: View listening statusOracle Network configuration consists of three parts: client, Listener, databaseConfiguration file:$ VI $ORACLE _home/network/admin/listener.oraVI listener.ora the same command as aboveNetstat-tln|grep 1521Add a

User ManagementAuthentication: AuthenticationAaa:Authentication: AuthenticationAuthorization: Rights ManagementAudition: AuditGrant: Authorizationunset: Undo (Eliminate)Sql>echo $ORACLE _sid ORCL query database is named ORCLSql>vnset ORACLE_SID

About DMP Files We use more, DMP files It is used as the file format for the Oracle Import and export tables, and today the DMP files are exported and imported for learning.DMP file ExportDMP file export is generally three kinds, they are: export

1. What is NULL?Null means Unknow (unknown), which does not mean whatever the value is.For example, a column in a row does not have any value or null.Oracle agrees that no matter what type of data the field is empty, in addition to the following two

A requirement is a record of logged-in logs logged by a user, including time and connection IP addresses, and connections, which can help keep track of analysis issues, especially if some human-induced DML operations cause data loss, data clutter,

Collection OperationsSelect employee_id, job_id from EmployeesUNION ALL does not remove reserved duplicate valuesSelect employee_id, job_id from Job_history;Select employee_id, job_id from EmployeesUnion removes duplicate valuesSelect employee_id,

650) this.width=650; "Width=" 501 "height=" 228 "title=" Od.png "style=" width:648px;height:321px; "alt=" wKiom1mC49_ Ijp8gaacllfoyuec759.png-wh_50 "src=" Https://s1.51cto.com/wyfs02/M02/9D/A1/wKiom1mC49_ijP8gAACLLFoyUEc759.png-wh

① log in to the database with the ' sys ' user, enter select * from dba_users; see if there are any Scott users, as shown in:650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M01/9D/5E/wKioL1l-8maBmLr0AABqgUF9CR8135.png "title=" Qq2017073117021

The permission system of Oracle database is divided into System permission and object permission. System permissions (Database system privilege) allow the user to execute a specific set of commands. For example, the CREATE TABLE permission allows a