Oracle

Some of the operations that Oracle uses are documented:1. Steps to establish tablespace and User: User establishes:create user  user name  identified by  "password"; authorization:grant create  session to  User name;            grant 

Use profile for password restrictions. Oracle automatically establishes a profile called default when the database is established, and Oracle assigns the default to the user when it is established without specifying the profile option.(1) Account

Unlike databases, Oracle Clusterware has a rich view, tools to assist with diagnostics, and its log and trace files are the only choices. But unlike Oracle's only alert logs and several trace files, Oracle Clusterware's log system is more complex,

First, the system table:1. User_tables: Store information of all the tables under the user;2. Dba_tables: Store All the information of the table under Administrator's permission;3. All_tables: Stores information for all tables.Second, determine

The main function of the minus operation in Oracle is to return records that are not the same as the second table/query results in the first table/query results when two tables or two query results are performed.records with different results are in

The database and the client are on different machines.Before installing, navigate to the following folder on the server where the Oracle database is installed.Change localhost in Listener.ora and Tnsnames.ora to the IP address of the machine, my 192.

oracle10g after the installation is complete, the value of Global_name is not only ORCL, but also the domain name, and very long, difficult to remember. So think of ways to change the value of Global_name.Conn/as SYSDBAShow parameter

Oracle does not support top NSELECT * FROM (SELECT * to T_weixin_homework ORDER by SUBSTR (hometitle,0,10) desc) where rownumOur main discussion today is the actual operation of Oracle's implementation of SELECT TOP N, the following is an

Original address: http://www.cnblogs.com/simplefrog/archive/2012/07/30/2615169.htmlGrammarDelete from AATRUNCATE TABLE AAdifference1.delete from the back can write the condition, truncate not.2.delete from records are deleted, each row of records

[Email protected] orcl]$ Sqlplus sys/Sys as Sysdbasql*plus:release 11.2.0.1.0 Production on Wed Oct 8 18:54:09 2014Copyright (c)1982, 2009, Oracle. All rights reserved. Connected to:oracle Database 11g Enterprise Edition Release11.2.0.1.0-64bit

1. View All Users:SELECT * from Dba_users;SELECT * from All_users;SELECT * from User_users;2. View user or role system permissions (System permissions that are directly assigned to a user or role):SELECT * from Dba_sys_privs;SELECT * from

What you don't know about javasleredologbuffer [ora11@lixora ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Wed Oct 8 09:57:50 2014Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise

Install Oracle10G in windowsUnzip 1.decompress the file 10__database_win32.zipand double-click setup.exe under the project. The installation interface is displayed as follows: Enter the password and confirm the password, for example, password.

Install Oracle11G in WindowsUnzip the win32_11gr2_database_1of2.zipand win32_11gr2_databasesilicate f2.zip files. Note: extract the two files to the same directory, that is, merge the Components directories together. Double-click setup.exe. The

SQL Character Segmentation: SQL Character Segmentation For oracle, character string splitting is often encountered during string processing. Unfortunately, the SQL statement does not contain the split function. This is quite confusing for us to

Oracle11gR2 cannot export an empty table with exp Oracle 11gR2 cannot export empty tables with exp Solution There is a new feature in 11gR2. When the table has no data, no segment is allocated to save space. Oracle cannot export empty tables when

Check the script for the ORACLE warning File Check the important information within two days: Vi alter_error.sh Echo "Check Alter Error: "cat $ TRACE/alert _ $ ORACLE_SID.log | grep-E ^ ORA-\ | Reconfig \ | abort \ | Shut \ | ^ Start \ | error \ |

Sort related concepts in oralce 【Database Name] Concept:It is a database identifier, which is equivalent to our ID card. If multiple databases are installed on one machine, each database has a database name, when these database names are created,

Oracle version description Oracle has many version numbers. First, let's look at a version number of 11g: Note: After oracle 9.2, the maintenance release number of oracle is changed in the second digit. Before that, it was in the third digit. 1.

Check whether Oracle32-bit or 64-bit (x86orx64) Method 1: Use sqlplus ### 64-bit: [oracle @ db01 ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.3.0 Production on Fri Oct 318: 44: 05 2014 Copyright (c) 1982,201 1, Oracle. all rights reserved.