Oracle

  Oracle MapViewer is a component of Oracle Fusion middleware. It is delivered in Java EE application mode and can be deployed in other Java EE containers. Core Components 1. core rendering engine (SDOVIS): this engine is responsible for

  This method is applicable when the user password expires, the account is locked, and the user password cannot be modified. 1. Retrieve expired user information Select username, account_status, password, profile from dba_users where username =

1. Forget the logon password of a user except SYS and SYSTEM. Log On As a sys (or SYSTEM) user. Conn sys/PASS_WORD as sysdba; Use the following statement to modify the user password. Alter user user_name identified by newpass; Note: The password

In Oracle Database Operations, if the remark01 field is added to the original table TB_HXL_USER, the default value is 'A'. However, because the data volume of the table is large, fields are directly added to the original table, the execution takes a

Objective: To access the database by iSQL * Plus DBAEnvironment: oracle 10gTutorial steps:1. start the iSQL * Plus service: isqlplusctl start2. Enter http: // host name: 5560/isqlplus/dba in the address bar of the browser.The following dialog box is

This is the first article on my Blog. It was already a document I wrote a year and a half ago. At that time, it was very hard to implement a project, from knowing DG to implementing it, everything is fresh, and everything needs to be checked.

Drop procedure mrr. delete_risk_assessment;Create or replace procedure mrr. delete_risk_assessment (Id IN NUMERIC) ISBEGINDelete mrr. riskassessmentvalueWHERE risktypedetail_id IN(Select mrr. risktypedetail_id FROM risktypedetailWHERE riskassessment_

Create a temporary table: XXX_TEMP_FILESThe table creation statement is:Create table XXX_TEMP_FILES (FILE_ID NUMBER,Seq number,TEXT VARCHAR2 (2000 ),CREATION_DATE DATE)The purpose of creating this table is to extract the data from the file_data

How to Write specific SQL statementsIn this example, subjects are not fixed and dynamic.Create table test (name char (10), km char (10), cj Number)Insert into test values ('zhang san', 'China', 80)Insert into test values ('zhang san', 'mat',

Four ways to increase the tablespace sizeMeathod1: add data files to the tablespaceAlter tablespace app_data ADD DATAFILE'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ EDWTEST \ APP03.DBF 'size 50 M; Meathod2: add data files and allow automatic growth

Data Export and Import Perform a logical backup to export data to A. dmp file.   Cmd Mode   C: \ Documents ents and Settings \ Administrator> exp   Export: Release 10.1.0.2.0-Production on Thu Aug 25 17:52:13 2011   Copyright (c) 1982,200 4, Oracle.

[Oracle]-[Create index]-How to create an index and some experiences 1. Read the data of the index key to the cache. If the data is not read to the database Cache, there may be a DB file scatter read write wait event. 2. Sort the data of the index

Use sqlplus to execute *. summary of common problems in SQL Files case 1 Description: After using sqlplus to log on to the database, enter @ file name full path to execute *. SQL file example: assume there is a test. the path of the SQL file is/home/

Oracle sequence explanation and creation of auto-incrementing primary key Oracle sequence primary key sequence: a database object provided by oacle to generate a series of unique numbers. L automatic provision of unique value l shared object l

Optimization of IMPDP/EXPDP Import and Export speed data pump and exp/imp performance is greatly improved, the biggest impact is paralle. In this case, expdp/impdp = exp/imp + direct mode + paralle. Therefore, to increase the speed of data pump, you

Order by index usage problem: id is PK select a,b,id from adf where rownum  The result is 'ORDER BY' first, and then execute rownum select a,b,id from adf where rownum  The result is to execute rownum SQL> select * from t; ID ID1 ---------- 1 2 2 2 4

Union all is used to display the total items in a total project. Generally, a column is calculated and the total is displayed at the end of the column. The conventional method is to use union all to establish meaningless connections. Example: SQL

The basic operation procedure for flushing data from ora10g to 8I master: oracle 10 gsnapshot site: oralce 8i Materialized View in oracle 8i is called snapshot, oracle 8i snapshot creation SQL commands are still compatible with oracle10g. On master

Oracle lock mechanism principle (in-depth analysis)The database uses two types of locks: Shared locks and exclusive locks. Only one exclusive lock can be obtained in a table or table, but the shared lock can be obtained multiple times in a single

Considerations when using EXPDP and IMPDP: EXP and IMP are client tool programs that can be used either on the client or on the server. EXPDP and IMPDP are tool programs on the server. They can only be used on the ORACLE server, but not on the