Oracle

1. ORA-12541: TNS: No listener Cause: the listener is not started or damaged. For the former, run the net start OracleOraHome81TNSListener command (the name may be different). For the latter, you can add a listener to "Listener Configuration" in the

I. Move data files: -You can use alter database or alter tablespace to move data files. 1. alter database method; -This method can be used to move data files in any tablespace. ◆ STEP 1. database: $ Sqlplus/nolog SQL> CONNECT INTERNAL; SQL> SHUTDOWN;

After oracle9i is installed, enter the username, password, and host identifier to enter sal * plus. System/manager Sys/change_on_intall Scott/tiger Internal/oracle The above is the initial password The host string is null or @ + your service name.

701. USER_MVIEWSAll materialized views owned by the current user in the database.702. USER_NESTED_TABLESThe nested table in the table owned by the current user.703. USER_OBJ_AUDIT_OPTSAudit options for user-owned tables and views.704.

-- User-- View the default tablespace of the current userSelect username, default_tablespace from user_users;-- View the role of the current userSelect * from user_role_privs;-- View the system and table-level permissions of the current userSelect *

There are four functions that support regular expressions in ORACLE:1. REGEXP_LIKE: similar to LIKE2. REGEXP_INSTR: similar to INSTR3, REGEXP_SUBSTR: similar to SUBSTR4. REGEXP_REPLACE: similar to REPLACEThey are used in the same way as Oracle SQL

Export Several SQL statements of CLOB: 1. Export M records containing big field data Exp user/passwd statistics = none compress = n consistent = y file =/oradata/info/backup/exp_article.dmp log =/oradata/info/backup/exp_article.log tables =

Use UTL_SMTP of Oracle Database to send HTML mail create or replace procedure html_email( p_to in varchar2, p_from in varchar2, p_subject in varchar2, p_text in varchar2 default null, p_html

[Oracle]-[SNIPED and KILLED]-Example of the session cleaning process @ dbsnake danale for the SPINED and KILLED: SQL> show parameter limitNAME TYPE VALUE------------------------------------ -----------

Startup, startup mount, and startup nomount are different startup nomount options: (read the initialization parameter file and start the instance) startup nomount option to start the instance, but do not install the database. When the database is

The Automatic diagnosis tool ADDM is short for the Automatic Database Diagnostic Monitor. It is literally an Automatic diagnosis tool. This tool can discover potential performance problems and bottlenecks, and provides suggestions and solutions to

Common paging statements for repeated data in oracle rownum paging are as follows: Select * from (select row _. *, rownum rownum_from (select p. id from table1 porder by p. DATA_UPDATE_TIME desc) row _ where rownum ?  This problem occurs when the

Oracle Database Programming: dynamic SQL: it is a string at compile time, and it is only found to be an SQL statement at run time. When SQL statements cannot be used directly, dynamic SQL is used. dynamic SQL is divided into early binding (Fast

User-managed on-premise database cloning Oracle on-premise database replication or cloning is often used to provide a test or development environment. There are multiple methods to generate a clone database, such as using the cold standby mode for

Oracle basic mathematical functions 1. trigonometric Functions Sin asin sinhcos acos coshtan atan tanh [SQL] SELECT SIN (3.14159265/6), ASIN (1), SINH (1) FROM DUAL; -- all others are similar to ATAN2 (x, y) returns the arc tangent of the coordinate

Oracle sqlloader notes command: Sqlldr userid = username/pwd control = file log = logfile load data -- syntax keyword infile 'filename' -- data file for data import. The default format is. dat. If you want to import data from multiple files, then

Compared with the general views, the general views and materialized views of Oracle differ from the general views in that the materialized views manage stored data and occupy the physical space of the database. The results of the materialized view

Oracle V $ SESSION SADDR session addressSID session identifier is often used to link other columns SERIAL # SID may be repeated. When the SID of two sessions is repeated, SERIAL # is used to differentiate sessions (in other words, a session is

Oracle monitoring indexes use Oracle to provide a monitoring index method to determine whether an index is used. If indexes are not used, you can delete them to reduce unnecessary statement overhead. Because a large number of unnecessary indexes on

To Kill the session, turn off sqlplus. An error occurred while compiling a function today. I can't finish running it all the time. keep running and keep running. after kill the session, we can see that mark killed sqlplus is not switched off in the