Oracle

Objective: To monitor the validity of an Oracle index to see if the index is used. The index is then deleted or adjusted based on the monitoring results.Steps:1. Monitoring the specified indexCommand: Alter INDEX index name monitoring usage; such as:

1, CREATE table space, table space name is database, directory is datafile ' d:\oracle\product\10.2.0\oradata\data01.dbf ', size is 100M, each auto expansion 10M, maximum unrestricted. Create tablespace database datafile '

Before feeling installed 11g feel quite casual, today re-Ann once, out several times wrong, very uncomfortable ah, all the process recorded.After downloading the two compressed files into a folder, click Setup.exe to start the installation, if your

Query All Users: SELECT * from all_users; register monitoring manually: Alter system register;oracle password expiration setting 1, query select * from Dba_profiles where profile= ' Default ' and Resource_name= ' password_life_time ';  2, lifting

First, Trigger　　a trigger is a block of code that executes automatically when a particular event occurs. For example, a record is added to the log table each time an action is made to add or delete an employee table. triggers and stored procedures

One: Package definition (includes 1. Package Specification 2. Package Body )A package is a database object that encapsulates the related PL/SQL types, subroutines, cursors, exceptions, variables, and constants.1, Package Specification: You can

One: definition of functionA function is a PL/SQL program block that returns a specific data(The function must return a value)　　Grammar:create [or replace] function function_name--functions name[(Parameter_list)]--function list or parameterReturn

One: Advantages of stored procedures(1. Modularity: Through subroutines, can be used to implement a business logic, a business function.(2. reusability: Once a stored procedure is created, it can be used in any number of applications.(3.

Select Sid, CJSJFrom BASE_ZJXXwhere CJSJ = to_date (' 0001/1/1 ', ' yyyy/mm/dd ');SELECT *From Sys_userwhere Qyid in (90656, 90655, 90646, 90641, 90636, 90633, 90631);UPDATE base_zjxxSET CJSJ = (caseWhen Zjid = ' 90656 ' ThenTo_date (' 2015/4/7 15:57

Recently in the work of the Oracle database, need to plsql client to connect to the database, the whole process has a lot of problems, now summarize the entire configuration process.First, installation Oracle 11g bit, will 1 and the 2 unzip

Problem:Job all parameters are normal, but is not running, found that the execution time is one months ago:JOB 6 log_user user priv_user user schema_user user

Oracle11g create, modify, and delete tables, and oracle11g modify and Delete tables Oracle11g create, modify, and delete a table My Database Name: ORCL password: 123456   1. Mode 2. Create a table 3. Table Constraints 4. modify a table 5. delete a

Oracle custom function to determine whether data is a numeric function, oracle Value 1 create or replace function isnumeric (str IN VARCHAR2) 2 return number 3 IS 4 v_str VARCHAR2 (1000); 5 BEGIN 6 IF str is null 7 THEN 8 RETURN 0; 9 ELSE10 v_str: =

Ora-28001: thepasswordhasexpired. (password invalid) Ora-28001: the password has expired. (password expired) This new oracle11g feature, the default user password is only valid for 180 days. 1. plsql logs in as an administrator, and system/admin (

Create and use temporary tables in Oracle In addition to permanent tables, the ORACLE database can also create temporary tables. These temporary tables are used to save the data of a SESSION or the data required in a transaction. When the session

Computing the number of working days between two dates in an Oracle database Calculate the number of working days between two dates (excluding those two dates, excluding weekend) There are two methods: The first is to use SQL statements: SQL> SELECT

Modify the character set of the Oracle database (UTF8 → ZHS16GBK) Modify the character set of the Oracle database (UTF8 → ZHS16GBK) 1. C: \ Users \ Administrator> sqlplus/nolog 2. Log On As sysdba SQL> conn sys/root as sysdba 3. Call the

Oracle learning Summary (1)1. Installation and download of oracle 1.1 oracle service: oracle listening service (OracleOraDb11g_home1TNSListener): it must be enabled to access the database through a program.Oracle instance service: multiple databases

In Oracle11g, recyclebin is already a static parameter and cannot be modified online. [oracle@rhel63single ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 20 17:19:32 2015Copyright (c) 1982, 2013, Oracle. All rights

Using Windows DellPcserver, Oracledb reports an error: ORA-8103  Applies: Oracle Database-Personal Edition-Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]Oracle Database-Standard Edition-Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]Oracle