Several very useful package
1. For the definition of content dbms_mEtadata.get_ddl SQL> SELECT dbms_mEtadata.get_ddl ('TABLE', 'DEPT', 'SCOTT') FROM DUAL; DBMS_METADATA.GET_DDL ('TABLE', 'DEPT', 'SCOTT') ----------------------- ...
quot quot
init.ora in Remote_Login_Passwordfile impact on authentication
init.ora in Remote_Login_Passwordfile impact on authentication Three optional values: NONE: default value, indicating Oracle system does not use a password file for authentication by the operating system privileges users have SYSORA and SYSOPER privi ...
Interactive Communication with sqlplus shell parameters
Execute sqlplus command in the shell often have to pass each parameter, see the following code Output parameters, both in sql select query results in a multi-line or multi-column, each value will be separated in accordance with space to give $ proc_p ...
"V $ open_cursor.sql_text showing" table_4_200_5e1
- Thanks for the question regarding "v $ open_cursor.sql_text showing" table_4_200_5e14_0_0_0 "", version 8.1.7 Submitted on 6-Apr-2002 23:29 Central time zone Tom's latest followup | Bookmark | Bottom Last updated 12-Dec-2006 22:0
scripts of create database
1.create init.ora log_archive_dest_1 = 'LOCATION = / arch /' log_archive_format =% t_% s_% r.dbf db_block_size = 8192 db_file_multiblock_read_count = 16 open_cursors = 300 db_domain = "" db_name = gc background_dump_dest = / oracle ...
Oracle of the inverted index
Reverse key index is to the normal exchange after the beginning and end store, such as the original value is "1234", will be "4321" form of storage, this would effectively break up the normal index key in the index leaf block loca ...
ORACLE Diagnostic Event
ORACLE Diagnostic Event Oracle for the RDBMS provides a variety of diagnostic tools, diagnostic event (Event) is one of the commonly used, easy to use method, which allows DBA can easily dump a database to track all kinds of structures and the occurr ...
1Z0-007 Study Notes Lesson 3 constraints and sorting queries
1Z0-007 Introduction to Oracle9i SQL ® Lesson 3 constraints and sorting queries SLIDE1-SLIDE7 SLIDE 1 goal 1, constraints, queries 2, sorting queries SLIDE 2 choose to limit line In this example, we query the employees department_id is 90, which is m ...
Excel using SQL * Loader to export data to Oracle database
1, open the oracle want to export to the Excel, the Excel file is saved as a. Txt files (File - "Save As) rn2, create a SQL * Loader input data required documents are saved to C:, use Notepad to edit: rn control file: input.ctl, which reads as f ...
Modify the method of oracle9i database character set
SQL> select name, value $ from props $ where name like '% NLS%'; SQL> alter database character set zhs16gbk; alter database character set zhs16gbk * ERROR at line 1: ORA-12712: new character set must be a superset of old character set S ...
Lies and gold enhanced version of the classic
"" Model student: The examinations are smashing La. ! "" Boutique owner: too fit La. , is simply to give you custom-made. "" Principal: (morning) I would simply say a ... ... "" Doctors: This pin is not at pain ...
10G Data Pump Export can be individually JOB
10G Data Pump Export can be individually JOB SQL> CONN / AS SYSDBA Is connected. SQL> CREATE USER JOBA IDENTIFIED BY JOBA; The user has been created. SQL> GRANT CONNECT, RESOURCE TO JOBA; Grant succeeded. SQL> CONN JOBA / JOBA Is connected. SQ
How to send Email in Oracle
1. CREATE PACKAGE CREATE OR REPLACE PACKAGE demo_mail IS ----------------------- Customizable Section ----------------------- - Customize the SMTP host, port and your domain name below. smtp_host VARCHAR2 (256): = 'smtp.eygle.com'; smtp_port ...
Set oracle query is not case sensitive
(The following only in the "=" was the case of the entry into force, LIKE not work.) Sometimes we do not want to check the time and other functions through the lower or upper case and put out the contents of all queries, such as from sqlser ...
Getting Started with Oracle RAC and improve the
Oracle RAC Product Overview Oracle Real Application Server, Real Application Clusters, referred to as Oracle RAC, is the Oracle parallel clusters, located in different Oracle server system to access the same instance of an Oracle database at the same ...
ORA-39125: Error
ORA-39125: at KUPW $ WORKER.UNLOAD_METADATA in the Worker unexpected fatal error occurred (in the call DBMS_METADATA.FETCH_XML_CLOB [TABLE_STATISTICS] pm) ORA-22813: Operation value exceeds system limits ORA-06512: at "SYS.DBMS_SYS_ERROR", ...
VIM Plug-in install and use sqlplus
Today in the google search to a vim plugin: sqlplus.vim This plug-in installed, you can perform file in the SQL statement. Installation To access the website: http://www.vim.org/scripts/script.php?script_id=2821 At the bottom to find sqlplus.vim down ...
oracle control file management
oracle A database maintained by controlling the integrity of the database files, control file is damaged when the database will not start, it is proposed multi-path control file or Backup control file method. Control file is a database established, t ...
oracle Control Document Management
oracle A database maintained by controlling the integrity of the database files, control file is damaged when the database will not start, it is proposed multi-path control file or Backup control file method. Control file is a database established, t ...
The non-idle wait events db file scattered read (USER I / 0 category)
When the session is released a number of data blocks read IO request to submit the event. ORACLE wait for several consecutive sessions of data block (specified by the initial parameters DB_FILE_MULTIBLOCK_READ_COUNT) from the disk in read into the SG ...
[Change] Oracle data types and storage methods
Oracle data types and storage methods Yuan Guangdong Original http://www.javaeye.com/topic/220760 Overview by example, comprehensive and in-depth analysis oralce the basic data types and their storage methods. ORACLE 10G basis in order to introduce o ...
oracle under linux startup and shutdown scripts
In many cases after installing Oracle DB on Linux servers, there is a need to configure it to start automatically after OS reboot. The automatic startup and shutdown of the Oracle database can be achieved with the files dbstart and dbshut both provid ...
Understanding of the connection and session oracle
Understanding of the connection and session oracle 1. The concept of different: Connection refers to the physical server client oracle connection. Generally through a network connection. Build on the connections to establish client and oracle of the ...
Create columns automatically increase oracle Village
CREATE TABLE "DEPARTMENT" ( "DEPARTMENT_ID" NUMBER, "DEPARTMENT_NAME" VARCHAR2 (30) NOT NULL ENABLE, "MANAGER_ID" NUMBER (6,0), "LOCATION_ID" NUMBER (4,0), PRIMARY KEY ( "DEPARTMENT_ID") ENA ...
oracle sql optimization
Note prepared by the basic Sql Minimize the use of IN operator, essentially all of the IN operator can be replaced with EXISTS IN written with the advantages of SQL is easier to write and clear and easy to understand, but the SQL performance with IN ...
About the database data into an error when the solution
Migration in the implementation of a business when the database into the report found the following error, common sense can not be several times the normal operation of the implementation of import. rn Export data in other libraries use the default e ...
Reprinted: ora-04031 error solutions and detailed analysis
For most applications, shared pool size for Oracle is the performance is very important. Shared pool dictionary cache saving data and full resolution or compilation of the PL / SQL blocks and SQL statements. When we try to allocate large shared pool ...
Exercise Treatment for Abnormal materialized view log
One application would like to copy the data using materialized views, in order to cope with possible future problems, do the first abnormal test. Structures using the rowid materialized views to create an environment for rapid updates: Create a user ...
Oracle table or view can not be deleted error, error code: ORA-00942
Hibernate code written today, when will want to save to the Oracle database, a "table or view does not exist" error, but when entered into the database table is found to exist, and can edit, after analysis, found that as the establishment o ...
Oracle data dictionary used
Source: Net sea cockle-pickers The following table collected almost all the Oracle data dictionary views or aliases, as each view, or alias of the field, please use the 'Describe' statement to query. Name Description: Oracle data dictionary, ...
html page displays the database out of the large segment java approach using text wrap
Suppose jxqk stored in this field was a text, taken out from the database, indicating the need for change when the line processing in order to achieve neat results. rn rn String jxqk = rs.getString ( "jxqk"); if (jxqk == null) ( jxqk = &quo ...
From the middle of the page with the session to prevent the landing
Landing page login.jsp pass two parameters: user name "ID" and password "PWD", made after verification page check.jsp get handled as follows: rn rn String "ID"); String password = request.getParameter ( "PWD"); ...
Automatically return to the previous page of code
Suppose a page of information submitted to the second page after the (only shows whether the success of the prompt submission of information), to get the second page in a few seconds automatically return to the first page, second page need to add the ...
DBF file import and export
1.DBF file import rn rn Statement stmt = conn.createStatement (); ResultSet rs = null; String sql = null; SmartUpload mySmartUpload = new SmartUpload (); rn mySmartUpload.initialize (pageContext); mySmartUpload.upload (); String file_name = "&qu ...
MySQL modify your password and access restrictions set Xiangjie
1, MySQL Change Password Methods The first to point out is this: Under normal circumstances, modify the MySQL password is needed inside the root access mysql, so the average user can not change your password, unless the request to help modify the adm ...
Oracle database system experience with six
Oracle database system experience with six Villa http://Tech.acnow.net 2006-7-18 19:15:07 Bibo 1.having clause usage having on the group by clause by clause to determine the line group control, having clause conditions allow only involves constants, ...
oracle startup shell script
#! / bin / sh cmdname = "restart" # Get oracle sid information from env by default. oracleSID = $ (ORACLE_SID) env_oracleSID = $ (ORACLE_SID) function echohelp ( echo "****** oracled Tool Helper ******" echo "Usage: sh oracle ...
ORACLE9I in the use of external table
External table and regular tables is very similar to a specific definition can be found in "Oracle concepts manual", the following points require attention: "Creating the syntax is similar:" CREATE TABLE ... ORGANIZATION EXTERNAL ...
Install Oracle9i (9.2.0.4) on Fedora Core 3
Install Oracle9i (9.2.0.4) on Fedora Core 3 I. Prepare the files 1. Download ship_9204_linux_disk1.cpio.gz, ship_9204_linux_disk2.cpio.gz ship_9204_linux_disk3.cpio.gz from www.oracle.com to your local disks.Unzip them all. gunzip ship_9204_linux_dis ...
sql plus set of variables to use in helping
1. Statement bind variables rn SQL (c3rpt)> var SYS_B_0 varchar2 (10) SQL (c3rpt)> var SYS_B_1 varchar2 (10) SQL (c3rpt)> var SYS_B_2 varchar2 (10) SQL (c3rpt)> var SYS_B_3 varchar2 (10) SQL (c3rpt)> var SYS_B_4 number rn rn 2. To bind ...
bat calling sqlldr batch import data
As a DBA should always deal with the data, this time the user submits a batch of text files, basically there is a pattern, a total of more than 100 documents, if in turn change the sqlldr control file, the workload can be imagined The use of bat prog ...
Error loading database: areasQueries - Oracle login information on problems and solutions encountered in
Today, when installed, has been prompted as follows: Installation Oracle9.2.0.1 process, when filling out your home directory name and its full path, click "Next", the installer starts to load products, when the rn Loaded to 99%, the error: ...
oracle initialization parameter file
1 WINDOWS 2000 under the examples: Parameter file record data instance configuration parameters (such as the System Global Area SGA), the data buffer, the log buffer and some non-default parameters; its storage path:% ORACLE% \ Admin \% SID% \ pfile ...
TO_DATE use Xiangjie
Always use the to_date function to query the data within a specific time. However, each time re-use someone else's written statement about the date change has been the format of the function of the TO_date not know. Read this book above the to_da ...
Oracle user's password contains special characters, how to deal with cases of "/" How to export data?
Author: olivenan MSN: olivenan@hotmail.com Usually we set Oracle password password will be set up more complex and special symbols are generally composed of alphanumeric However, there are special symbols, modify your password, or the import and expo ...
Oracle data dictionary frequently used
rnrnrnrnrnrn rnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrnrn rn The following table in the Oracle data dictionary has collected almost all of the views or aliases, as each field of view, or alias please 'Describe' statement to query. rn Name Description ...
Not install ORCALE CLIENT using the OCI
1, download instantclient rn http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html rn 2, set the correct character [HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE] "NLS_LANG" = "AMERICAN_AMERICA.ZHS16GBK" ...
(Turn) Oracle expert must-read, do not miss Oh!
http://bbs.chinaunix.net/viewthread.php?tid=571133 1. Note the table to delete a table in the deletion of all data, should use TRUNCATE TABLE table; because using DROP TABLE, DELETE * FROM table name, when, TABLESPACE tablespace of the table space wa ...
Oracle Forms Server Troubleshooting
Oracle Forms Server Troubleshooting Oracle Technical White Paper 1 CHECKING FOR FORM_SUCCESS AFTER CALLING A FORMS BUILT-IN After calling a form, through the FORM_SUCCESS built-in subroutine to return a form can be expressed as a recent success of Boolean
Easy to get construction Oracle 9i table and index DDL statement
1, access to a single table and index DDL statements methods: set heading off; set echo off; Set pages 999; set long 90000; spool get_single.sql select dbms_metadata.get_ddl ( 'TABLE', 'SZT_PQSO2', 'SHQSYS') from dual; select ...