Oracle

1, the concept of the index An index is a database object that is used to speed up data access. Reasonable use of indexes can greatly reduce I/o times. 2, the function of the index: The record is sorted, speed up the query speed of the table. 3,

1, Grant object permissions is the right to access other user scenario objects. GRANT Object_priv|all [(columns)] On object to {user|role| public} [with GRANT OPTION]; All: Permissions for all objects Public: Grant to all users With GRANT

Use of index clusters: Create clusters of tables that are often accessed in connection statements. Do not cluster tables if the tables are only occasionally connected or their public columns are often modified. (It takes more time to modify the

Oracle Trace Files Oracle trace files are grouped into three categories: One is the background alarm log file that records the activity of the background process during startup, shutdown, and running of the database, such as table space creation,

1. Choose the appropriate Oracle optimizer There are 3 Oracle optimizer types: A. Rule (rule-based) B. Cost (based on costs) c. CHOOSE (optional). Set the default optimizer to pass various declarations of optimizer_mode parameters in the Init.ora

Move database files in Oracle ----Oracle database consists of three files of data files, control files, and online log files. Database administrators may consider moving database files because of changes in disk space, or adjustments based on

Two data tables to create 1. Postgraduate Information table Table name: Scott.student. The table structure is shown in table 7.6. 3. Relationship of two data tables The Master code "director_id" of the Tutor Information table (scott.director) is

Oracle 9i Default User Table 8.1 Oracle 9i Default Primary User User name Password Login Status and Description Sys Change_on_install Sysdba or Sysoper, but can not 訬 ormal login, as the default system

These functions allow you to access the Oracle8 and Oracle7 databases. He uses the Oracle8 point interface (OCI8). Using this extension module, you need to Oracle8 the client library file. This expansion module is smoother than a standard Oracle

oracle| Data | database 1, view the table space name and size Set linesize 140;set pages 200;column tablespace_name format A30;select tablespace_name,min_extents,max_extents,pct_ Increase,status from Dba_tablespaces;select

oracle| Recovery | data | database First, user table space Error: ORA-01157,ORA-01110 or operating system-level errors such as ORA-07360 when you start the database will cause an error immediate when you close the database (using shutdown normal or

oracle|unix| Data can unix Oracle 10g read file data with Utl_file packets? I am under Window Oracle 8i using Utl_file can read the data of text files, I test through, But not on Unix Oracle 10g! Error! Begin Loadfiledata (' D:\ora ', ' 1.txt ');

Oracle Case Category: Vas network System type: Cmode system version: Hardware: SUN software: All version case title: The database in the Cmode put the lock processing method failure phenomenon: Start the sam_cmode process is not normal processing

oracle| Safety | Problem database security problem has always been one of the focus of attention, we know that a business or organization of the database if the hacker attacks, and these databases and the preservation of very important data, such as

Oracle-CREATE TABLE (creating a partition Table) CREATE TABLE Bill_monthfee_zero ( SERV_ID number is not NULL, Billing_cycle_month Number (6) is not NULL, Date_type number (1), ACC_NBR VARCHAR2 (80) ) Partition by range

Oracle Recently got a beta version of oracle10g from a friend. During the installation process, encountered a small episode, written here for your reference. My machine is Piii700,windows2000+service Pack4. After clicking the Setup.exe, the window

oracle| Security | data (ii) Another hidden danger from the inside--user management and password issues Here, in fact, as a similar point of the database administrator is very clear, the Oracle database itself has used a number of ways to enhance

Oracle Oracle's physical visual management Author: ccbzzp 1. The concept of physical visualization The materialized view management is used for the total, the prediction, recovery or distribution of the image, in a large number of library use it

Oracle| Notes | performance Oracle Performance Diagnostics-Learning Statspack Notes (ii) [Overview] Author: Liu Yingbo Time: 2004-3-3 Mail:liuyingbo@126.com, please correct me. Reprint please indicate the source and the author Oracle

1, must set the undo retention time is large enough to be able to reconstruct the required flash back data The ALTER SYSTEM SET undo_retention= seconds value is the number of seconds that the UNDO data is persisted. Flashback view is