Oracle

Voting disk ):Voting disk records the node member information, such as the node members and Node Deletion records. The size is 20 MB.View voting disk location: crsctl query css votedisk$ Crsctl query css votedisk0. 0/dev/rhdisk3If the CRS

Comparing the Simple Writing Method of cursor with official documents, it is very common to use cursor in storage, and traditional writing is troublesome. Summary: The format of www.2cto.com is as follows: [SQL] create or replace procedure ff as

Oracle audit lab audit queries what operations a user performs on a table, such as select, delete, insert and so on 1. Open the audit function www.2cto.com SQL> show parameter auditNAME TYPE VALUE =----------- audit audit_file_dest

Use PLSQL Developer to import and export excel table data from oracle database to excel file: www.2cto.com execute the query statement, query the data to be exported, and select them (right-click select All) -- Right-click copy to excel, but note

Sqlplus spool to dynamic log file name through the sqlplus spool function we output the results of routine database O & M to the log file, and sometimes it needs timed output, in order to avoid repeated log file names, the output log file name can

How to connect to the specified database using the tnsnames. ora file of the oracle database for the given server name, user name and password, for example: server name 192.168.0.20, user name and passwordAll are w_basketboy. The method to connect

How to enable the sqlplus AutoTrace function execution plan the following methods can grant the Autotrace permission to Everyone. If you need to restrict the Autotrace permission, you can change the public authorization to the specific user

Oracle | PL/SQL sets auto-increment of primary keys. Oracle does not set auto-increment of primary keys. You need to set the sequence and trigger to auto-increment of primary keys. Example: create a table menu: [SQL] create table menu (menuId number

Oracle error: "ORA-18008: unable to find the OUTLN solution" connected to Oracle today error: ORA-18008: unable to find the OUTLN solution, the day before yesterday also used well, the error message is displayed no matter whether you query any SQL

Oracle Data Guard (2) Physical Standby 1. check whether the Primary database is archivelog mode SQL> select log_mode from v $ database; if the result is not "ARCHIVELOG", run the following command: SQL> shutdown immediate; SQL> startup mount; SQL>

Sqlplus cannot be initialized and sqlplus is automatically disabledFirst, install the oracle database. After installation, enter sqlplus In the cmd command window for verification. If there is something that cannot be initialized, configure it.

Oracle trigger 4-database event trigger Oracle trigger 3-DDL trigger http://www.bkjia.com/database/201304/201421.html Create database event TRIGGER Syntax 1 CREATE [or replace] TRIGGER trigger_name2 {BEFORE | AFTER} {database_event} ON {DATABASE |

About Oracle Data Guard Role Switching 1. Overview Oracle database uses its Data Guard technology to implement a remote security mechanism for Data in Oracle databases with real-time remote Data over the network. The implementation process is

Data Query Language (Oracle VS MySQL)Simple QuerySuppose there is such a table students:STUDENT_ID MONITOR_ID NAME SEX DOB SPECIALTY------------------------------------------------------------10101 Wang xiaofang female-88 computer10205 Li qiufeng

Oracle SQL * Loader Features analysis Features: SQL * Loader loads data from external files into tables of an Oracle database. it has a powerful data parsing engine that puts little limitation on the format of the data in the datafile. you can use

[Oracle problem set 3] ORA-12543: TNS: destination host unreachable Description: [oracle problem set] is the problem encountered by the bloggers usually operate the database and the solution. Statement execution: Indicates An error occurred while

Oracle log file switch (checkpoint incomplete) solution Description: oracle log file switch (checkpoint incomplete), Every 15 min, tpm will drop to almost zero. cpu load is not high, very low. 1 set the parameter: alter system set

[Oracle]-[synonym]-public and non-public synonyms [Symptom]: The Sys account creates a public synonym for the t_emp table of the bisal account. The bisal user can access t_emp_syn, but the scott account cannot query, select... t_emp_syn indicates

Error installing database C [ld-linux-x86-64.so.2 + 0x14d70] On RedHat6, when installing Oracle 11g R2, run runInstaller and immediately jump out of the following error. # An unexpected error has been detected by HotSpot Virtual Machine: # SIGSEGV (0

ORA-01795: List of the maximum expression number is 1000 solution detailed system error, dizzy, I began to find, the original really have a problem, take a look at SQL, it turns out to be an SQL statement containing IN, while IN contains a large