Oracle

1. Remote connection Oracle does not need to open Oracle Services, can be managed in the service, save a bit of resources2. Modify the tnsnames.ora file in the Oracle directory my directory is: D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\

Personally, I think it's a good writing.http://blog.csdn.net/wanglilin/article/details/7200201Demand:Update the records in the T2 (T_STATBUF) table with the same ID as the T1 (T_MT) table into the T1 table.1. The wrong wording: 1 update table_name T1

-- Build Tables sql> CREATE TABLE Tbook (bookId number (8), BookName varchar2 (50), Publishhouse VARCHAR2 (()); -- writing process -in: input parameters; Begin INSERT INTO Tbook values (spbookid,spname,sppublishhost); end;--Called in Java

1. Oracle ORCL VSS Writer Service.Oracle Volume Mapping copy write service, VSS (Volume Shadow Copy service) enables the creation of high-fidelity point-in-time images (Shadow copy) of storage infrastructure devices such as disks, arrays, and so on.

The Swingbench is an open source Oracle Stress test Tool on the Web that supports the Oracle 11g version and also tests the RAC. The latest software version can be downloaded from the official page http://dominicgiles.com/downloads.html.650)

Because yesterday to other companies to maintain the data, after the data to find that the table of feature content this column is empty, at first I thought it was the data is a problem, and later found that the type of data in the table is CLOB

Oracle establishes tablespaces and usersSteps to establish a tablespace and User: Create user username identified by "password"; authorization: Grant create session to username; Grant CREATE table to username; Grant create

Analyze table TableName compute statistics;Analyze index IndexName compute statistics;For the benefit of using the CBO, more reliable table information can be used, so that the execution plan can be more accurate, the 10g will be automatically

The LAG () and lead () statistics functions are able to fetch the first n rows of the same field and the values of the last n rows in a single query . Such operations can be implemented using table joins to the same table, but using lags and leads

There are two ways in which Oracle Biee implements cell hyperlinks:① custom cell text is HTML;② Customize the custom cell text.The effect is as shown, where the left column is in the form ①, and the right column is the ② effect.Mode ① operation

A: PrefaceSince the internship, basically did not press the heart to summarize the knowledge point of their own, just good now soon National Day, not to Shenzhen business, in the company stayed three days, it can be said in the company played three

1. Static configurationOracle has long supported dynamic listener, but still requires static configuration when using premium goods such as the OEM (Oracle Enterprise Manager)Tools: Netca+netmgr (or directly modify the/network/admin below the

Pctfree,pctused,initrans,maxtransPctfreeWhen a block's usage space reaches the 100-pctfree value, the block is detached from the free list. For example, Pctfree is 10, then when the block uses 90% it will be out of freeelist, and subsequent inserts

Statement ************************************************************** *********Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.Please leave a

CreateTablespace Tbs_dys datafile'd:/oracle_12c/app/dingyingsi/oradata/dingyingsi/tbs_dys.ba'Size 1024m Reuse Autoextend on Next100m maxsize UNLIMITED extent management local;CREATE TemporaryTablespace tbs_dys_temp

Oracle Static Monitoring RegistrationThere are many articles on the internet about Oracle monitoring static registration, but most of them are simple to say, and there is no detailed example, here, will be combined with Linux AS4 under the Oracle

Oracle Simple Script Example1. Add a table-- Date Modified: 2014.09.21-- modified by: Yixian-- What to modify: New Purchase Payment status TableDECLARE vc_str VARCHAR2 (5000); vn_count number;BEGIN -- See if the existing system has a

Before installing Oracle software under Linux, there is considerable work to be done, including setting up users, configuring kernel parameters, configuring resource throttling parameters, and configuring Oracle user environments. Even if you are

The left and right connections of data tables. Http://www.cnblogs.com/LeoTerry/archive/2010/03/26/1696988.html  Data Table connections include: 1. Inner join (natural join): Only the rows matching the two tables can appear in the result set. 2.

The Oracle11g password is locked and reported to the ORA-28000theaccountislocked I. Reasons for triggering this error and Related Factors This is because "PASSWORD_LIFE_TIME = 180 days" is set in the default profile in oracle11g by default.The