Oracle

After the Oracle database is copied or cloned, it is often necessary to modify the user name and password, and the following summarizes the methods and steps to modify:1, Query system table user$SELECT name,user# from user$ WHERE UPPER (TRIM (name))

1. Set the length of each line:SET Lin[esize] 200;2, set the number of pages:SET Pages[ize] 50;3. View table space Related information:Select file_id, Tablespace_name, file_name from Dba_data_files;4. View all the tables in the system:Select owner,

1 Version InformationOracle Database version: Oracle release 10.2.0.1.0System version: Red Hat enterpriselinux 5.42 Detection Step 2.1 writing a shell scriptUnder users who have Sqlplus Execute permissions, edit the check_oracle_connection.sh script.

The statistics of the global temporary table cannot be collected, if it is collected, its statistic is definitely 0, it will cause the execution plan is not allowed, so we should lock up its statistic information and prevent the system from

From :Http://www.itpub.net/thread-1636118-6-1.htmlWhen Oracle opens the archive mode, it generates a lot of archivelog files in the specified archive directory, and the default is not to be purged periodically, and the folder takes up a lot of space

1. ORA-12560:TNS: Protocol Adapter errorOracleservice Service not started2, Ora-12541:tns: No monitoring programOracletnslistener Service not started3. Ora-12514:tns: The listener does not currently recognize the requested service in the connection

Description: JAVA springmvc+mybatis (Oracle and MySQL) HTML5 new tall background framework1. Support App mobile app (Android and iOS) interface call (JSON interface can be interfaced with other programs)2. New tall Changquan html5+css3.0 development

There is a recurring problem where one of Oracle's tables suddenly fails to update, either through PL/SQL Developer or through Sqlplus, to execute an UPDATE statement or to execute a SELECT * FROM table_name for update All the same, has been in the

Use of the Oracle Export tool Exp: 1. Fully export the database test (remote database must be a connection identifier), username system, password Manager, export to D:\DAOCHU.DMP: Exp system/[email Protected] File=d:\daochu.dmp full=y 2, export the

Collection Key Words:1 , UNION: Set, all contents are queried, repeated display once , Sort Ascending By default ;2 , UnionAll: The collection, all the content is displayed, including the duplicate , there is no sort of display content ;3 ,

VBA Round is based on the silver Connoisseur algorithm (rounds to the nearest even number)Round (1.5) = 2Round (0.5) = 0Implementing Banker Algorithms in Oraclesql> Create or Replace function Bankers_round (val number, rnd_digit number: = 0) return

Before 11g, add a field with default value, the implementation principle is as follows:ALTER TABLE T1 add C1 varchar2 (a) default ' XX ' NOT null;Assuming that the T1 table has 40 million rows of data, Oracle returns a "Success Prompt" to the user

The client Oracle server enters the PL/SQL developer times ora-01033:oracle Initializationg or shutdown in progress error message that the application system cannot connect to the Oracle service. Solve the problem by remote guidance. The process is

Description: JAVA springmvc+mybatis (Oracle and MySQL) HTML5 new tall background framework1. Support App mobile app (Android and iOS) interface call (JSON interface can be interfaced with other programs)2. New tall Changquan html5+css3.0 development

Modeled http://blog.csdn.net/makenothing/article/details/170800691 Adding a database connection to the Oracle connection VS2010Get the connection stringData Source=server1; Persist Security info=true; User id=s227; password=xxx; Unicode=truexxx for

Oracle backup Import * *** If you want to save it as a bat file, you 'd better use Chinese Characters Import: Imp clsoftoa/clsoftoa @ orcl124 -- username/password of the database to be imported @ Database Name Fromuser = 'clsoft 'touser =

Select count (*) and select count (1), selectcount Original article: http://blog.csdn.net/hzhsan/article/details/9186831 Generally, the returned results are the same for Select Count (*) and Select Count (1 ). If the table does not have a Primary

Oraclerman recovery from different machines     Oracle source host Oracle target host Host Platform CentOS6.2 (final) CentOs6.2 (FInal) Host Name Vick Rman IP address 192.168.1.11 192.168.1.

Oracle-function exercise /** Scm_iss.test_imti_fun2 * Function with input parameters */create or replace function TEST_IMTI_FUN2 (P_NO in number) RETURN VARCHAR2 IS P_IMTI_NAME VARCHAR2 (200); P_IMTI_DESC VARCHAR2 (200 ); p_RETURN VARCHAR2 (200);

DBA_Oracle Archive Log basic application and enabling (concept), dba_oraclearchive BaoXinjian I. Summary Archive logs are backups of redo logs. Archive logs are used for media recovery. Log Operation Mode 1. Noarchivelog (non-archive Mode) Do not