Oracle

Redhat Linux AS4 install Oracle 10g (10.2)   1. Hardware requirements (1) memory> 1024 MB Memory swap Partition > 1024 MB 2 times memory > 8192 MB 0.75 times memory Display memory commands 2)/tmp> 400 M 3) detection command Memory # Grep

SQL * Loader is a tool used to import external data from Oracle databases. it is similar to the Load tool of DB2, but has more options. It supports variable loading modes, optional loading and multi-Table loading. How to use SQL * Loader We can use

Custom Aggregate functionsIntroduction to custom aggregate function InterfacesOracle provides many predefined Aggregate functions, such as Max (), Sum (), AVG (), however, these predefined Aggregate functions are basically applicable to scalar data.

1) Full Table scan (Full Table Scans, FTS)To scan the entire table, Oracle reads all rows in the table and checks whether each row meets the WHERE restrictions of the statement. Oracle reads each data block allocated to the table sequentially until

In Oracle 10 Gb, the Flash back family is divided into the following members:Flashback DatabaseFlashback DropFlashback TableFlashback Query (Flashback Query, Flashback Version Query, and Flashback Transaction Query)The following describes Flashback

What is the difference between number and BINARY_DOUBLE in oracle?The main advantage is: it is more efficient than number, faster, and takes less space, but the version compatibility is poor.Numeric numeric typeNUMBER: this is a real decimal data

Enter "sqlplus/as sysdba" in the Command window and press enter to connect to Oracle, for example, C: \> sqlplus/as sysdba SQL * Plus: release 11.2.0.1.0 Production on Tuesday April 17 10:05:34 2012 Copyright (c) 1982,201 0, Oracle. all rights

Explore the RMAN_05 Incremental backup link in ORACLE: Explore the RMAN_01 concept in ORACLE http://www.bkjia.com/database/201205/132243.html Explore the basic use of RMAN_02 in ORACLE http://www.bkjia.com/database/201205/132329.html ; Explore

Oracle DDL, DML, DCL, and TCL summarize the impetuousness of some time ago. I always think this will happen too. But when I wake up, I find that I don't know anything, and I don't even know the basic concepts, let's start from scratch and study for

To query all the user tables in Oracle, USER_TABLES sometimes needs to clean up, count, and analyze existing databases. This requires you to know how much data there are in the databases. in Oracle, you can use the view USER_TABLES: SELECT * FROM

ORA-01017 invalid username/password; logon denied "password loss solution 1. First confirm whether to enter the wrong user name and password www.2cto.com 2. If the password is indeed lost: View sqlnet. ora for SQLNET. AUTHENTICATION_SERVICES = (NONE)

Oracle Data Import and Export imp/exp sp2-0734: Unknown command starting with 'Imp... worksp2-0734 und: Unknown command starting with 'Imp ignored the remaining line default classification www.2cto.com should be executed at the cmd doscommand prompt,

Usage of row_number () over (partition by xxx order by xxx) in Oracle row_number () over (partition by a order by B) in www.2cto.com, the query results are grouped by the field (partition), and then sorted by the B field in the Group. As for asc or

Oracle trigger 3-DDL trigger Oracle trigger 2-DML trigger http://www.bkjia.com/database/201304/200549.html DDL trigger, which is triggered when a DDL statement is executed. Schema triggers and database triggers are divided according to the scope of

Oracle trigger 5-Instead of trigger Oracle trigger 4-database event trigger http://www.bkjia.com/database/201304/201423.html The Instead of trigger can be used to insert, update, delete, and merge tables in a view composed of more than one table.

What Oracle DBA should do on a daily, weekly, and monthly basis (I) Check alert on a daily basis. log ② check the environment ● check whether the database instance is working properly ▼ ps-ef | grep ora _ explain select status from v $ instance ●

[Oracle] undo corruption without backup. What should I do if undo corruption is unfortunately encountered in Oracle running? Of course, the best way is to recover completely, but if there is no backup, you can use an unconventional method (using

"Oracle Universal Installer has detected that there are processes running solve today's case: When AIX6 upgrades 10.2.0.5 at 10.2.0.1, the oracle Universal Installer has detected that there are processes running in the currently seleted oracle Home.

Oracle Database Programming: Develop PL/SQL subprograms and packages to develop PL/SQL subprograms and packages: subprograms: Compile rather than run at run time. Only calls can produce results. Subprograms are divided into store procedure and

Oracle operating system identity authentication using lelogin Database Remote Login authenticationossqlnet. authentication_services = (CNT), in $ ORACLE_HOME/network/admin/sqlnet. in ora, the operating system is windows or all. operating system