Oracle

1. Exception {ORA-12505, TNS: listener does not currently know of SID given in connect descriptorThe Connection descriptor used by the client was: 10.190.121.95: 1521: sxzhdb} 2. query {ORA-12505: TNS: The SID---SID in the connection descriptor that

ORA 1653 and ORA 01502 Error Handling Methods 1.ORA 1653 error shapes such as: ORA-1653: unable to extend table ...... it indicates that the tablespace is insufficient. You can consider extending the tablespace www.2cto.com SQL code alter database

How can I increase the data loading speed of oracle swap partitions? CASE Environment: OS: linuxdb: oracle10g www.2cto.com where the data loading speed of a database is very slow? The following is a small example. First, calculate the SQL statements

Precautions for oracle full offline backup: Full offline backup, also known as cold backup. The existence of cold backup is to protect the site, so that we can start from scratch when recovery fails.We know that the data file is the disk space

Summary about the shortcut keys and usage skills of PLSQL recently encountered some troubles in the development process, that is, the development efficiency problem. Sometimes other colleagues use PLSQL to program more efficiently than themselves, I

Oracle SQL Summary 3: DDL Statement 5. DDL statement 5.1 Enable/Disable/Validate/Novalidate combination features: whether www.2cto.com meets the constraint that Validate Novalidate has been record added/modified record existing record

RMAN-06026 Error Analysis and Solution Background: we did not completely recover Based on SCN, and used the _ allow_resetlogs_uption parameter in the process of trying to recover, after resetlogs, oracle uses the current control file does not allow

Oracle Database Backup mode the Oracle Kernel provides a database backup and recovery mechanism. SQL * DBA backs up and recovers data by tablespace. Oracle provides two methods: Backup Recovery and forward rolling to ensure Database Consistency and

Oracle flashback table description flashback table purpose: 1. Use the flashback table statement to restore the TABLE to the status before a human error or application error occurs. 2. The amount of undo data in the system depends on how long it

The following describes how to debug a function. Other debugging operations are the same.1. Generally, there are two places to debug the program in pl/SQL Dev: 1). New-> test window: www.2cto.com2) Right-click the program to be debugged and choose

In the oracle query statement, the interpretation of select from where group by having order by and the keywords used in the application query mainly include six, and their order is select -- from -- where -- group by -- having -- order by, where

Basic Analysis of PL/SQL SQLSQL (Structured Query Language) is the basic operating Language of relational databases. It is an interface for applications to interact with databases. It integrates Data Query, Data Manipulation, Data Definition, and

In Linux, completely delete oracle step 1. Disable the oracle server and background process 2. Stop the oracle listener 3. Delete All subdirectories and files in the $ ORACLE_HOME directory (note: there will be an alarm when Deleting Users and user

In Linux, Oracle executes the SQL script and garbled characters appear in Chinese. To solve this problem, first confirm the character set of Oracle. After sqlplus logs on to Oracle, it executes the statement:[SQL] select userenv ('language') from

How to enable the Oracle Shared Server has unique advantages in some applications, as shown in the official description: reduce the number of instance processes, increase the number of external service users, reduce the number of useless or idle

Three left join statements for three oracle tables. The query result is: the first table is fully displayed, the other two tables show the connection information. The three tables are [SQL] SQL> select * from zr_stu; www.2cto.com stuid stuname

Connect plsql to other computers and find tnsnames under G: \ Oracle \ product \ 10.2.0 \ db_1 \ network \ ADMIN. ora file tnsnames. ora element: www.2cto.com # tnsnames. ora Network Configuration File: G: \ oracle \ product \ 10.2.0 \ db_1 \

Oracle provides a Web-Based Enterprise Manager (EM.First, enterHttp: // localhost: 1158/emYou can view the port in the/oraclehome/install/portlist. ini file. Different databases have different ports.After logging on to em, the interface is displayed,

When Windows 7 is enabled, plsql logon fails. A blank prompt box is displayed. Solution: Sometimes ORACLE is installed in Windows 7, and the database cannot be connected using cmd plsplus and plsql software. plsql reports a blank prompt box and

Oracle splits and merges table data in daily database operations. Let's take a look at how to implement it.Assume that the table TEMP_TABLE (ID, NAME, CODE) has the following data: [SQL] select t. * from temp_table t; id name code www.2cto.com 1 A 10