Oracle

The database alert log appears ORA-20011 KUP-11024 errorsThu Sep 22 18:00:31 2016Dbms_stats:gather_stats_job encountered errors. Check the trace file.Errors in

Oracle Create, delete database LINKCreate Dblink: Create database link [name] connect to [username] identified by [password] using ' (DESCRIPTION = (address_ LIST = (address = (PROTOCOL = TCP) (HOST = [IP]) (port = [port]))

PS: Recently because of work need amateur in learning Oracle, through the SECURECRT or Putty SSH client to telnet to the Linux Oracle Sqplus, after a typo, press backspace key or DEL key Delete, will appear ^ h or other messy characters, feel very

Oracle Oracle's Sql*plus is a client tool that interacts with Oracle. In Sql*plus, you can run the Sql*plus command and the Sql*plus statement. Our usual DML, DDL, and DCL statements are sql*plus statements that, when executed, can be stored in an

Case studies on how the Php/oracle development model shortens the application lifecycle on the Myers Internet. For companies that are primarily driven by the receivables business model, one of their core business functions is to enter, track, and

About several Oracle functions that handle the number of decimal places ()1. Rounding of several decimalsSelect Round (1.2345, 3) from dual;Results: 1.2352. Reserved two decimal places, onlySelect Trunc (1.2345, 2) from dual;Results: 1.23Select

Learning Oracle is a complex and tedious process. In the face of a vast array of Oracle official materials, new features, MOS materials and a variety of internal knowledge, we always feel overwhelmed. However, this is often the fun we keep,

The general step to add a non-empty column is to add a column that can be empty first, and then update that column to a value (such as 0) and finally modify the typeBut it's not going to meet the type CLOB. In modify this step times wrong: ora-22296:

The disk is now worthless, so a LUN that is mapped from storage to the host may be large.Recently encountered a problem: 2 Windows hosts to use as RAC, storage mapped to Windows a disk has a 10T size. As we all know, the shared disk in Oracle RAC

Oracle Online redo log files (online redo log fileAlmost all of the internal changes that occur in Oracle are recorded in the online redo log file, and Oracle uses these redo log groups to recover the database, so they are very important.The main

The recent discovery of Oracle 11g on a cloud server in the Export Times error is as follows:.... Exporting Post Table Activity. Exporting the manifested view. Exporting snapshot logsEXP-00008: Encountering ORACLE Error 1455ORA-01455: Converting

The problem is as follows:Sql> Conn Scott/[email Protected]_databaseConnected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0Connected as Scott。。。。。。sql> drop table Student2;drop table Student2ORA-00054: The resource is busy, but the

How to use database development tools such as navicat for efficient development will be the focus of future work. Navicat is beautiful enough to operate a fool, and its powerful features are comparable to PL SQL. Today's study is how to use data

Where is the Oracle SQL Developer connection information saved?Oracle SQL Developer connection information is missing after switching the logged-on user. As long as the previous user information still exists, you can C:\Users\ the user name \appdata\

First, the database nameWhat is a database name?The database name is the identity of a database, just like a person's ID number. He uses parameter db_name to indicate that if a machine is loaded with multiple databases, then each database has a

SQL statements are best executed in turn to create/************************************** * Name:split * Author:sean Zhang. * date:2012-09-03. * Function: Returns the type of the table after the string is split by the specified character.

In Oracle 11GR2, the login audit information for SYS users is logged by default in the Audit_file_dest directory, but the operation content is not audited.Enable auditing of SYS user action behaviorSql> alter system set AUDIT_SYS_OPERATIONS=TRUE

 I. Problem Description   Installation environment: Oracle Linux 6.1 Database: 10.2.0.1   When Oracle 10g RAC is installed, an error is reported when root. Sh is executed on the first node, as shown below:   [Root @ Rac1 ~]

  1) classification of Sets Oracle supports three types of collections: Associative array (Index-by table) Nested table) Variable-length array (VARRAY) One of their differences is that the Nested table and VARRY can be used either in PL/SQL or

Oracle date functions/character functions/numeric functions/conversion functions/Aggregate functions Oracle date functions: [SQL] MONTHS_BETWEEN: returns the difference of the month between two dates MONTHS_BETWEEN ('01-EP-95 ', '11-JAN-94 ') ==> 19.