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

In oracle10g, If you accidentally drop a table, Can you restore it? The answer is yes. In oracle10g, when you run the drop table tablename command, the table will not be deleted, instead, the table is stored in the recycle bin (the recycle bin

Oracle Data Type parsing char: a maximum of 2000 characters, less than space filling. It is highly efficient to use the char type for fields with fixed length and frequently queried, because the exact match of the fixed length is not a waste of

Automatically add a partition stored procedure for a partition table: the SQL code create or replace procedure guan_add_partition/* automatically adds partitions for all partition tables under a user. the partition column is of the date type. The

Oracle 10g wmsys. use of the wm_concat row-and-column Conversion Function: first, let's take a look at the Magic function wm_concat (column name). This function can separate the column values with "," and display them as a row, the following example

Summary of common oracle errors 1. Oracle is case sensitive. 2. trim ('aa bb cc. ') removes spaces at the beginning and end of the string without removing spaces at the center. 3. Columns cannot be enclosed by single quotation marks ('') when

During routine maintenance, users of a Database need to be migrated to another database.You must create the same user and related permissions in the target database,Relevant user and permission information can be easily obtained, but in case the

View the number of fields in a table in the database. query the total number of fields in a table in Oracle. Use an SQL statement or [html] select count (column_name) in PL/SQL) from user_tab_columns where table_name = 't_ B _auditor 'can be used to

Complex query statement 1 in Oracle: list the names and department names of all employees, and select a1.ename, a1.sal, a2.dname from emp a1, dept a2 where a1.deptno = a2.deptno; 2: list all Department details and department count; select a2.deptno,

Oracle Real-Time Interpolation Speed suddenly slows down problem solution a warehouse receiving program is written in the work, which is responsible for real-time unpacking, parsing, and inserting SQL statements into the Oracle database.The average

Before I sorted out the database, the exported database tables had more than 270 mb. After the database was imported, the table space reached 20 GB.This is what happened. The database has been cleared several times. Recently, the database has just

Note the following when installing RHEL5:1. Set the hostname ). 2. Set the IP address, mask, gateway, and DNS. 3. Set the firewall to open port 1521 corresponding to tcp. 4. SELinux is prohibited. 5. Create an oracle user. Www.2cto.com: Enter the

1. character type data type length description CHAR (n BYTE/CHAR) is 1 BYTE by default. The maximum value of n is 2000 and spaces are filled at the end to reach the specified length. If the maximum length is exceeded, an error is returned. The

Analysis of database transactions and concurrency the four attributes of transactions: atomicity: a transaction is an inseparable unit, and the operations contained in the transaction are either fully executed or not executed. Consistency: the

Oracle remote logon solution: Oracle remote Logon: in cmd: sqlplus scott/tiger @ oracle // there is no space between tiger and @ (and no space is allowed ), the name of the remote connection service added by oracle in netca is in cmd: sqlplus/nolog

ORA-00600: internal error code, arguments .. problem: When querying the wwl005 table, an internal error is reported. For this table, we just restored the inconsistency, and then the following error is reported during the query, this is generally

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

Read how Oracle Errorstack Output Wirte By tanelpoder, translation by me. When oracle has critical errors such as: ora-600, Errorstack dump is automatically dumped By oracle dump. When you see an error in alert. log, it will generate a trace file

Oracle extended tablespace 1. view All table space usage select B. file_id File ID, B. tablespace_name tablespace name, B. bytes/1024/1024 | 'M', (B. bytes-sum (nvl (. bytes, 0)/1024/1024 | 'M' is used, sum (nvl (. bytes, 0)/1024/1024 | 'M'

Oracle note (12) collection and sequence links: Oracle note (1) Oracle introduction and Installation http://www.bkjia.com/database/201209/154049.html ; Oracle notes (2) SQLPlus command http://www.bkjia.com/database/201209/154051.html Oracle note (3)